[teiid-issues] [JBoss JIRA] (TEIID-5799) GENERATED_KEY cannot resolve primary key, if created via insert trigger on view

[Christoph John (Jira)]

    [ https://issues.jboss.org/browse/TEIID-5799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13766589#comment-13766589 ] 

Christoph John edited comment on TEIID-5799 at 8/2/19 12:23 PM:
----------------------------------------------------------------

Hello Steven,
only the third script should produce the error. 

I am not sure what you mean with run against master. Last Teiid Master sources? So you did not use the docker-compose file to run the Teiid server and the mysql db in the containers?

I have now rebuild with the most recent Teiid sources. I am still getting the same error. Do you see an obvious error in my build environment?

Mac OSX 10.14.5
FROM jboss/wildfly:17.0.0.Final
TEIID_CONSOLE_VERSION 3.1.0
JAVA:

java version "1.8.0_181"
Java(TM) SE Runtime Environment (build 1.8.0_181-b13)
Java HotSpot(TM) 64-Bit Server VM (build 25.181-b13, mixed mode)

git clone https://github.com/teiid/teiid.git
cd teiid
mvn clean install -P dev -s settings.xml

Apache Maven 3.5.4 (1edded0938998edf8bf061f1ceb3cfdeccf443fe; 2018-06-17T20:33:14+02:00)
Maven home: /usr/local/apache-maven-3.5.4
Java version: 1.8.0_181, vendor: Oracle Corporation, runtime: /Library/Java/JavaVirtualMachines/jdk1.8.0_181.jdk/Contents/Home/jre
Default locale: de_DE, platform encoding: UTF-8
OS name: "mac os x", version: "10.14.5", arch: "x86_64", family: "mac"



was (Author: cjohn001):
Hello Steven,
only the third script should produce the error. 

I am not sure what you mean with run against master. Last Teiid Master sources? So you did not use the docker-compose file to run the Teiid server and the mysql db in the containers?

I have now rebuild with the most recent Teiid sources. I am still getting the same error. Do you see an obvious error in my build environment?

Mac OSX 10.14.5
FROM jboss/wildfly:17.0.0.Final
TEIID_CONSOLE_VERSION 3.1.0
JAVA:

java version "1.8.0_181"
Java(TM) SE Runtime Environment (build 1.8.0_181-b13)
Java HotSpot(TM) 64-Bit Server VM (build 25.181-b13, mixed mode)

git clone https://github.com/teiid/teiid.git
cd teiid
mvn clean install -P dev -s settings.xml


> GENERATED_KEY cannot resolve primary key, if created via insert trigger on view
> -------------------------------------------------------------------------------
>
>                 Key: TEIID-5799
>                 URL: https://issues.jboss.org/browse/TEIID-5799
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 13.0
>            Reporter: Christoph John
>            Assignee: Steven Hawkins
>            Priority: Blocker
>         Attachments: svc-vdb-example.ddl
>
>
> Hello Steven,
> I just ran into the next issue with the generated key functionality. Attached you find an example. The relevant section is  given in
> CREATE TRIGGER ON Diary INSTEAD OF INSERT AS
> with the block following:
> ELSE IF (new.fkDatabaseKey = 3)
> In the insert trigger I am trying to duplicate a record from table "UserDefinedProducts" and reference it in the row to be created from the trigger.
> I again the the error message:
> POST on 'Diary' failed; will be repeated automatically - Error: TEIID16016 Insert into Diary success, but failed to retrieve auto generated keys from source, thus failed to show result entity; Supply the key values.
> I am using the most recent sources checked out about an hour ago.
> Do you see a bug in my code, or is it again an issue I have hit? Thanks for your help!
> Let me know if I shall assemble a docker-compose file for you to debug the issue.
> Update: As I seem to be not able to delete attachments here. One further note. My example hat a permission error in one line where I have red from the wrong table. It should instead be:
> SELECT * INTO #tmpItem FROM UserDefinedProductsOfAllUsers WHERE fkProduct = new.fkProduct LIMIT 1;
> However, the previously described error stays the same.
> Best regards,
>  Christoph



--
This message was sent by Atlassian Jira
(v7.12.1#712002)