Wrong results or unexpected errors while sorting a large data set [CORE2966] #3348
Assignees
Comments
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 RC3 [ 10381 ] Fix Version: 3.0 Alpha 1 [ 10331 ] |
Modified by: @dyemanovreporter: Dmitry Yemanov [ dimitr ] => John Kilin [ johnkilin ] |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
|
Commented by: @hvlad Re-opened to be backported into v 2.1.6 |
Modified by: @hvladstatus: Closed [ 6 ] => Reopened [ 4 ] Fix Version: 2.1.6 [ 10460 ] resolution: Fixed [ 1 ] => |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: John Kilin (johnkilin)
Is related to QA438
Is duplicated by CORE3918
Test case:
-- create the table
create table t ( col varchar(32000) );
-- populate it with data
execute block
as
declare variable i integer;
begin
i= 0;
while (i < 200000) do begin
insert into t (col) values(mod(:i, 10));
i= i+1;
end
end;
select col from t group by 1;
-- unexpected NULLs and empty strings
select cast(col as integer) from t group by 1;
-- Overflow occurred during data type conversion.
-- conversion error from string "".
Commits: 6a8393b 8c00b7c ef49a50
The text was updated successfully, but these errors were encountered: