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
Operations

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: 26/Apr/13 01:39 PM
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

Time Tracking:
Not Specified

Environment: 32-bit builds only
Issue Links:
Duplicate
 
Relate
 

Planning Status: Unspecified


 Description  « Hide
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 "".


 All   Comments   Work Log   Change History   Version Control   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