[TRAFODION-1250] LP Bug: 1459763 - mtserver - explain plan fails with 'provided input stmt does not exist', works from sqlci

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Component/s: connectivity-dcs
• External issue URL: https://bugs.launchpad.net/bugs/1459763
• Assignee: Rao Kakarlamudi
• Reporter: Aruna Sadashiva
• Created: 22/Jul/15 18:20
• Updated: 06/Mar/18 16:17

Description

Explain is not working with mtserver thru jdbc. It works ok from sqlci.

SQL>explain options 'f' select * from t4qa.taball;

LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------

1 . 2 root 1.00E+004
. . 1 trafodion_scan TABALL 1.00E+004

— SQL operation complete.

SQL>prepare s02 from select * from t4qa.taball;

— SQL command prepared.

SQL>explain s02;

• • • ERROR[8804] The provided input statement does not exist in the current context.