SIMILAR TO produces random results with [x-y] expressions [CORE2308] #2732
Assignees
Comments
Modified by: @dyemanovassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandessummary: SIMILAR TO produced random results => SIMILAR TO produces random results with [x-y] expressions environment: Reproduced in Windows only, but depends on how compiler optimizes expressions |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 Beta 1 [ 10251 ] |
|
Commented by: @pcisar QA test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: @hvlad
Is related to QA386
CREATE OR ALTER PROCEDURE PROC
RETURNS ( V INTEGER)
AS
BEGIN
IF ('b' SIMILAR TO ('[a-z]'))
THEN v = 1;
ELSE v = 2;
SUSPEND;
END
Run SELECT * FROM PROC few times - it will return 1 or 2 randomly
Or run following block :
EXECUTE BLOCK AS
DECLARE I INT = 1000;
DECLARE V INT;
BEGIN
WHILE (I > 0) DO
BEGIN
I = I - 1;
SELECT V FROM PROC INTO :V;
END
END
it may throw "integer divide by zero" exception
Not reproducible on DEBUG build !
Commits: 372fe94
The text was updated successfully, but these errors were encountered: