[
https://issues.apache.org/jira/browse/TRAFODION-254?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14708612#comment-14708612
]
Atanu Mishra commented on TRAFODION-254:
----------------------------------------
Hans Zeller (hans-zeller) on 2014-06-23
Changed in trafodion:
status: New → In Progress
Hans Zeller (hans-zeller) on 2014-07-29
Changed in trafodion:
status: In Progress → Fix Committed
Hans Zeller (hans-zeller) wrote on 2014-07-29: #5
After an earlier fix by Anoop allowed salting on float columns, I now checked
in a fix that returns an error on Jyly 17: https://review.trafodion.org/108
Weishiun Tsai (wei-shiun-tsai) wrote on 2014-08-01: #6
Verified on the 0801_0830 daily build. Create table td1 with a float column
salt key now returns an error 1120:
>>set schema mytest;
--- SQL operation complete.
>>
>>create table td1 (a largeint not null, b smallint not null, c float(10) not
>>null, d double precision) store by (a, b, c) salt using 2 partitions on (c,
>>b);
*** ERROR[1120] Use of approximate numeric datatype (float, real, double
precision) in a partitioning key or salt clause is not allowed.
--- SQL operation failed with errors.
>>
>>invoke td1;
*** ERROR[4082] Object TRAFODION.MYTEST.TD1 does not exist or is inaccessible.
--- SQL operation failed with errors.
>>
>>drop table td1;
*** ERROR[1389] Object TRAFODION.MYTEST.TD1 does not exist in Trafodion.
--- SQL operation failed with errors.
>>
>>create table sd1 (a largeint not null, b smallint not null, c float(10) not
>>null, d double precision) store by (a, b, c);
--- SQL operation complete.
>>invoke sd1;
-- Definition of Trafodion table TRAFODION.MYTEST.SD1
-- Definition current Fri Aug 1 21:04:44 2014
(
SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
, A LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
, B SMALLINT NO DEFAULT NOT NULL NOT DROPPABLE
, C DOUBLE PRECISION NO DEFAULT NOT NULL NOT
DROPPABLE
, D DOUBLE PRECISION DEFAULT NULL
)
--- SQL operation complete.
>>
>>drop table sd1;
--- SQL operation complete.
Changed in trafodion:
status: Fix Committed → Fix Released
> LP Bug: 1317729 - Table salted with a float key can’t be invoked or dropped
> ---------------------------------------------------------------------------
>
> Key: TRAFODION-254
> URL: https://issues.apache.org/jira/browse/TRAFODION-254
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Weishiun Tsai
> Assignee: Hans Zeller
> Priority: Critical
> Fix For: 0.8 (pre-incubation)
>
>
> When a table was created using salt with a float key, the table creation
> operation was completed successfully. But the table couldn’t be invoked,
> nor could it be dropped. The invoke statement returned error 1120 and the
> drop statement returned error 1389. The following output shows that td1 was
> created using salt with a float key and the errors from invoke and drop. Sd1
> was created with the same ddl except for the salting. Invoke and drop work
> fine on sd1.
> This is seen on the datalake v40174 build installed on a workstation.
> >>set schema mytest;
> --- SQL operation complete.
> >>create table td1 (a largeint not null, b smallint not null, c float(10) not
> >>null, d double precision) store by (a, b, c) salt using 2 partitions on (c,
> >>b);
> --- SQL operation complete.
> >>invoke td1;
> *** ERROR[1120] Use of float datatype in a partitioning key is not allowed.
> --- SQL operation failed with errors.
> >>drop table td1;
> *** ERROR[1389] Object TRAFODION.MYTEST.TD1 does not exist in Trafodion.
> >>create table sd1 (a largeint not null, b smallint not null, c float(10) not
> >>null, d double precision) store by (a, b, c);
> --- SQL operation complete.
> >>invoke sd1;
> -- Definition of Trafodion table TRAFODION.MYTEST.SD1
> -- Definition current Fri May 9 03:49:04 2014
> (
> SYSKEY LARGEINT NO DEFAULT NOT NULL NOT
> DROPPABLE
> , A LARGEINT NO DEFAULT NOT NULL NOT
> DROPPABLE
> , B SMALLINT NO DEFAULT NOT NULL NOT
> DROPPABLE
> , C DOUBLE PRECISION NO DEFAULT NOT NULL NOT
> DROPPABLE
> , D DOUBLE PRECISION DEFAULT NULL
> )
> --- SQL operation complete.
> >>drop table sd1;
> --- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
