latest trafodion code that will be part of traf 2.3 will generate a 36 byte unique id in string format.
Apache Trafodion Conversational Interface 2.3.0 Copyright (c) 2015-2017 Apache Software Foundation >>select unique_id() from dual; (EXPR) ------------------------------------ b2d1426c-4459-4464-b733-8de9aa1e84ea --- 1 row(s) selected. >> Prior code was generating a binary representation which will display as unprintable characters. One can use converttohex function on top of it to convert it to hex representation. Ming may have further comments. anoop -----Original Message----- From: Liu, Yuan (Yuan) <yuan....@esgyn.cn> Sent: Friday, March 9, 2018 6:40 PM To: dev@trafodion.apache.org Subject: unique_id() not documented and get messy code Hi Trafodioneers, It seems we support unique_id() but not documented. I just tried it in trafci and get messy code. SQL>select unique_id() from dual; (EXPR) ---------------- v聦聢掳f脩T --- 1 row(s) selected. Is there something wrong? Best regards, Yuan