You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/10/08 07:17:26 UTC
[jira] [Assigned] (TRAFODION-1250) LP Bug: 1459763 - mtserver -
explain plan fails with 'provided input stmt does not exist', works from
sqlci
[ https://issues.apache.org/jira/browse/TRAFODION-1250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah reassigned TRAFODION-1250:
-----------------------------------------
Assignee: Rao Kakarlamudi (was: Zbigniew Omanski)
> LP Bug: 1459763 - mtserver - explain plan fails with 'provided input stmt does not exist', works from sqlci
> -----------------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-1250
> URL: https://issues.apache.org/jira/browse/TRAFODION-1250
> Project: Apache Trafodion
> Issue Type: Bug
> Components: connectivity-dcs
> Reporter: Aruna Sadashiva
> Assignee: Rao Kakarlamudi
> Priority: Critical
> Fix For: 2.0-incubating
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)