Issue Details (XML | Word | Printable)

Key: CORE-2966
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: John Kilin
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
Firebird Core

Wrong results or unexpected errors while sorting a large data set

Created: 13/Apr/10 06:51 AM   Updated: 20/Jul/15 06:20 AM
Component/s: Engine
Affects Version/s: 3.0 Initial, 2.5 RC1, 2.5 RC2
Fix Version/s: 2.5 RC3, 3.0 Alpha 1, 2.1.6

Environment: 32-bit builds only
Issue Links:

QA Status: Done successfully

 Description  « Hide
Test case:

-- create the table
create table t ( col varchar(32000) );
-- populate it with data
execute block
  declare variable i integer;
  i= 0;
  while (i < 200000) do begin
    insert into t (col) values(mod(:i, 10));
    i= i+1;

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

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 24/Sep/12 01:25 PM
Re-opened to be backported into v 2.1.6