[JBoss JIRA] (TEIID-5799) GENERATED_KEY cannot resolve primary key, if created via insert trigger on view
11:24 a.m.
[
https://issues.jboss.org/browse/TEIID-5799?page=com.atlassian.jira.plugin...
]
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)
2439
days inactive
2439
days old
0 comments
1 participants
participants (1)
-
Christoph John (Jira)