Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
eraso opened this issue Nov 29, 2020 · 2 comments
Open

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

eraso opened this issue Nov 29, 2020 · 2 comments

Comments

@eraso
Copy link

eraso commented Nov 29, 2020

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
Copy link
Member

ibre5041 commented Dec 2, 2020

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

@Sergiomdf
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants