inline_sql_syntax icon indicating copy to clipboard operation
inline_sql_syntax copied to clipboard

Semicolumn in string in SQL can end the query and raise "Unmatched parentheses" error

Open Leroymilo opened this issue 3 years ago • 0 comments

Something like :

SELECT series_id, GROUP_CONCAT(auth_name SEPARATOR '; ') AS auths
FROM Authors
NATURAL JOIN `Series-Authors`
GROUP BY series_id

will be considered an "Unmatched parentheses" error with red squiggles everywhere because the semicolumn ; used as a separator here is considered the end of the query, which causes the closing parenthesis to be in 'another' query.

I'm working in python 3.10, inline sql syntax 2.16.0.

Leroymilo avatar Feb 27 '23 12:02 Leroymilo