RE: issue wtih foreign keys

Hi, FYI - I will be staging a 2.1 version of Trafodion in a couple of days to the dev staging site. Not quite ready for today - most likely Monday. 2.1 version has 300+ fixes. Sandhya From: Qifan Chen [mailto:qifan.c...@esgyn.com] Sent: Thursday, March 16, 2017 9:50 AM To:

RE: issue wtih foreign keys

So, evidently this is a bug that has been fixed? I wonder if we can find a JIRA reference. From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Thursday, March 16, 2017 8:55 AM To: user@trafodion.incubator.apache.org Subject: RE: issue wtih foreign keys With trafci on latest of esgynDB

RE: issue wtih foreign keys

With trafci on latest of esgynDB (derivative of trafodion), both with autocommit on or off, this set of create table work fine. Eric From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Thursday, March 16, 2017 10:33 AM To: user@trafodion.incubator.apache.org Subject: RE: issue wtih

RE: issue wtih foreign keys

Hi Dave, I’m using the version of the docker image trafodion\incubator and I believe it’s the 2.0.0 . Regards, Mathieu De : Dave Birdsall [mailto:dave.birds...@esgyn.com] Envoyé : jeudi 16 mars 2017 16:26 À : user@trafodion.incubator.apache.org Objet : RE: issue wtih foreign keys Hi

RE: issue wtih foreign keys

Hi Eric, I have put this command SET TRANSACTION AUTOCOMMIT ON; at the entry of my script but I’m not fully sure that it have no commit in the java part. I’m currently checking on that. With sqlci, I have not already did it yet, but I have no issue by passing each request one by one.

RE: issue wtih foreign keys

Hi Mathieu, Error 8838 usually indicates a core in the tdm_arkcmp process. So you're likely running into a bug. What version of Trafodion are you using? (What banner comes up when you enter, sqlci?) I tried your CREATE statements in the latest version of Trafodion and they worked for me.

RE: issue wtih foreign keys

Are you saying that autocommit is off, and you are executing the 3 ddl statement then manual commit? Then you see the issue? Or autocommit is on, and you see the issue? When you perform the same ddl operation using command line with sqlci, you see no problem right? Eric From: mathieu ferlay

RE: issue with a request

Thanks Eric, For the moment i’ll just try to migrate our script from sql to trafodion but I notice it for our second phase corresponding to the optimization. Regards, Mathieu De : Eric Owhadi [mailto:eric.owh...@esgyn.com] Envoyé : jeudi 16 mars 2017 14:36 À :

RE: issue with a request

Hi Mathieu, Just a small comment: you are using UTF8 for storing UUID, on a VARCHAR. If this is just for testing functionality that’s OK. But for real production and high volume, if you want to optimize, please consider: CHAR(36) CHARACTER SET ISO88591 Trafodion would reserve 4 times more space

RE: issue wtih foreign keys

Hi, I have change my request by using alter table do it but I still have some “lost” of process. It’s look like an infinite loop inside the execute statement. I don’t know what it could causes that. Regards, Mathieu De : mathieu ferlay [mailto:mfer...@gnubila.fr] Envoyé : jeudi 16

issue wtih foreign keys

Hi, i'll try to create the following table C. I assume that tables A & B are executed before C. But when I try to execute the statement for the table C, the process nerver back from the statement.execute(request). Furthermore, I obtain also the following trace when I force the commit with

RE: issue with a request

Hi: Pleaes use following sql， UUID is reserved word and please use “” to enclose it： CREATE TABLE IF NOT EXISTS Token ( "UUID" VARCHAR(36) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL, Expiration DATE NOT NULL, SOPInstanceUUID VARCHAR(64) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL,