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

2018-03-06 Thread Suresh Subbiah (JIRA)

 [ 
https://issues.apache.org/jira/browse/TRAFODION-1250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Suresh Subbiah updated TRAFODION-1250:
--
Fix Version/s: (was: 2.2.0)

> 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
>
> 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.2root  1.00E+004
> ..1trafodion_scan  TABALL1.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
(v7.6.3#76005)


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

2018-03-04 Thread Pierre Smits (JIRA)

 [ 
https://issues.apache.org/jira/browse/TRAFODION-1250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pierre Smits updated TRAFODION-1250:

Fix Version/s: (was: 2.1-incubating)
   2.2.0

> 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.2.0
>
>
> 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.2root  1.00E+004
> ..1trafodion_scan  TABALL1.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
(v7.6.3#76005)