Steven Hawkins created TEIID-4482: ------------------------------------- Summary: Not null not enforced with temp table expression Key: TEIID-4482 URL: https://issues.jboss.org/browse/TEIID-4482 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1, 9.0.5 A table defined as: create local temporary table x (e1 string not null, e2 integer, primary key (e2)) such that the pk is not in the first position, will allow an insert such as: insert into x (e1, e2) values ((select null), 1) to succeed because the nullability will be checked against the declared positioning, and not the temptable positioning (in which the pk is first). -- This message was sent by Atlassian JIRA (v6.4.11#64026)