[
https://issues.apache.org/jira/browse/TRAFODION-790?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14714248#comment-14714248
]
Suresh Subbiah commented on TRAFODION-790:
------------------------------------------
Justin Du (justin-du-2) wrote on 2015-02-12:
To debug the problem, I added few lines of code at the
generator/GenRelUpdate.cpp to capture the moment when we have rowset access set
but key info is not provided:
@@ -1291,8 +1291,11 @@ short HbaseDelete::codeGen(Generator * generator)
if (canDoCheckAndUpdel())
hbasescan_tdb->setCanDoCheckAndUpdel(TRUE);
- if (uniqueRowsetHbaseOper())
+ if (uniqueRowsetHbaseOper()) {
hbasescan_tdb->setRowsetOper(TRUE);
+ if (!keyInfo) abort();
+ GenAssert(keyInfo, "Rowset operation must be supported by key");
+ }
Ran the following and got a core:
explain update TRAFODION."_MD_".OBJECTS set catalog_name = 'TRAFODION',
schema_name = 'ALTER_RENAME_RENAME21', object_name = 'TAB_EMP_NEW_01' where
object_uid = 385679018054280799;
(gdb) bt
#0 0x0000003aab4328a5 in raise () from /lib64/libc.so.6
#1 0x0000003aab43400d in abort () from /lib64/libc.so.6
#2 0x00007fffee679446 in HbaseDelete::codeGen (this=0x7fffd5eaf908, generator=
0x7ffffffeab90) at ../generator/GenRelUpdate.cpp:1296
#3 0x00007fffee62e8aa in NestedJoin::codeGen (this=0x7fffd5fe0fb8,
generator=0x7ffffffeab90) at ../generator/GenRelJoin.cpp:3369
#4 0x00007fffee63ddf8 in Sort::codeGen (this=0x7fffd5fdff28,
generator=0x7ffffffeab90) at ../generator/GenRelMisc.cpp:3318
#5 0x00007fffee62e418 in NestedJoin::codeGen (this=0x7fffd5fdde80,
generator=0x7ffffffeab90) at ../generator/GenRelJoin.cpp:3283
#6 0x00007fffee62e418 in NestedJoin::codeGen (this=0x7fffd5fda7a0,
generator=0x7ffffffeab90) at ../generator/GenRelJoin.cpp:3283
#7 0x00007fffee6367df in RelRoot::codeGen (this=0x7fffd5fd87e0,
generator=0x7ffffffeab90) at ../generator/GenRelMisc.cpp:1202
#8 0x00007fffee5419bf in Generator::genCode (this=0x7ffffffeab90,
source=0x7fffd68e5f48 " update TRAFODION.\"_MD_\".OBJECTS set catalog_name
= 'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21', object_name =
'TAB_EMP_NEW_01' where object_uid = 385679018054280799;",
expr_node=0x7fffd5fd87e0)
at ../generator/Generator.cpp:528
#9 0x00007ffff0ad345c in CmpMain::compile (this=0x7ffffffee460,
input_str=0x7fffd68e5f48 " update TRAFODION.\"_MD_\".OBJECTS set
catalog_name = 'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21', object_name
= 'TAB_EMP_NEW_01' where object_uid = 385679018054280799;", charset=15,
queryExpr=@0x7ffffffee348, gen_code=0x7fffd68e5b08,
gen_code_len=0x7fffd68e5b00, heap=0x7fffe8b54c08, phase=CmpMain::END,
fragmentDir=0x7ffffffee5b8, op=3004, useQueryCache=1,
cacheable=0x7ffffffee334, begTime=0x7ffffffee350, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:2408
#10 0x00007ffff0ad1029 in CmpMain::sqlcomp (this=0x7ffffffee460,
input_str=0x7fffd68e5f48 " update TRAFODION.\"_MD_\".OBJECTS set
catalog_name = 'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21', object_name
= 'TAB_EMP_NEW_01' where object_uid = 385679018054280799;", charset=15,
queryExpr=@0x7ffffffee348, gen_code=0x7fffd68e5b08,
gen_code_len=0x7fffd68e5b00, heap=0x7fffe8b54c08, phase=CmpMain::END,
fragmentDir=0x7ffffffee5b8, op=3004, useQueryCache=1,
cacheable=0x7ffffffee334, begTime=0x7ffffffee350, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:1732
#11 0x00007ffff0ace734 in CmpMain::sqlcomp (this=0x7ffffffee460, input=...,
gen_code=0x7fffd68e5b08, gen_code_len=0x7fffd68e5b00, heap=0x7fffe8b54c08,
phase=CmpMain::END, fragmentDir=0x7ffffffee5b8, op=3004)
at ../sqlcomp/CmpMain.cpp:817
#12 0x00007ffff5484fd5 in CmpStatement::process (this=0x7fffd68cc680,
sqltext=...) at ../arkcmp/CmpStatement.cpp:508
#13 0x00007ffff5474fdb in CmpContext::compileDirect (this=0x7fffe7fbe090,
data=0x7fffe8b63d48 "\200", data_len=304, outHeap=0x7fffe95c4138,
charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7ffffffeeaf0,
gen_code_len=@0x7ffffffeeafc, parserFlags=131072, diagsArea=0x7fffe8b63e80)
at ../arkcmp/CmpContext.cpp:689
#14 0x00007ffff5eec941 in CliStatement::prepare2 (this=0x7fffe8b71800,
source=0x7fffe8ba2230 " update TRAFODION.\"_MD_\".OBJECTS set catalog_name
= 'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21', object_name =
'TAB_EMP_NEW_01' where object_uid = 385679018054280799;", diagsArea=...,
passed_gen_code=0x0, passed_gen_code_len=0, charset=15, unpackTdbs=1,
cliFlags=144) at ../cli/Statement.cpp:1827
#15 0x00007ffff5eeb6d4 in CliStatement::prepare (this=0x7fffe8b71800,
source=0x7fffe8ba2230 " update TRAFODION.\"_MD_\".OBJECTS set catalog_name
= 'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21', object_name =
'TAB_EMP_NEW_01' where object_uid = 385679018054280799;", diagsArea=...,
passed_gen_code=0x0, passed_gen_code_len=0, charset=15, unpackTdbs=1,
cliFlags=144) at ../cli/Statement.cpp:1420
#16 0x00007ffff5e82e7b in SQLCLI_Prepare2 (cliGlobals=0xb847a0,
statement_id=0x7fffe8b6fb60, sql_source=0x7fffe8b6fbb8, gencode_ptr=0x0,
gencode_len=0, ret_gencode_len=0x0, query_cost_info=0x7ffffffeffe0,
query_comp_stats_info=0x7ffffffeeee0, uniqueStmtId=0x0,
uniqueStmtIdLen=0x0, flags=128) at ../cli/Cli.cpp:5914
#17 0x00007ffff5f0eb79 in SQL_EXEC_Prepare2 (statement_id=0x7fffe8b6fb60,
sql_source=0x7fffe8b6fbb8, gencode_ptr=0x0, gencode_len=0,
ret_gencode_len=0x0, query_cost_info=0x7ffffffeffe0,
comp_stats_info=0x7ffffffeeee0, uniqueStmtId=0x0, uniqueStmtIdLen=0x0,
flags=128) at ../cli/CliExtern.cpp:4985
#18 0x00007ffff4929b52 in ExeCliInterface::prepare (this=0x7fffe8b74fc0,
stmtStr=0x7fffe8b58a48 " update TRAFODION.\"_MD_\".OBJECTS set catalog_name
= 'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21', object_name =
'TAB_EMP_NEW_01' where object_uid = 385679018054280799;",
module=0x7fffe8b6fb30,
stmt=0x7fffe8b6fb60, sql_src=0x7fffe8b6fbb8, input_desc=0x7fffe8b6fbf0,
output_desc=0x7fffe8b6fc28, outputBuf=0x0, outputVarPtrList=0x0,
inputBuf=0x0, inputVarPtrList=0x0, uniqueStmtId=0x0, uniqueStmtIdLen=0x0,
query_cost_info=0x0, comp_stats_info=0x0, monitorThis=0)
at ../executor/ExExeUtilCli.cpp:326
What I see from debugging the core is that the Delete::beginKeyPred_ is empty:
(gdb) p beginKeyPred_
$7 = {
<NAList<ValueId>> = {
<NACollection<ValueId>> = {
<NABasicObject> = {
_vptr.NABasicObject = 0x7ffff0eed330,
h_ = 0x0
},
members of NACollection<ValueId>:
maxLength_ = 3,
usedLength_ = 0,
entries_ = 0,
arr_ = 0x7fffd5e9de90,
usages_ = 0x7fffd5fe5100,
heap_ = 0x7fffd68e5130
},
members of NAList<ValueId>:
first_ = 111111111,
last_ = 111111111,
userIndexCache_ = 111111111,
arrayIndexCache_ = 111111111
},
members of ValueIdList:
static counter_ = 0x0
Will need to work with compiler team on this issue.
To reproduce the code (or the problem), add the lines above in
generator/GenRelUpdate.cpp and run the script giving number of iterations (it
may reproduce at the first try:
#!/bin/sh
if [ $# != 2 ]
then
echo " Usage: $0 <num_interation> "
exit
fi
(
echo " cqd query_cache '0'; "
total=$1
i=0
while [ $i -lt $total ]
do
echo " explain update TRAFODION.\"_MD_\".OBJECTS set catalog_name =
'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21', object_name =
'TAB_EMP_NEW_01' where object_uid = 385679018054280799; "
i=$(expr $i + 1)
done
) | sqlci
> LP Bug: 1395840 - Alter rename cores mxosrvr at
> ExHbaseAccessTcb::setupUniqueKeyAndCols()
> -----------------------------------------------------------------------------------------
>
> Key: TRAFODION-790
> URL: https://issues.apache.org/jira/browse/TRAFODION-790
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Weishiun Tsai
> Assignee: Suresh Subbiah
> Priority: Blocker
> Fix For: 2.0-incubating
>
>
> This core was seen several times when running the following sequence of
> commands. This problem can’t always be reproduced, but when it occurred, it
> always happened with the same statement and the cores all showed the same
> stack.
> This is seen on the v1119_0830 build installed on a 4-node cluster. It is a
> regression introduced between the v1108_0830 build and the v1119_0830 build.
> ------------------------------------------------------------------------------------------------------------------
> Here is the stack of the core files:
> #0 0x00007ffff527f8a5 in raise () from /lib64/libc.so.6
> #1 0x00007ffff528100d in abort () from /lib64/libc.so.6
> #2 0x00007ffff6388a55 in os::abort(bool) ()
> from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
> #3 0x00007ffff6508f87 in VMError::report_and_die() ()
> from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
> #4 0x00007ffff638d96f in JVM_handle_linux_signal ()
> from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
> #5 <signal handler called>
> #6 0x00007ffff3743a61 in ExHbaseAccessTcb::setupUniqueKeyAndCols (
> this=0x7fffce17ac50, doInit=0) at ../executor/ExHbaseAccess.cpp:1682
> #7 0x00007ffff374ee5b in ExHbaseAccessSQRowsetTcb::work (this=0x7fffce17ac50)
> at ../executor/ExHbaseIUD.cpp:3759
> #8 0x00007ffff37613c3 in ExScheduler::work (this=0x7fffce179758,
> prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
> #9 0x00007ffff36d3542 in ex_root_tcb::execute (this=0x7fffce17ebd8,
> cliGlobals=0xf40b30, glob=0x7fffd029e780, input_desc=0x7fffd16bb090,
> diagsArea=@0x7fffe4646a00, reExecute=0) at ../executor/ex_root.cpp:1029
> #10 0x00007ffff49c991c in CliStatement::execute (this=0x7fffce1bca38,
> cliGlobals=0xf40b30, input_desc=0x7fffd16bb090,
> diagsArea=<value optimized out>, execute_state=<value optimized out>,
> fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4779
> #11 0x00007ffff498c22a in SQLCLI_PerformTasks(CliGlobals *, ULng32,
> SQLSTMT_ID *
> , SQLDESC_ID *, SQLDESC_ID *, Lng32, Lng32, typedef __va_list_tag
> __va_list_tag *, SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *)
> (cliGlobals=0xf40b30, tasks=4882,
> statement_id=0x7fffcf38fe90, input_descriptor=0x7fffcf38ff00,
> output_descriptor=0x0, num_input_ptr_pairs=0, num_output_ptr_pairs=0,
> ap=0x7fffe4646ba0, input_ptr_pairs=0x0, output_ptr_pairs=0x0)
> at ../cli/Cli.cpp:3278
> #12 0x00007ffff498cf52 in SQLCLI_Exec(CliGlobals *, SQLSTMT_ID *, SQLDESC_ID
> *, Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *) (
> cliGlobals=<value optimized out>, statement_id=<value optimized out>,
> input_descriptor=<value optimized out>,
> num_ptr_pairs=<value optimized out>, ap=<value optimized out>,
> ptr_pairs=<value optimized out>) at ../cli/Cli.cpp:3525
> #13 0x00007ffff49d5ca5 in SQL_EXEC_Exec (statement_id=0x7fffcf38fe90,
> input_descriptor=0x7fffcf38ff00, num_ptr_pairs=0)
> at ../cli/CliExtern.cpp:2062
> #14 0x00007ffff3710bd1 in ExeCliInterface::exec (this=0x7fffe4648fc0,
> inputBuf=<value optimized out>, inputBufLen=<value optimized out>)
> at ../executor/ExExeUtilCli.cpp:599
> #15 0x00007ffff37144c5 in ExeCliInterface::executeImmediateExec (
> this=0x7fffe4648fc0, stmtStr=<value optimized out>, outputBuf=0x0,
> outputBufLen=0x0, nullTerminate=1, rowsAffected=0x0)
> at ../executor/ExExeUtilCli.cpp:898
> #16 0x00007ffff371744c in ExeCliInterface::executeImmediate (
> this=0x7fffe4648fc0,
> stmtStr=0x7fffe4646e00 "update TRAFODION.\"_MD_\".OBJECTS set
> catalog_name = 'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21',
> object_name = 'TAB_EMP_NEW_01' where object_uid = 103071044763640121 ",
> outputBuf=0x0, outputBufLen=0x0,
> nullTerminate=1, rowsAffected=0x0, monitorThis=0, globalDiags=0x0)
> at ../executor/ExExeUtilCli.cpp:993
> #17 0x00007ffff01b9264 in CmpSeabaseDDL::updateObjectName (
> this=0x7fffe464ae30, cliInterface=0x7fffe4648fc0,
> objUID=103071044763640121, catName=0x7fffe4649848 "TRAFODION",
> schName=<value optimized out>, objName=<value optimized out>)
> at ../sqlcomp/CmpSeabaseDDLcommon.cpp:3636
> #18 0x00007ffff01e9a1f in CmpSeabaseDDL::renameSeabaseTable (
> this=0x7fffe464ae30, renameTableNode=0x7fffe46488c0,
> currCatName=<value optimized out>, currSchName=<value optimized out>)
> at ../sqlcomp/CmpSeabaseDDLtable.cpp:2631
> #19 0x00007ffff01daade in CmpSeabaseDDL::executeSeabaseDDL (
> this=0x7fffe464ae30, ddlExpr=0x7fffd199c520, ddlNode=0x7fffd199c338,
> currCatName=..., currSchName=...)
> at ../sqlcomp/CmpSeabaseDDLcommon.cpp:5696
> #20 0x00007fffedfb240a in CmpStatement::process (this=<value optimized out>,
> statement=<value optimized out>) at ../arkcmp/CmpStatement.cpp:911
> #21 0x00007fffedfa82d8 in CmpContext::compileDirect (this=0x7fffe25dd090,
> data=0x7fffd01abef8 "\200", data_len=224, outHeap=0x7fffe3be60f0,
> charset=15, op=CmpMessageObj::PROCESSDDL, gen_code=@0x7fffe464b6f0,
> gen_code_len=@0x7fffe464b6fc, parserFlags=4194304,
> diagsArea=0x7fffd01abfe0) at ../arkcmp/CmpContext.cpp:718
> #22 0x00007ffff36954f0 in ExDDLTcb::work (this=0x7fffe316d0a8)
> at ../executor/ex_ddl.cpp:265
> #23 0x00007ffff37613c3 in ExScheduler::work (this=0x7fffe316cc10,
> prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
> #24 0x00007ffff36d3542 in ex_root_tcb::execute (this=0x7fffe316d680,
> cliGlobals=0xf40b30, glob=0x7fffd01ab8c0, input_desc=0x7fffe3180a40,
> diagsArea=@0x7fffe464ce10, reExecute=0) at ../executor/ex_root.cpp:1029
> #25 0x00007ffff49c991c in CliStatement::execute (this=0x7fffd16ecd08,
> cliGlobals=0xf40b30, input_desc=0x7fffe3180a40,
> diagsArea=<value optimized out>, execute_state=<value optimized out>,
> fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4779
> #26 0x00007ffff498c22a in SQLCLI_PerformTasks(CliGlobals *, ULng32,
> SQLSTMT_ID *, SQLDESC_ID *, SQLDESC_ID *, Lng32, Lng32, typedef __va_list_tag
> __va_list_tag *, SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *)
> (cliGlobals=0xf40b30, tasks=8063,
> statement_id=0x2deb558, input_descriptor=0x2deb588, output_descriptor=0x0,
> num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffe464cfb0,
> input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3278
> #27 0x00007ffff49d4f55 in SQL_EXEC_ClearExecFetchClose (
> statement_id=0x2deb558, input_descriptor=0x2deb588, output_descriptor=0x0,
> num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0)
> at ../cli/CliExtern.cpp:2618
> #28 0x00007ffff6e79b0f in SRVR::WSQL_EXEC_ClearExecFetchClose (
> statement_id=0x2deb558, input_descriptor=<value optimized out>,
> output_descriptor=<value optimized out>,
> num_input_ptr_pairs=<value optimized out>,
> num_output_ptr_pairs=<value optimized out>,
> num_total_ptr_pairs=<value optimized out>) at SQLWrapper.cpp:459
> #29 0x00007ffff6e7044f in SRVR::EXECUTE2 (pSrvrStmt=0x2deaf40)
> at sqlinterface.cpp:5521
> #30 0x00007ffff6ea0a45 in odbc_SQLSvc_Execute2_sme_ (
> objtag_=<value optimized out>, call_id_=<value optimized out>,
> dialogueId=<value optimized out>, sqlAsyncEnable=<value optimized out>,
> queryTimeout=<value optimized out>, inputRowCnt=<value optimized out>,
> sqlStmtType=0, stmtHandle=48148288, cursorLength=0, cursorName=0x0,
> cursorCharset=1, holdableCursor=0, inValuesLength=0, inValues=0x0,
> returnCode=0x7fffe464d8a8, sqlWarningOrErrorLength=0x7fffe464d8a4,
> sqlWarningOrError=@0x7fffe464d880, rowsAffected=0x7fffe464d8a0,
> outValuesLength=0x7fffe464d894, outValues=@0x7fffe464d878)
> at srvrothers.cpp:1514
> #31 0x00000000004d2685 in odbc_SQLSrvr_ExecDirect_ame_ (objtag_=0x31c8ce0,
> call_id_=0x31c8d38, dialogueId=1676333437,
> stmtLabel=<value optimized out>, cursorName=0x0,
> stmtExplainLabel=<value optimized out>, stmtType=0, sqlStmtType=0,
> sqlString=0x379d794 "alter table tab_emp_original_01 rename to
> tab_emp_new_01", sqlAsyncEnable=0, queryTimeout=0, inputRowCnt=0, txnID=0,
> holdableCursor=0)
> at SrvrConnect.cpp:7018
> #32 0x00000000004a1a36 in SQLEXECUTE_IOMessage (objtag_=0x31c8ce0,
> call_id_=0x31c8d38, operation_id=3012) at Interface/odbcs_srvr.cpp:1734
> #33 0x00000000004a1ae4 in DISPATCH_TCPIPRequest (objtag_=0x31c8ce0,
> call_id_=0x31c8d38, operation_id=<value optimized out>)
> at Interface/odbcs_srvr.cpp:1799
> #34 0x0000000000432a02 in BUILD_TCPIP_REQUEST (pnode=0x31c8ce0)
> at ../Common/TCPIPSystemSrvr.cpp:603
> #35 0x000000000043339d in PROCESS_TCPIP_REQUEST (pnode=0x31c8ce0)
> at ../Common/TCPIPSystemSrvr.cpp:581
> #36 0x0000000000470ad6 in CNSKListenerSrvr::tcpip_listener (arg=0xde0f40)
> at Interface/linux/Listener_srvr_ps.cpp:397
> #37 0x00007ffff50329f0 in sb_thread_sthr_disp (pp_arg=0xf13020)
> at threadl.cpp:253
> #38 0x00007ffff4bf9851 in start_thread () from /lib64/libpthread.so.0
> #39 0x00007ffff533590d in clone () from /lib64/libc.so.6
> ------------------------------------------------------------------------------------------------------------------
> Here is the execution output from trafci. The last ‘alter table
> tab_emp_original_01 rename to tab_emp_new_01;’ statement cored mxosrvr and
> caused trafci to lose its connection whenever the problem was seen:
> SQL>drop schema trafodion.alter_rename_rename21 cascade;
> --- SQL operation complete.
> SQL>create schema trafodion.alter_rename_rename21;
> --- SQL operation complete.
> SQL>set schema trafodion.alter_rename_rename21;
> --- SQL operation complete.
> SQL>set nametype ansi;
> --- SQL operation complete.
> SQL>create table tab_emp_original_01
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_emp_original_02
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_ten_original_03
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_ten_original_04
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_lrg_original_05
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_lrg_original_06
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>insert into tab_ten_original_03 values
> (1,'ABCDEFGH',1001,1001,11,'IJKLMNOPQRSTUVWX','YZABCDEF',1001,11,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (2,'ABCDEFGH',1002,1002,12,'IJKLMNOPQRSTUVWX','YZABCDEF',1002,12,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (3,'ABCDEFGH',1003,1003,13,'IJKLMNOPQRSTUVWX','YZABCDEF',1003,13,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (4,'ABCDEFGH',1004,1004,14,'IJKLMNOPQRSTUVWX','YZABCDEF',1004,14,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (5,'ABCDEFGH',1005,1005,15,'IJKLMNOPQRSTUVWX','YZABCDEF',1005,15,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (6,'ABCDEFGH',1006,1006,16,'IJKLMNOPQRSTUVWX','YZABCDEF',1006,16,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (7,'ABCDEFGH',1007,1007,17,'IJKLMNOPQRSTUVWX','YZABCDEF',1007,17,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (8,'ABCDEFGH',1008,1008,18,'IJKLMNOPQRSTUVWX','YZABCDEF',1008,18,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (9,'ABCDEFGH',1009,1009,19,'IJKLMNOPQRSTUVWX','YZABCDEF',1009,19,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (10,'ABCDEFGH',1010,1010,20,'IJKLMNOPQRSTUVWX','YZABCDEF',1010,20,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (1,'ABCDEFGH',1001,1001,11,'IJKLMNOPQRSTUVWX','YZABCDEF',1001,11,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (2,'ABCDEFGH',1002,1002,12,'IJKLMNOPQRSTUVWX','YZABCDEF',1002,12,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (3,'ABCDEFGH',1003,1003,13,'IJKLMNOPQRSTUVWX','YZABCDEF',1003,13,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (4,'ABCDEFGH',1004,1004,14,'IJKLMNOPQRSTUVWX','YZABCDEF',1004,14,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (5,'ABCDEFGH',1005,1005,15,'IJKLMNOPQRSTUVWX','YZABCDEF',1005,15,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (6,'ABCDEFGH',1006,1006,16,'IJKLMNOPQRSTUVWX','YZABCDEF',1006,16,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (7,'ABCDEFGH',1007,1007,17,'IJKLMNOPQRSTUVWX','YZABCDEF',1007,17,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (8,'ABCDEFGH',1008,1008,18,'IJKLMNOPQRSTUVWX','YZABCDEF',1008,18,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (9,'ABCDEFGH',1009,1009,19,'IJKLMNOPQRSTUVWX','YZABCDEF',1009,19,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (10,'ABCDEFGH',1010,1010,20,'IJKLMNOPQRSTUVWX','YZABCDEF',1010,20,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>upsert using load into
> trafodion.alter_rename_rename21.tab_lrg_original_05 select * from
> trafodion.g_cmureg.btpnl17a;
> --- SQL operation complete.
> SQL>select count(*) from tab_lrg_original_05;
> (EXPR)
> --------------------
> 2000
> --- 1 row(s) selected.
> SQL>update statistics for table tab_lrg_original_05 on every column;
> --- SQL operation complete.
> SQL>upsert using load into
> trafodion.alter_rename_rename21.tab_lrg_original_06 select * from
> trafodion.g_cmureg.btpnl17a;
> --- SQL operation complete.
> SQL>select count(*) from tab_lrg_original_06;
> (EXPR)
> --------------------
> 2000
> --- 1 row(s) selected.
> SQL>update statistics for table tab_lrg_original_06 on every column;
> --- SQL operation complete.
> -------------------------------------------------------------------------------
> == TEST: tcase.test001
> -------------------------------------------------------------------------------
> SQL>select * from tab_emp_original_01;
> --- 0 row(s) selected.
> SQL>showddl tab_emp_original_01;
> CREATE TABLE TRAFODION.ALTER_RENAME_RENAME21.TAB_EMP_ORIGINAL_01
> (
> SBIN0_10 NUMERIC(18, 0) DEFAULT NULL
> , CHAR0_2 CHAR(8) CHARACTER SET ISO88591 COLLATE
> DEFAULT DEFAULT NULL
> , UDEC0_UNIQ DECIMAL(9, 0) UNSIGNED DEFAULT NULL
> , UBIN0_UNIQ NUMERIC(9, 0) UNSIGNED DEFAULT NULL
> , SDEC0_500 DECIMAL(9, 0) DEFAULT NULL
> , VARCHAR0_10 VARCHAR(16) CHARACTER SET ISO88591
> COLLATE
> DEFAULT DEFAULT NULL
> , VARCHAR1_20 VARCHAR(8) CHARACTER SET ISO88591 COLLATE
> DEFAULT DEFAULT NULL
> , SBIN1_5000 NUMERIC(4, 0) DEFAULT NULL
> , SDEC1_4 DECIMAL(18, 0) DEFAULT NULL
> , CHAR1_4 CHAR(8) CHARACTER SET ISO88591 COLLATE
> DEFAULT DEFAULT NULL
> )
> ;
> --- SQL operation complete.
> SQL>alter table tab_emp_original_01 rename to tab_emp_new_01;
> *** ERROR[1] The message id: problem_with_server_read
> *** ERROR[1] The message id: header_not_long_enough
> *** ERROR[1] The message id: problem_with_server_read
> *** ERROR[1] The message id: header_not_long_enough
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
