Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Description

For example, the query below will simply cause the error in title:

Example:

Code Block
languagesql
linenumberstrue
SELECT * from tbl SELECT;

...

Error Message:

Code Block
languageruby
linenumberstrue
line 1:15: mismatched input 'SELECT'. Expecting: '(', 'LATERAL', 'UNNEST', <identifier>

...

Cause

A keyword is detected in SQL, while it should not be there as per SQL grammar. As result a compile error as titled, will be output.

...

Resolution

Locate the keyword by information in error message (in this case 'line 1:15'), then check and fix it.

Code Block
languagesql
linenumberstrue
SELECT * from tbl;

...

Note / Related Information

N/A