[teiid-issues] [JBoss JIRA] (TEIID-4482) Not null not enforced with temp table expression
Steven Hawkins (JIRA)
issues at jboss.org
Thu Sep 29 12:09:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-4482.
-----------------------------------
Resolution: Done
Corrected the logic by ensuring that the metadata id is always associated and using the table order.
> 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)
More information about the teiid-issues
mailing list