trafodion-codereview mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From zellerh <...@git.apache.org>
Subject [GitHub] incubator-trafodion pull request #811: [TRAFODION-2322] Improve UPDATE STATS...
Date Thu, 03 Nov 2016 19:58:27 GMT
Github user zellerh commented on a diff in the pull request:

    https://github.com/apache/incubator-trafodion/pull/811#discussion_r86429502
  
    --- Diff: core/sql/regress/seabase/EXPECTED040 ---
    @@ -227,6 +262,122 @@ CREATE TABLE TRAFODION.T040SCH.T040NOSALTSAME
     
     --- SQL operation complete.
     >>
    +>>create table t040limitedcols like t040bigcols 
    ++>limit column length to 256;
    +
    +--- SQL operation complete.
    +>>
    +>>showddl t040limitedcols;
    +
    +CREATE TABLE TRAFODION.T040SCH.T040LIMITEDCOLS
    +  (
    +    A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
    +  , B                                CHAR(256) CHARACTER SET ISO88591 COLLATE
    +      DEFAULT DEFAULT NULL
    +  , C                                VARCHAR(256) CHARACTER SET ISO88591
    +      COLLATE DEFAULT DEFAULT NULL
    +  , D                                CHAR(256 BYTES) CHARACTER SET UTF8 COLLATE
    +      DEFAULT DEFAULT NULL
    +  , E                                VARCHAR(256 BYTES) CHARACTER SET UTF8
    +      COLLATE DEFAULT DEFAULT NULL
    +  , F                                CHAR(128) CHARACTER SET UCS2 COLLATE
    +      DEFAULT DEFAULT NULL
    +  , G                                VARCHAR(128) CHARACTER SET UCS2 COLLATE
    +      DEFAULT DEFAULT NULL
    +  , PRIMARY KEY (A ASC)
    +  )
    + ATTRIBUTES ALIGNED FORMAT
    +;
    +
    +--- SQL operation complete.
    +>>
    +>>create table t040somelimitedcols like t040bigcols 
    ++>limit column length to 1002;
    +
    +--- SQL operation complete.
    +>>
    +>>showddl t040somelimitedcols;
    +
    +CREATE TABLE TRAFODION.T040SCH.T040SOMELIMITEDCOLS
    +  (
    +    A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
    +  , B                                CHAR(1000) CHARACTER SET ISO88591 COLLATE
    +      DEFAULT DEFAULT NULL
    +  , C                                VARCHAR(1001) CHARACTER SET ISO88591
    +      COLLATE DEFAULT DEFAULT NULL
    +  , D                                CHAR(1002 BYTES) CHARACTER SET UTF8
    +      COLLATE DEFAULT DEFAULT NULL
    +  , E                                VARCHAR(1002 BYTES) CHARACTER SET UTF8
    +      COLLATE DEFAULT DEFAULT NULL
    +  , F                                CHAR(501) CHARACTER SET UCS2 COLLATE
    +      DEFAULT DEFAULT NULL
    +  , G                                VARCHAR(501) CHARACTER SET UCS2 COLLATE
    +      DEFAULT DEFAULT NULL
    +  , PRIMARY KEY (A ASC)
    +  )
    + ATTRIBUTES ALIGNED FORMAT
    +;
    +
    +--- SQL operation complete.
    +>>
    +>>create table t040fewerlimitedcols like t040bigcols 
    ++>limit column length to 2010;
    +
    +--- SQL operation complete.
    +>>
    +>>showddl t040fewerlimitedcols;
    +
    +CREATE TABLE TRAFODION.T040SCH.T040FEWERLIMITEDCOLS
    +  (
    +    A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
    +  , B                                CHAR(1000) CHARACTER SET ISO88591 COLLATE
    +      DEFAULT DEFAULT NULL
    +  , C                                VARCHAR(1001) CHARACTER SET ISO88591
    +      COLLATE DEFAULT DEFAULT NULL
    +  , D                                CHAR(2010 BYTES) CHARACTER SET UTF8
    +      COLLATE DEFAULT DEFAULT NULL
    +  , E                                VARCHAR(2010 BYTES) CHARACTER SET UTF8
    +      COLLATE DEFAULT DEFAULT NULL
    +  , F                                CHAR(1004) CHARACTER SET UCS2 COLLATE
    +      DEFAULT DEFAULT NULL
    +  , G                                VARCHAR(1005) CHARACTER SET UCS2 COLLATE
    +      DEFAULT DEFAULT NULL
    +  , PRIMARY KEY (A ASC)
    +  )
    + ATTRIBUTES ALIGNED FORMAT
    --- End diff --
    
    Maybe make one of these tables salted and/or divisioned and is is possible to limit a
key column?


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

Mime
View raw message