[TRAFODION-2078] [3rd party tool-Squirrel] query cancel is not supported

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.1-incubating
• Component/s: client-jdbc-t4
• Environment: Squirrel 3.7 ; server info -- adv R2.1, centos6.7, hbase1.0, cdh5.4.8
• Assignee: mashengchen
• Reporter: Gao, Rui-Xian
• Created: 20/Jun/16 09:23
• Updated: 26/Jan/18 08:29

Description

can't cancel query from squirrel, syntax error returned –

control query cancel qid 'MXID11000007328212333173215368200000000000206U3333300_483_XX';

Error: *** ERROR[15001] A syntax error occurred at or before:
control query cancel qid 'MXID11000007328212333173215368200000000000206U3333300
_483_XX';
^ (87 characters from start of SQL statement) [2016-06-20 17:21:38]
SQLState: 42000
ErrorCode: -15001
Error: *** ERROR[8822] The statement was not prepared. [2016-06-20 17:21:38]
SQLState: X08MU
ErrorCode: -8822