红移查询语法错误(使用)：是否有一种简单的方法可以直接到达错误中提到的“位置”？

Question

是否有一种简单的方法可以直接到达/Redshift中的错误消息(代码下面提供的错误)中提到的位置？谢谢!

以下是错误：

执行SQL命令时出错： 选择application_id，在stage_name中选择(“申请评审”、“新领导”、“招聘人员评审”、“伸出援手”、. 位置: 201；SQL State=42601，DB Errorcode=500310 1语句失败。 执行时间: 0.16s

以下是查询：

    select
    application_id,
    case when stage_name in (
      'Application Review',
      'New Lead',
      'Recruiter Review',
      'Reached Out',
      'Make Decision',
      'Resume Review',
    ) then 'Application Review' 
    when stage_name in ('Preliminary Phone Screen', 'Recruiter Screen','Handoff','Researcher Screen','Exploratory') then 'Recruiter Screen' 
    when stage_name in (
      'Phone Interview',
      'Phone Interview 2'
      'Phone Interview #1',
      'Phone Interview #2',
      'Phone/Initial Interview #1',
      'Phone/Initial Interview #2',
      'Hiring Manager Review',
      'Hiring Manager Screen',
      'Final Interview',
      'Take Home Test',
      'Initial Interview') 
      then 'Initial Interview' 
    when stage_name in 
    ( 'Onsite Interview #1',
      'Face to Face',
      'Face to Face 2',
      'Onsite Interview #2',
      'Onsite Interview') 
      then 'Onsite Interview' 
    when stage_name = 'Homework' then 'Homework' when stage_name in 
    ( 'Post Onsite',
      'Reference Check',
      'Hiring Review',
      'Hiring Review Debrief',
      'Hiring Review/Debrief',
      'Post Hiring Review / Debrief',
      'Post Hiring Review/Post Debrief',
      'Hiring Review / Debrief',
      'Post Hiring Review / Post Debrief',
      'Team Match') 
      then 'Post Onsite' 
    when stage_name = 'Byteboard Interview' then 'Byteboard Interview' 
    when stage_name IN ('Filtered','Filtered.ai Matching') then 'Filtered' 
    when stage_name = 'HackerRank Test' then 'HackerRank Test' 
    when stage_name = 'ClassMarker' then 'ClassMarker'
when stage_name = 'Offer' then 'Offer' 
else 'Other' end as app_Stage_Name_group,
    min(entered_on) as entered_on,
    max(exited_on) as exited_on
  from
    application_stages
  where
    entered_on is not null
  group by
    1,
    2

Answer 1

如果使用的是Build 125，则可以通过workbench.settings配置它，方法是使用与Postgres相同的设置来标识错误位置。

使用常规文本编辑器编辑文件，并添加以下两行：

workbench.db.redshift.errorinfo.regex.position=(?i)position:\\s+[0-9]+
workbench.db.redshift.errorinfo.leading.comment.included=true

然后光标应自动跳转到由错误消息标识的编辑器中的位置。

设置文件位于配置目录中。确切的位置显示在“关于”对话框和“选项”对话框中。

在编辑文件之前，请确保关闭/J。