Details
Description
Query editor does not take comments into account while splitting statements at semicolons. Also orphaned semicolons produce empty queries rather than being ignored completely. Following query will fail:
– This is a comment;
select * from <table_name> limit 100
Also the following query executes without the limit operator:
select * from <table_name> – This is a comment;
limit 100
The following query causes a parse exception because of an empty query in the beginning:
;
select * from <table_name> limit 100