Issue Details (XML | Word | Printable)

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

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

Fields present only in WHERE clause of views WITH CHECK OPTION causes invalid CHECK CONSTRAINT violation

Created: 30/Dec/13 01:18 AM   Updated: 23/Sep/15 12:44 PM
Component/s: Engine
Affects Version/s: 3.0 Alpha 1, 3.0 Alpha 2
Fix Version/s: 3.0 Beta 1

Issue Links:
Relate
 

QA Status: Done successfully


 Description  « Hide
Test case:

recreate table t1 (n1 integer, n2 integer);
insert into t1 values (1, 2);
insert into t1 values (1, 3);
insert into t1 values (1, 4);
insert into t1 values (2, 2);
insert into t1 values (2, 3);
insert into t1 values (2, 4);
insert into t1 values (3, 2);
insert into t1 values (3, 3);
insert into t1 values (3, 4);

--With this one works correctly: recreate view v1 as select n1, n2 from t1 where n1 < n2 with check option;
recreate view v1 as select n1 from t1 where n1 < n2 with check option;

update v1 set n1 = n1 - 1;

Statement failed, SQLSTATE = 23000
Operation violates CHECK constraint on view or table V1
-At trigger 'CHECK_5'


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes made changes - 30/Dec/13 01:18 AM
Field Original Value New Value
Assignee Adriano dos Santos Fernandes [ asfernandes ]
Component/s Engine [ 10000 ]
Adriano dos Santos Fernandes made changes - 09/Jan/14 03:43 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Resolution Fixed [ 1 ]
Pavel Cisar made changes - 29/Mar/14 05:49 PM
Link This issue is related to QA-586 [ QA-586 ]
Adriano dos Santos Fernandes made changes - 26/Mar/15 08:03 PM
Link This issue is related to CORE-4724 [ CORE-4724 ]
Pavel Zotov made changes - 29/May/15 04:05 PM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status Done successfully
Pavel Cisar made changes - 23/Sep/15 12:44 PM
Status Resolved [ 5 ] Closed [ 6 ]