Issue Details (XML | Word | Printable)

Key: CORE-6403
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Some PSQL statements may lead to exceptions report wrong line/column

Created: 20/Sep/20 02:12 AM   Updated: 22/Sep/20 11:14 AM
Component/s: Engine
Affects Version/s: 4.0 Beta 2, 3.0.6
Fix Version/s: 4.0 RC 1

QA Status: Done successfully


 Description  « Hide
Example 1:

execute block
as
    declare n integer = 0;
begin
    while (1 / n > 0)
    do
    begin
        n = n - 1;
    end
end!

arithmetic exception, numeric overflow, or string truncation
-Integer divide by zero. The code attempted to divide an integer value by an integer divisor of zero.
-At block line: 5, col: 5

If initial value of N variable is changed to 1, then error is:

-At block line: 8, col: 9

-----------

Example 2:

execute block
as
    declare n integer = 0;
    declare x integer;
begin
    for select 1 / :n from rdb$database union all select 1 / :n from rdb$database into x
    do
    begin
        n = n - 1;
    end
end!

arithmetic exception, numeric overflow, or string truncation
-Integer divide by zero. The code attempted to divide an integer value by an integer divisor of zero.
-At block line: 6, col: 5

If initial value of N variable is changed to 1, then error is:

-At block line: 9, col: 9

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.