"enclosed by" is not recognized by the SQL parser

[svaningelgem]

Describe the bug

"enclosed by" is not recognized by the SQL parser

To Reproduce

Steps to reproduce the behavior:

1. Go to SQL window
2. Type for example:

SELECT a
into outfile '/tmp/temp.data' 
fields terminated by ',' enclosed by '"'
FROM sometable

3. no need to run it (but when you run it against an actual table, it works just fine on the MySQL server)
4. See error

Expected behavior

No error (no red cross at the left side)

Observed behaviour

Red cross at the left + these messages:

• Unrecognised keyword. (near enclosed by)
• Unexpected token. (near '"')

[apoorvkhare07]

@williamdes @svaningelgem I think this issue should be added in sql-parser repository as this issue is with the parser. The solution is adding parsing for these unimplemented options. Should I work on this one?

[williamdes]

cc @devenbansod ?

[ibennetch]

I agree, moving to sql-parser repository.

You may work on it if you'd like.

@svaningelgem thank you for the report.

[williamdes]

echo "SELECT a into outfile '/tmp/temp.data'  fields terminated by ',' enclosed by '\"' FROM sometable" | ./bin/lint-query 
#1: Unrecognized keyword. (near "enclosed by" at position 65)
#2: Unexpected token. (near "'"'" at position 77)

[williamdes]

Okay, the bug in the code is about the casing of fields, use uppercase and it will be happy