search

tora-tool / tora

TOra is an open source SQL IDE for Oracle, MySQL and PostgreSQL dbs
http://torasql.com/
GNU General Public License v2.0
290 stars 58 forks source link

Fail to execute a fully parsed multile lines SQL request #150

Open eraso opened 3 years ago

eraso commented 3 years ago

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 commented 3 years ago

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

Sergiomdf commented 3 years ago

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.