MXOSRVR connections gets rejected due to compiler internal error

[Tharak Capirala]

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.

[Anoop Sharma (anoop-sharma)]

code has been updated to return an error if a seaquest catalog is used in a query in Open Source mode.

[Anoop Sharma (anoop-sharma)]

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.
>>