Issue Details (XML | Word | Printable)

Key: CORE-1401
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 0
Operations

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

Global temporary table instance may pick up not all indices

Created: 02/Aug/07 04:13 PM   Updated: 06/Oct/08 10:29 AM
Component/s: Engine
Affects Version/s: 2.1 Alpha 1, 2.1 Beta 1
Fix Version/s: 2.1 Beta 2

Time Tracking:
Not Specified

Issue Links:
Relate
 


 Description  « Hide
create global temporary table t (f1 int, f2 int, f3 int);
create index idx1 on t (f1);
create index idx2 on t (f2);
create index idx3 on t (f3);
drop index idx2;

set plan on;
insert into t values (1, 1, 1);
select * from t where f1 = 1;
select * from t where f2 = 1;
select * from t where f3 = 1;

Last select returns : "index unexpectedly deleted"


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Philippe Makowski added a comment - 06/Oct/08 10:29 AM
Q/A test ok