Alice Chen created TRAFODION-1126:
-------------------------------------
Summary: LP Bug: 1439505 - Query Cancel for DDL statement "ALTER
TABLE DROP COLUMN" failed
Key: TRAFODION-1126
URL: https://issues.apache.org/jira/browse/TRAFODION-1126
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Reporter: Chong Hsu
Assignee: Apache Trafodion
Priority: Critical
Tested in Trafodion v1.1 build 2015-03-29.
A testcsae for Query Cancel failed to cancel a DDL statement "ALTER TABLE DROP
COLUMN". The testcase executed a "ALTER TABLE DROP COLUMN" statement from a
trafci session, then cancel it from another trafci session. The statement
failed to be cancelled properly.
The log files, ssmp_0.log, can found on cluster centos-mapr1.hpl.hp.com (node
centos-mapr6) /home/trafodion/trafodion-20150329_0830/logs (in attachment
too). The core files, core.2015-04-01_10-17-04.Z000QB3.31013.mxosrvr, can
found on cluster centos-mapr1.hpl.hp.com (node centos-mapr6)
/home/trafodion/trafodion-20150329_0830/sql/scripts.
Below are detail steps to reproduce the error:
---------------------------------------
>From a trafci session 1:
create schema sch1;
set schema sch1;
create table f01(
colkey int not null,
colint int not null,
-- coldate date,
colnum numeric(11,3),
colchariso char(11) character set iso88591 not null,
colcharucs2 char(11) character set ucs2 not null,
colintn int,
-- colts timestamp,
colcharison char(13) character set iso88591,
colcharucs2n char(13) character set ucs2,
primary key(colint, colchariso, colcharucs2, colkey)
)
;
upsert using load into f01 select
c1+c2*10+c3*100+c4*1000+c5*10000, --colkey
c1+c2*10+c3*100+c4*1000+c5*10000, --colint
cast(c1+c2*10+c3*100+c4*1000+c5*10000 as numeric(11,3)), --colnum
cast(c1+c2*10+c3*100+c4*1000+c5*10000 as char(11) character set
iso88591), --colchariso
cast(c1+c2*10+c3*100+c4*1000+c5*10000 as char(11) character set ucs2),
--colcharucs2
c1+c2*10+c3*100+c4*1000+c5*10000, --colintn
cast(c1+c2*10+c3*100+c4*1000+c5*10000 as char(13) character set
iso88591), --colvchriso
cast(c1+c2*10+c3*100+c4*1000+c5*10000 as char(13) character set ucs2)
--colvchrucs2
from (values(1)) t
transpose 0,1,2,3,4,5,6,7,8,9 as c1
transpose 0,1,2,3,4,5,6,7,8,9 as c2
transpose 0,1,2,3,4,5,6,7,8,9 as c3
transpose 0,1,2,3,4,5,6,7,8,9 as c4
transpose 0,1,2,3,4,5,6,7,8,9 as c5;
prepare xx from alter table f01 drop column colintn;
execute xx;
-------------------
>From trafci session 2:
control query cancel qid "<QID from session 1>";
------------------
In tarfci session 1:
execute xx;
*** ERROR[1] The message id: problem_with_server_read
*** ERROR[1] The message id: header_not_long_enough
Assigned to LaunchPad User Mike Hanlon
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
