Possible NULL in NOT NULL-Field
-------------------------------
Key: CORE-6416
URL: http://tracker.firebirdsql.org/browse/CORE-6416
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0.6
Reporter: Maxim Kuzmin
Steps for reproduce:
1. Create tables.
CREATE TABLE TEST_TABLE (
ID INTEGER NOT NULL,
NEW_FIELD INTEGER
);
CREATE TABLE TEST_TABLE_2 (
ID INTEGER NOT NULL
);
SET TERM ^ ;
CREATE OR ALTER TRIGGER TEST_TABLE_2_AI0 FOR TEST_TABLE_2
ACTIVE AFTER INSERT POSITION 0
AS
BEGIN
INSERT INTO TEST_TABLE(id) values(new.id);
END
^
SET TERM ; ^
2. Execute insert record, but rollback the transaction.
INSERT INTO TEST_TABLE_2(ID) VALUES (1)
3. Set NEW_FIELD as NOT NULL:
ALTER TABLE TEST_TABLE ALTER NEW_FIELD SET NOT NULL
4. Execute insert record and commit the transaction.
INSERT INTO TEST_TABLE_2(ID) VALUES (1)
5. Check values:
SELECT * FROM TEST_TABLE:
ID NEW_FIELD
1 <NULL>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
