[
https://issues.jboss.org/browse/TEIID-5790?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-5790:
----------------------------------
Description:
The logic to calculate when to return the generated key was not generally correct. If
there were other columns beside the key left out of the explicit insert variable list,
then the generated key would not be returned.
For example:
{code}
create temporary table t (x serial, y string, primary key (x));
{code}
would not return the generated key on:
{code}
insert into t (y) values ('a');
{code}
was:
The logic to calculate when to return the generated key was not generally correct. If
there were other columns beside the key left out of the explicit insert variable list,
then the generated key would not be returned.
For example:
create temporary table t (x serial, y string, primary key (x));
would not return the generated key on:
insert into t (y) values ('a');
Generated key is not made available depending upon the number of
column values on the insert
--------------------------------------------------------------------------------------------
Key: TEIID-5790
URL:
https://issues.jboss.org/browse/TEIID-5790
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Major
Fix For: 12.3, 12.2.2
The logic to calculate when to return the generated key was not generally correct. If
there were other columns beside the key left out of the explicit insert variable list,
then the generated key would not be returned.
For example:
{code}
create temporary table t (x serial, y string, primary key (x));
{code}
would not return the generated key on:
{code}
insert into t (y) values ('a');
{code}
--
This message was sent by Atlassian Jira
(v7.12.1#712002)