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
Dmitry Yemanov made changes - 13/Apr/10 06:55 AM
Field Original Value New Value
Assignee Dmitry Yemanov [ dimitr ]
Repository Revision Date User Message
Firebird #49516 Tue Apr 13 06:55:46 GMT+00:00 2010 dimitr Fixed CORE-2966: Wrong results or unexpected errors while sorting a large data set.
Files Changed
MODIFY /firebird/branches/B2_5_Release/src/common/classes/TempFile.cpp

Repository Revision Date User Message
Firebird #49518 Tue Apr 13 07:01:02 GMT+00:00 2010 dimitr Fixed CORE-2966: Wrong results or unexpected errors while sorting a large data set.
Files Changed
MODIFY /firebird/trunk/src/common/classes/TempFile.cpp

Dmitry Yemanov made changes - 13/Apr/10 07:01 AM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s  2.5 RC3 [ 10381 ]
Fix Version/s 3.0 Alpha 1 [ 10331 ]
Resolution Fixed [ 1 ]
Dmitry Yemanov made changes - 13/Apr/10 07:05 AM
Reporter Dmitry Yemanov [ dimitr ] John Kilin [ johnkilin ]
Pavel Cisar made changes - 24/Feb/11 10:55 AM
Link This issue is related to QA-438 [ QA-438 ]
Philippe Makowski made changes - 17/Jun/11 02:00 PM
Status Resolved [ 5 ] Closed [ 6 ]
Repository Revision Date User Message
Firebird #53189 Fri Jun 17 14:21:34 GMT+00:00 2011 makowski QA-438 for CORE-2966
Files Changed
ADD /qa/trunk/fbtest/tests/bugs/core_2966.fbt

Vlad Khorsun added a comment - 24/Sep/12 01:25 PM
Re-opened to be backported into v 2.1.6

Vlad Khorsun made changes - 24/Sep/12 01:25 PM
Resolution Fixed [ 1 ]
Status Closed [ 6 ] Reopened [ 4 ]
Fix Version/s 2.1.6 [ 10460 ]
Repository Revision Date User Message
Firebird #57158 Mon Sep 24 13:55:30 GMT+00:00 2012 hvlad Backport fix for bug CORE-2966 : Wrong results or unexpected errors while sorting a large data set
Files Changed
MODIFY /firebird/branches/B2_1_Release/src/common/classes/TempFile.cpp

Vlad Khorsun made changes - 24/Sep/12 01:56 PM
Status Reopened [ 4 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Vlad Khorsun made changes - 24/Sep/12 01:57 PM
Link This issue is duplicated by CORE-3918 [ CORE-3918 ]
Pavel Cisar made changes - 26/Apr/13 01:39 PM
Status Resolved [ 5 ] Closed [ 6 ]