You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:15:32 UTC
[jira] [Created] (TRAFODION-294) LP Bug: 1322383 - Second create
table command failed with error 1390
Alice Chen created TRAFODION-294:
------------------------------------
Summary: LP Bug: 1322383 - Second create table command failed with error 1390
Key: TRAFODION-294
URL: https://issues.apache.org/jira/browse/TRAFODION-294
Project: Apache Trafodion
Issue Type: Bug
Reporter: JiepingZhang
Assignee: Anoop Sharma
Fix For: 0.8 (pre-incubation)
>From ODBC or Trafci, the 1st create table command was successful, but when issues the 2nd create table command, even it's a different table, the create table command failed with error 1390.
>From Trafci:
SQL>drop schema jptmp cascade;
--- SQL operation complete.
SQL>create schema jptmp;
--- SQL operation complete.
SQL>set schema jptmp;
--- SQL operation complete.
SQL>CREATE TABLE tmp_ROWSET_TABLE ( C01 CHAR( 20 ) CHARACTER SET ISO88591 NOT NULL, C02 CHAR( 20 ) CHARACTER SET UCS2, C03 VARCHAR( 20 ) CHARACTER SET ISO88591, C04 VARCHAR( 20 ) CHARACTER SET UCS2, C05 LONG VARCHAR( 20 ) CHARACTER SET ISO88591, C06 LONG VARCHAR( 20 ) CHARACTER SET UCS2, C07 NCHAR( 20 ), C08 NCHAR VARYING( 20 ), C09 DECIMAL (8, 0) SIGNED, C10 DECIMAL (8, 0) UNSIGNED, C11 NUMERIC (8, 0) SIGNED, C12 NUMERIC (8, 0) UNSIGNED, C13 TINYINT SIGNED, C14 TINYINT UNSIGNED, C15 SMALLINT SIGNED, C16 SMALLINT UNSIGNED, C17 INTEGER SIGNED NOT NULL, C18 INTEGER UNSIGNED, C19 LARGEINT NOT NULL NOT DROPPABLE, C20 REAL, C21 FLOAT(54), C22 DOUBLE PRECISION, C23 DATE, C24 TIME, C25 TIMESTAMP, C26 INTERVAL YEAR, C27 INTERVAL MONTH, C28 INTERVAL DAY, C29 INTERVAL HOUR, C30 INTERVAL MINUTE, C31 INTERVAL SECOND, C32 INTERVAL YEAR TO MONTH, C33 INTERVAL DAY TO HOUR, C34 INTERVAL DAY TO MINUTE, C35 INTERVAL DAY TO SECOND, C36 INTERVAL HOUR TO MINUTE, C37 INTERVAL HOUR TO SECOND, C38 INTERVAL MINUTE TO SECOND, C39 NUMERIC (19, 0) SIGNED, C40 NUMERIC (19, 0) UNSIGNED, PRIMARY KEY ( C19 ), CONSTRAINT C17T CHECK ( C17 < 50000 ) );
--- SQL operation complete.
SQL>CREATE TABLE jp_ROWSET_TABLE ( C01 CHAR( 20 ) CHARACTER SET ISO88591 NOT NULL, C02 CHAR( 20 ) CHARACTER SET UCS2, C03 VARCHAR( 20 ) CHARACTER SET ISO88591, C04 VARCHAR( 20 ) CHARACTER SET UCS2, C05 LONG VARCHAR( 20 ) CHARACTER SET ISO88591, C06 LONG VARCHAR( 20 ) CHARACTER SET UCS2, C07 NCHAR( 20 ), C08 NCHAR VARYING( 20 ), C09 DECIMAL (8, 0) SIGNED, C10 DECIMAL (8, 0) UNSIGNED, C11 NUMERIC (8, 0) SIGNED, C12 NUMERIC (8, 0) UNSIGNED, C13 TINYINT SIGNED, C14 TINYINT UNSIGNED, C15 SMALLINT SIGNED, C16 SMALLINT UNSIGNED, C17 INTEGER SIGNED NOT NULL, C18 INTEGER UNSIGNED, C19 LARGEINT NOT NULL NOT DROPPABLE, C20 REAL, C21 FLOAT(54), C22 DOUBLE PRECISION, C23 DATE, C24 TIME, C25 TIMESTAMP, C26 INTERVAL YEAR, C27 INTERVAL MONTH, C28 INTERVAL DAY, C29 INTERVAL HOUR, C30 INTERVAL MINUTE, C31 INTERVAL SECOND, C32 INTERVAL YEAR TO MONTH, C33 INTERVAL DAY TO HOUR, C34 INTERVAL DAY TO MINUTE, C35 INTERVAL DAY TO SECOND, C36 INTERVAL HOUR TO MINUTE, C37 INTERVAL HOUR TO SECOND, C38 INTERVAL MINUTE TO SECOND, C39 NUMERIC (19, 0) SIGNED, C40 NUMERIC (19, 0) UNSIGNED, PRIMARY KEY ( C19 ), CONSTRAINT C17T CHECK ( C17 < 50000 ) );
*** ERROR[1390] Object TRAFODION.JPTMP.JP_ROWSET_TABLE already exists in Trafodion. [2014-05-22 16:26:07]
If the same test run from ODBC, besides error 1390, TMF error 8610 was returned follow error 1389.
SQLExecDirect:
In: hstmt = 0x000000000027C450, szSqlStr = "", cbSqlStr = -3
Return: SQL_ERROR=-1
stmt: szSqlState = "X01AT", *pfNativeError = -1389, *pcbErrorMsg = 165, *ColumnNumber = -1, *RowNumber = -2
MessageText = "[TRAF][Trafodion ODBC Driver][Trafodion Database] SQL error:*** ERROR[1389] Object TRAFODION.JPTMP.JP_ROWSET_TABLE does not exist in Trafodion. [2014-05-22 14:37:52]"
stmt: szSqlState = "40003", *pfNativeError = -8610, *pcbErrorMsg = 175, *ColumnNumber = -1, *RowNumber = -2
MessageText = "[TRAF][Trafodion ODBC Driver][Trafodion Database] SQL error:*** ERROR[8610] Transaction subsystem TMF reported error 75 on a waited rollback transaction. [2014-05-22 14:37:52]"
stmt: szSqlState = "40003", *pfNativeError = -8610, *pcbErrorMsg = 175, *ColumnNumber = -1, *RowNumber = -2
MessageText = "[TRAF][Trafodion ODBC Driver][Trafodion Database] SQL error:*** ERROR[8610] Transaction subsystem TMF reported error 75 on a waited rollback transaction. [2014-05-22 14:37:52]"
stmt: szSqlState = "40000", *pfNativeError = -8839, *pcbErrorMsg = 122, *ColumnNumber = -1, *RowNumber = -2
MessageText = "[TRAF][Trafodion ODBC Driver][Trafodion Database] SQL error:*** ERROR[8839] Transaction was aborted. [2014-05-22 14:37:52]"
stmt: szSqlState = "40003", *pfNativeError = -8610, *pcbErrorMsg = 175, *ColumnNumber = -1, *RowNumber = -2
MessageText = "[TRAF][Trafodion ODBC Driver][Trafodion Database] SQL error:*** ERROR[8610] Transaction subsystem TMF reported error 75 on a waited rollback transaction. [2014-05-22 14:37:52]"
stmt: szSqlState = "23000", *pfNativeError = -8102, *pcbErrorMsg = 148, *ColumnNumber = -1, *RowNumber = -2
MessageText = "[TRAF][Trafodion ODBC Driver][Trafodion Database] SQL error:*** ERROR[8102] The operation is prevented by a unique constraint. [2014-05-22 14:37:52]"
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)