[
http://tracker.firebirdsql.org/browse/CORE-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vlad Khorsun reopened CORE-2966:
--------------------------------
Fix Version/s: 2.1.6
Re-opened to be backported into v 2.1.6
> 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: 3.0 Initial, 2.5 RC1, 2.5 RC2
> Environment: 32-bit builds only
> Reporter: John Kilin
> Assignee: Dmitry Yemanov
> Fix For: 3.0 Alpha 1, 2.1.6, 2.5 RC3
>
>
> 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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
