Comment 2 for bug 1317729

Verified on the datalake v40963 build. This problem has been fixed:

>>set schema mytest30;

--- 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;

-- Definition of Trafodion table TRAFODION.MYTEST30.TD1
-- Definition current Wed May 28 03:28:53 2014

  (
    "_SALT_" INT UNSIGNED NO DEFAULT NOT NULL NOT
      DROPPABLE
  , 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 td1;

--- SQL operation complete.
>>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.MYTEST30.SD1
-- Definition current Wed May 28 03:29:27 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.
>>