[TRAFODION-1260] LP Bug: 1461629 - T2 driver not returning proper error msg for several unsupported catalog apis

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Component/s: client-jdbc-t2
• External issue URL: https://bugs.launchpad.net/bugs/1461629
• Assignee: Kevin Xu
• Reporter: Aruna Sadashiva
• Created: 22/Jul/15 18:20
• Updated: 06/Mar/18 16:18

Description

For the following unsupported JDBC catalog apis, T4 driver returns proper error msg, but T2 returns syntax error with some junk characters (or crashes with mtserver):

TestCat23(TestCatNew): Exception in test JDBC TestCat23 - Get Table Privileges..*** ERROR[15001] A syntax error occurred at or before:
èÕ9÷ÿ;
^ (3 characters from start of SQL statem
TestCat24(TestCatNew): Exception in test JDBC TestCat24 - Get Column Privileges..*** ERROR[15001] A syntax error occurred at or before:
èÕ9÷ÿ;
^ (3 characters from start of SQL statem
TestCat25(TestCatNew): Exception in test JDBC TestCat25 - Get Best Row Identifier..*** ERROR[15001] A syntax error occurred at or before:
øÕ9÷ÿ;
^ (3 characters from start of SQL statem
TestCat26(TestCatNew): Exception in test JDBC TestCat26 - Get Version Columns..*** ERROR[15001] A syntax error occurred at or before:
øÕ9÷ÿ;
^ (3 characters from start of SQL statem
TestCat27(TestCatNew): Exception in test JDBC TestCat27 - Get Procedures..*** ERROR[15001] A syntax error occurred at or before:
Ö9÷ÿ;
^ (1 characters from start of SQL stateme
TestCat28(TestCatNew): Exception in test JDBC TestCat28 - Get Procedure Columns..*** ERROR[15001] A syntax error occurred at or before:
Ö9÷ÿ;
^ (1 characters from start of SQL stateme
TestCat29(TestCatNew): Exception in test JDBC TestCat29 - Get Exported Keys..*** ERROR[15001] A syntax error occurred at or before:
øÕ9÷ÿ;
^ (3 characters from start of SQL statem
TestCat30(TestCatNew): Exception in test JDBC TestCat30 - Get Imported Keys..*** ERROR[15001] A syntax error occurred at or before:
øÕ9÷ÿ;
^ (3 characters from start of SQL statem
TestCat31(TestCatNew): Exception in test JDBC TestCat31 - Get Index Info..*** ERROR[15001] A syntax error occurred at or before:
Ö9÷ÿ;
^ (1 characters from start of SQL stateme
false
[trafodion@n007 basic]$