[
https://issues.apache.org/jira/browse/TRAFODION-247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-247.
----------------------------------
Resolution: Fixed
Assignee: (was: Hans Zeller)
> LP Bug: 1315567 - insert into salt table fails with ERROR[1123]
> ---------------------------------------------------------------
>
> Key: TRAFODION-247
> URL: https://issues.apache.org/jira/browse/TRAFODION-247
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Reporter: Julie Thai
> Priority: Critical
> Fix For: 0.9 (pre-incubation)
>
>
> Create salt table with primary key on varchar ucs2 column. Insert into salt
> table fails with ERROR[1123].
> From sqlci:
> >>CREATE TABLE f00(
> +> colkey int not null,
> +> colvchrucs2 varchar(100) character set ucs2 not null,
> +> primary key (colvchrucs2))
> +> salt using 3 partitions;
> --- SQL operation complete.
> >>
> >>INSERT INTO f00 VALUES (1, 'abcde'), (2, 'fghij'), (3, 'klmnopqrs'), (4,
> >>'tuvwxyz'), (5, 'abc@#$%^&*()efgh');
> *** ERROR[1123] Not all of the partition key values () for object
> TRAFODION.SEABASE.F00 could be processed. Please verify that the correct key
> value data types were specified.
> *** ERROR[8822] The statement was not prepared.
> >>
> >>CREATE TABLE f01(
> +> colkey int not null,
> +> colvchrucs2 varchar(100) character set ucs2 not null,
> +> primary key (colvchrucs2));
> --- SQL operation complete.
> >>
> >>INSERT INTO f01 VALUES (1, 'abcde'), (2, 'fghij'), (3, 'klmnopqrs'), (4,
> >>'tuvwxyz'), (5, 'abc@#$%^&*()efgh');
> --- 5 row(s) inserted.
> MY_SQROOT=/opt/home/thaiju/datalake_64_1
> who@host=tha...@g4t3029.houston.hp.com
> JAVA_HOME=/opt/home/tools/jdk1.7.0_09_64
> linux=2.6.32-279.el6.x86_64
> redhat=6.3
> Release 0.7.0 (Build release [39961], branch 39961-project/datalake_64_1,
> date 02May14)
> To reproduce, in sqlci issue:
> DROP TABLE f00;
> DROP TABLE f01;
> CREATE TABLE f00(
> colkey int not null,
> colvchrucs2 varchar(100) character set ucs2 not null,
> primary key (colvchrucs2))
> salt using 3 partitions;
> INSERT INTO f00 VALUES (1, 'abcde'), (2, 'fghij'), (3, 'klmnopqrs'), (4,
> 'tuvwxyz'), (5, 'abc@#$%^&*()efgh');
> CREATE TABLE f01(
> colkey int not null,
> colvchrucs2 varchar(100) character set ucs2 not null,
> primary key (colvchrucs2));
> INSERT INTO f01 VALUES (1, 'abcde'), (2, 'fghij'), (3, 'klmnopqrs'), (4,
> 'tuvwxyz'), (5, 'abc@#$%^&*()efgh');
> Also, try showddl and invoke.
> Then rerun reproducible script again but this time with primary key
> DESCENDING.
> Again, try showddl and invoke.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
