Issue Details (XML | Word | Printable)

Key: CORE-1777
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Claudio Valderrama C.
Reporter: Claudio Valderrama C.
Votes: 0
Watchers: 0

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

Engine allows conflicting table reservation specifications in TPB

Created: 07/Mar/08 04:53 AM   Updated: 19/Jan/16 05:02 AM
Component/s: Engine
Affects Version/s: 1.0.3, 2.0.0, 1.5.4, 2.0.1, 2.1 Alpha 1, 2.1 Beta 1, 2.0.2, 2.0.3, 1.5.5, 2.1 RC1, 2.5 Initial, 2.1.0, 2.0.4
Fix Version/s: 2.5 Alpha 1

Environment: Platform independent.

QA Status: No test

 Description  « Hide
As part of TPB accepted operations, it's possible to reserve tables for reading or writing, shared or protected. While it's possible that a user reading a TPB discovers that the same table was used twice with incompatible modes, when views are used, it's unrealistic to expect the user will discover the problem, since a view propagates it's locking types to the base tables and these tables in turn may be views, until the real, base tables have been hit. Since views can share tables or other views and different views in the same query can have different table reservation options, the engine doesn't complain: it simply assigns the latest table reservation it process to a table and overwrites any previous setting for the same table, silently.
This is related to CORE-1600.

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