[Firebird-devel] [FB-Tracker] Created: (CORE-2966) Wrong results or unexpected errors while sorting a large data set

[Dmitry Y. (JIRA) <tr...@fi...>]

Wrong results or unexpected errors while sorting a large data set
-----------------------------------------------------------------

                 Key: CORE-2966
                 URL: http://tracker.firebirdsql.org/browse/CORE-2966
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine
    Affects Versions: 2.5 RC2, 2.5 RC1, 3.0 Initial
         Environment: 32-bit builds only
            Reporter: Dmitry Yemanov


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 "".


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira