~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/select.result

  • Committer: Brian Aker
  • Date: 2008-07-28 16:10:34 UTC
  • Revision ID: brian@tangent.org-20080728161034-uikvlvhhartqc2ht
First pass of removing length types for ints.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1940
1940
Tables_in_test (t?)
1941
1941
show full columns from t2;
1942
1942
Field   Type    Collation       Null    Key     Default Extra   Privileges      Comment
1943
 
auto    int(11) NULL    NO      PRI     NULL    auto_increment  #       
1944
 
fld1    int(6) unsigned NULL    NO      UNI     NULL            #       
 
1943
auto    int     NULL    NO      PRI     NULL    auto_increment  #       
 
1944
fld1    int unsigned    NULL    NO      UNI     NULL            #       
1945
1945
companynr       tinyint(2) unsigned     NULL    NO              NULL            #       
1946
1946
fld3    char(30)        latin1_swedish_ci       NO      MUL     NULL            #       
1947
1947
fld4    char(35)        latin1_swedish_ci       NO              NULL            #       
1949
1949
fld6    char(4) latin1_swedish_ci       NO              NULL            #       
1950
1950
show full columns from t2 from test like 'f%';
1951
1951
Field   Type    Collation       Null    Key     Default Extra   Privileges      Comment
1952
 
fld1    int(6) unsigned NULL    NO      UNI     NULL            #       
 
1952
fld1    int unsigned    NULL    NO      UNI     NULL            #       
1953
1953
fld3    char(30)        latin1_swedish_ci       NO      MUL     NULL            #       
1954
1954
fld4    char(35)        latin1_swedish_ci       NO              NULL            #       
1955
1955
fld5    char(35)        latin1_swedish_ci       NO              NULL            #