Issue Details (XML | Word | Printable)

Key: CORE-4214
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 0

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

GTT should not reference permanent relation

Created: 10/Sep/13 02:32 PM   Updated: 25/Sep/15 12:22 PM
Component/s: Engine
Affects Version/s: 2.1.0, 2.1.1, 2.1.2, 2.1.3, 3.0 Initial, 2.5.0, 2.1.4, 2.5.1, 2.1.5, 2.5.2, 2.1.5 Update 1, 2.5.2 Update 1, 3.0 Alpha 1
Fix Version/s: 3.0 Alpha 2, 2.1.6, 2.5.3

Issue Links:

QA Status: Done successfully

 Description  « Hide
Test case is at CORE-4212

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 10/Sep/13 02:34 PM
v2.1 also affected

Vlad Khorsun added a comment - 10/Sep/13 02:39 PM
The bug could happen when CREATE TABLE contains more than one FOREIGN KEY constraints

Sean Leyne added a comment - 10/Sep/13 09:43 PM
Clarification on SQL Standard:

The spec only allows permanent tables to reference permanent tables, and GTTs to reference GTTs.

So, GTT can only have dependencies/references to another GTT.

Pavel Cisar added a comment - 25/Sep/15 12:22 PM
Test created.