Menu

#907 Failure to execute a fully parsed multile lines SQL request

open
nobody
None
9
2020-11-27
2020-11-27
eraso
No

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

Discussion


Log in to post a comment.