Thanks Anoop, you are right, it works for me after I changed ' to '\''. Best regards, Yuan Email: yuan....@esgyn.cn<mailto:yuan....@esgyn.cn> Cellphone: (+86) 13671935540
From: Anoop Sharma [mailto:anoop.sha...@esgyn.com] Sent: Monday, June 26, 2017 12:33 PM To: user@trafodion.incubator.apache.org Subject: RE: traci.sh error the single quotes around 'bbb' are getting removed by shell when that query is sent. That will cause sql to treat bbb as a column name. To correctly use single quotes, do: ./trafci.sh -h openstack-1:23400 -u zz -p zz -q "delete from test_trafci where aaa = '\''bbb'\'' " that is '\'' for each ' (single quote, backslash, 2 single quotes). anoop From: Liu, Yuan (Yuan) [mailto:yuan....@esgyn.cn] Sent: Sunday, June 25, 2017 8:12 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: traci.sh error Hi Trafodioneers, I encountered below error when I tried to use traci.sh to execute a sql query. It seemed there trafci.sh had something wrong when parsing the sql syntax, Can anyone help to confirm if it is a bug? If yes, I can file a JIRA, and for now, is there some work around for this? [trafodion@openstack-1 bin]$ ./trafci.sh -h openstack-1:23400 -u zz -p zz -q "delete from test_trafci where aaa = 'bbb'" Welcome to EsgynDB Advanced Command Interface Copyright (c) 2015-2017 Esgyn Corporation Host Name/IP Address: openstack-1:23400 User Name: zz Tenant Name : SQL> *** ERROR[4001] Column BBB is not found. Tables in scope: TRAFODION.SEABASE.TEST_TRAFCI. Default schema: TRAFODION.SEABASE. [2017-06-26 10:44:53] Best regards, Yuan Email: yuan....@esgyn.cn<mailto:yuan....@esgyn.cn> Cellphone: (+86) 13671935540