|
From: Dmitry Y. (JIRA) <tr...@fi...> - 2010-04-13 06:54:02
|
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
|