#474 db statement separator not used

General
open
nobody
None
5
2013-06-17
2013-06-17
Jamie
No

In the SQL editor area, and using the MySQL plugin with the Statement Separator set to ";".

I noticed a few problems:
1. Clicking the next and previous SQL buttons in an opened sql text file (simplified example below) causes the cursor to jump between the first section of the query and the second based upon a blank line (double \n\n), not the ";" character.

Also, when attempting to run a long sql statement such as:

"SELECT
col1,col2
FROM table1
WHERE col1 > 11

-- AND not used

AND col2 < 22
LIMIT 15;"

The full statement up to the ";" is not sent, resulting in a large number of result data to be returned causing an out of memory exception as the latter clauses are not sent.

I'm not sure where the DB specific Statement Separator is used, but it seems to be just using the BaseSQLEntryPanel SQL_STMT_SEP of two line breaks..

Discussion

  • Jamie
    Jamie
    2013-06-17

    Please close this request, I incorrectly filed this as a feature request instead of a bug. I've reported it as bug #1090.