search

pdet / SQLTest

5 stars 0 forks source link

Syntax highlighting gets confused when query result contains an apostrophe `'` #10

Open findepi opened 3 days ago

findepi commented 3 days ago

for file with

hash-threshold 20

# Query which returns single apostrophe
query ? nosort
SELECT 'a single apostrophe: '', right?'
----
a single apostrophe: ', right?                         <!--- a very long varchar literal starting here

# Next query does not get syntax highlighting
query ? nosort
SELECT 'next query'

The SQL syntax highlighter gets enabled when processing first query results, so it scans the second test query treating it as part of a varchar literal:

image