[TRAFODION-2075] [3rd party tool] Squirrel doesn't support prepare/explain/excute, will return syntax error

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.1-incubating
• Component/s: client-jdbc-t4
• Environment: squirrel 3.7 ; server with adv R2.1, centos 6.7, hbase1.0 cdh 5.4.8
• Assignee: mashengchen
• Reporter: Gao, Rui-Xian
• Created: 20/Jun/16 09:08
• Updated: 26/Jan/18 08:28

Description

Prepare/explain/execute statement is not supported –

prepare xx from select * from btsel02;

Error: *** ERROR[15001] A syntax error occurred at or before:
prepare xx from select * from btsel02;
^ (22 characters from start of SQL statement) [2016-06-20 17:07:00]
SQLState: 42000
ErrorCode: -15001
Error: *** ERROR[8822] The statement was not prepared. [2016-06-20 17:07:00]
SQLState: X08MU
ErrorCode: -8822