Issue Details (XML | Word | Printable)

Key: CORE-2893
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 0
Watchers: 0
Operations

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

Expression in a subquery may be treated as invariant and produce incorrect results

Created: 27/Feb/10 08:41 PM   Updated: 15/Jun/11 12:41 PM
Component/s: Engine
Affects Version/s: 2.0.0, 2.0.1, 2.0.2, 2.0.3, 2.1.0, 2.0.4, 2.5 Alpha 1, 2.1.1, 2.0.5, 2.1.2, 2.5 Beta 1, 2.5 Beta 2, 2.1.3, 3.0 Initial, 2.5 RC1, 2.5 RC2
Fix Version/s: 2.5 RC3, 3.0 Alpha 1

Time Tracking:
Not Specified

Issue Links:
Duplicate
 
Relate

Planning Status: Unspecified


 Description  « Hide
create table z (c varchar(10));

insert into z values (1);
insert into z values (1);
insert into z values (2);
insert into z values (3);

commit;

select c from z where (select z.c || '' from rdb$database) = '1';

C
==========
1
1
2
3


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.