You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:
summary: Some PSQL constructions may lead to exceptions report wrong line/column => Some PSQL statements may lead to exceptions report wrong line/column
Submitted by: @asfernandes
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
Commits: c499fb5
The text was updated successfully, but these errors were encountered: