[jira] [Commented] (TRAFODION-144) LP Bug: 1246923 - MXOSRVR connections gets rejected due to compiler internal error

["Atanu Mishra (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14696107#comment-14696107 ] 

Atanu Mishra commented on TRAFODION-144:
----------------------------------------

Anoop Sharma (anoop-sharma) wrote on 2013-11-05:	#1
code has been updated to return an error if a seaquest catalog is used in a query in Open Source mode.

Changed in trafodion:
assignee:	Suresh Subbiah (suresh-subbiah) → Anoop Sharma (anoop-sharma)
Anoop Sharma (anoop-sharma) wrote on 2013-11-24:	#2
Error will be returned if Seaquest catalog is used in any stmt (DDL, DML, INVOKE).

>>prepare s from select * from neo.usr.t;

*** ERROR[1002] Catalog NEO does not exist or has not been registered on node .

*** ERROR[8822] The statement was not prepared.

>>create table neo.usr.tt (a int);

*** ERROR[4222] The DDL feature is not supported in this software version.

*** ERROR[8822] The statement was not prepared.

>>set schema neo.usr;

--- SQL operation complete.
>>invoke t;

*** ERROR[4222] The DESCRIBE feature is not supported in this software version.

--- SQL operation failed with errors.
>>

Changed in trafodion:
status:	New → Fix Committed
Weishiun Tsai (wei-shiun-tsai) on 2014-03-24
Changed in trafodion:
status:	Fix Committed → Fix Released


> LP Bug: 1246923 - MXOSRVR connections gets rejected due to compiler internal error
> ----------------------------------------------------------------------------------
>
>                 Key: TRAFODION-144
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-144
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: client-jdbc-t4, connectivity-mxosrvr
>            Reporter: Tharak Capirala
>            Assignee: Anoop Sharma
>            Priority: Blocker
>              Labels: connection, reject
>             Fix For: 0.7 (pre-incubation)
>
>
> When connecting from a JDBC T4 client when MXOSRVR tries to execute certain simple SET commands during connection time it receives an internal compiler error and as a result rejects the client connection.
> For e.g.
> SET_ODBC_PROCESS
> ODBC/MX Server4294965290*** ERROR[2006] Internal error: assertion failure (inTableDesc) in file ../optimizer/NATable.cpp at line 4203. [2013-10-31 17:36:45
> ODBC/MX Server4294958474*** ERROR[8822] The statement was not prepared. [2013-10-31 17:36:45
> This issue is currently impacting QA testing.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)