RE: issue with a request

@trafodion.incubator.apache.org Objet : 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

RE: issue with a request

: RE: issue with a request Thanks Benny. Best regard FERLAY Mathieu De : Wang, Ai-Min (Benny) [mailto:aimin.w...@esgyn.cn] Envoyé : jeudi 16 mars 2017 08:42 À : user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Objet : RE: issue with a request Hi: Plea

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,