[teiid-issues] [JBoss JIRA] (TEIID-4482) Not null not enforced with temp table expression

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-4482.
---------------------------------


> 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
(v7.2.3#72005)