Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
When the following sequence of commands are executed via trafci, the mxosrvr abends and we do not get the explain output.
=======================
SET SCHEMA 'trafodion.opencart2';
cqd allow_incompatible_comparison 'ON';
cqd disable_read_only 'ON';
cqd mode_special_1 'ON';
SELECT * FROM TABLE(explain(null, 'EXPLAIN_STMT=SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2."type", tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = ''shipping'' AND tr2cg.customer_group_id = ''1'' AND z2gz.country_id = ''222'' AND (z2gz.zone_id = ''0'' OR z2gz.zone_id = ''3563'') ORDER BY tr1.priority ASC '));
====================
The same set of commands when run from sqlci work fine and we get the explain output. But when run through trafci, it fails.
Interestingly if we change one of the LEFT JOIN to just JOIN as below, it works fine from trafci too.
SELECT * FROM TABLE(explain(null, 'EXPLAIN_STMT=SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2."type", tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = ''shipping'' AND tr2cg.customer_group_id = ''1'' AND z2gz.country_id = ''222'' AND (z2gz.zone_id = ''0'' OR z2gz.zone_id = ''3563'') ORDER BY tr1.priority ASC '));
A core file is generated when the mxosrvr abends and the stack trace shows the following:
#1 0x00007f859added8d in abort () from /lib64/libc.so.6
#2 0x00007f859add674e in __assert_fail_base () from /lib64/libc.so.6
#3 0x00007f859add6810 in __assert_fail () from /lib64/libc.so.6
#4 0x00007f859a2844a6 in str_decoded_len (charLen=16161) at ../common/str.cpp:929
#5 0x00007f8598d148e9 in ExExplainTcb::processExplainStmt (this=0x7f85861b51c8) at ../executor/ExExplain.cpp:545
#6 0x00007f8598d15087 in ExExplainTcb::work (this=0x7f85861b51c8) at ../executor/ExExplain.cpp:742
#7 0x00007f8598bda209 in ex_tcb::sWork (tcb=0x7f85861b51c8) at ../executor/ex_tcb.h:103
#8 0x00007f8598d6556b in ExSubtask::work (this=0x7f85861b6a98) at ../executor/ExScheduler.cpp:754
#9 0x00007f8598d6492e in ExScheduler::work (this=0x7f85861b4d30, prevWaitTime=0) at ../executor/ExScheduler.cpp:331
#10 0x00007f8598c35106 in ex_root_tcb::execute (this=0x7f85861b6b18, cliGlobals=0x2498fd0, glob=0x7f85861b3028, input_desc=0x7f85861beb80, diagsArea=@0x7f858763d240, reExecute=0)
at ../executor/ex_root.cpp:1058
#11 0x00007f859a6e1b67 in CliStatement::execute (this=0x7f85861b25b8, cliGlobals=0x2498fd0, input_desc=0x7f85861beb80, diagsArea=..., execute_state=CliStatement::INITIAL_STATE_, fixupOnly=0,
cliflags=0) at ../cli/Statement.cpp:4525
