[
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)
