Fail to execute a fully parsed multile lines SQL request

[eraso]

Hello,

With Tora 3.2.186/windows/x64, while executing a multiple lines SQL request, sometimes (often the first run), it fails to execute the full SQL request.

Even if the multiple lines SQL request is fully parsed, and so, all the request is recognized, the execution of the request takes only a part of it.

For instance : 1/ for the following request : select "Price", "Quantity" from "Fee" where "Price" =0 ;

If the cursor is on the first line, (often on the first run), the error "From clause is missing" is raised if the cursor is on the second line, the error "from without select" is raised.

2/ for the following request : select "Price","Quantity" from "Fee" where "Price"=0 ; If the cursor is on the first line, (often on the first run), the request is executed without the where part.

This can be annoying if you're executing an update request in autocommit mode.

KR,

eraso

[ibre5041]

I can not reproduce it in source trunk. Can you pls try to reproduce it on: Tora.3.2.283.Release.64bit ?

[Sergiomdf]

I can reproduce it on v3.2.283-ge01a9d15 (donwloaded from SourceForge):

1. Open a saved query.
2. Ctrl + Enter -> Error
3. Ctrl + Enter -> Query result is displayed.

May it be related to the QsciSql parser or to interaction with elements of the GUI?

1. Open a saved query.
2. Change to Oracle parser.
3. Ctrl + Enter -> Query result is displayed.