You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Atanu Mishra (JIRA)" <ji...@apache.org> on 2015/08/24 04:17:47 UTC
[jira] [Commented] (TRAFODION-305) LP Bug: 1323865 - Some ODBC api
tests fail with sql error Unknown PCode instruction
[ https://issues.apache.org/jira/browse/TRAFODION-305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14708677#comment-14708677 ]
Atanu Mishra commented on TRAFODION-305:
----------------------------------------
James Capps (james-capps) wrote on 2015-02-10: #3
During PCODE generation, we were attempting to generate a PCODE instruction to compare two operands for equality. The two operands had a data type of REC_BYTE_V_ASCII_LONG which is used only by ODBC. PCIT::getMemoryAddressingMode() does not currently know how to handle that datatype so it returned AM_NONE for the operand type. That resulted in a failure later.
Fix was to detect the operand(s) of that datatype and call
ex_clause::pCodeGenerate(...) rather than doing PCODE generation of the current expression.
Note: Also found a line saying
return ex_clause::pCodeGenerate(space, f);
which has been missing for a long time. We got away with it
because the preceding 'if' was always false for Trafodion.
Files changed:
.../exp/ExpPCodeClauseGen.cpp
Changed in trafodion:
status: In Progress → Fix Committed
Aruna Sadashiva (aruna-sadashiva) wrote on 2015-02-23: #4
Jieping tseted this and it works ok now.
Changed in trafodion:
status: Fix Committed → Fix Released
> LP Bug: 1323865 - Some ODBC api tests fail with sql error Unknown PCode instruction
> -----------------------------------------------------------------------------------
>
> Key: TRAFODION-305
> URL: https://issues.apache.org/jira/browse/TRAFODION-305
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Aruna Sadashiva
> Assignee: Apache Trafodion
> Priority: Critical
> Fix For: 1.1 (pre-incubation)
>
>
> Some ODBC API tests fail with this error:
> [Trafodion ODBC Driver][Trafodion Database] SQL ERROR:*** ERROR[2006] Internal error: assertion failure (Unknown PCode Instruction) in file ../exp/ExpPCode.cpp at line 1199.
> It worked when pcode was turned off with "cqd pcode_opt_level 'OFF'".
> Relevant SQL stmts used by this test are below, it fails during prepare of insert stmt.
> drop table UJZ6R0EHYY;
> create table UJZ6R0EHYY(RLUJZ6R0EH CHAR(10) CHARACTER SET ISO88591,WP4VDZAWNV VARCHAR(10) CHARACTER SET ISO88591,VT2DEURLUJ DECIMAL(10,5),Z6R0EHYYFC NUMERIC(10,5),TCBMMOHJ7F SMALLINT,LPIOBAI9_S INTEGER,NQ3KXGK5QS REAL,X1GWP4VDZA FLOAT,WNVT2DEURL DOUBLE PRECISION,YYFCTCBMMO DATE,HJ7FLPIOBA TIME,I9_S8NQ3KX TIMESTAMP,GK5QSX1GWP bigint,VDZAWNVT2D LONG VARCHAR CHARACTER SET ISO88591,EURLUJZ6R0 CHAR(10) CHARACTER SET UCS2,EHYYFCTCBM VARCHAR(10) CHARACTER SET UCS2,MOHJ7FLPIO LONG VARCHAR CHARACTER SET UCS2,BAI9_S8NQ3 NUMERIC(19,0),KXGK5QSX1G NUMERIC(19,6),T2DEURLUJZ NUMERIC(128,0),R0EHYYFCTC NUMERIC(128,128),BMMOHJ7FLP NUMERIC(128,64),IOBAI9_S8N NUMERIC(10,5) UNSIGNED,Q3KXGK5QSX NUMERIC(18,5) UNSIGNED,GWP4VDZAWN NUMERIC(30,10) UNSIGNED) NO PARTITION;
> insert into UJZ6R0EHYY (RLUJZ6R0EH,WP4VDZAWNV,VT2DEURLUJ,Z6R0EHYYFC,TCBMMOHJ7F,LPIOBAI9_S,NQ3KXGK5QS,X1GWP4VDZA,WNVT2DEURL,YYFCTCBMMO,HJ7FLPIOBA,I9_S8NQ3KX,GK5QSX1GWP,VDZAWNVT2D,EURLUJZ6R0,EHYYFCTCBM,MOHJ7FLPIO,BAI9_S8NQ3,KXGK5QSX1G,T2DEURLUJZ,R0EHYYFCTC,BMMOHJ7FLP,IOBAI9_S8N,Q3KXGK5QSX,GWP4VDZAWN) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);
> Assigned to LaunchPad User James Capps
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)