Issue Details (XML | Word | Printable)

Key: CORE-1361
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Dmitry Yemanov
Votes: 0
Watchers: 0

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

Index operations for global temporary tables are not visible for the active connection

Created: 16/Jul/07 10:35 AM   Updated: 18/Nov/08 01:59 PM
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

 Description  « Hide
Neither CREATE INDEX nor SET STATISTICS statements affect the current connection. While it's logical for DELETE ROWS temporary tables, I'd expect the PRESERVE ROWS tables to take the changes into account, i.e. to use the index and to update the statistics.

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 28/Aug/07 04:21 PM
Create index will create index instance in current connection.
Alter index and set statistics will work with index instance in current connection.
Drop index will delete index instance in current connection but will fail if there are instances of this index in another connections.