← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/pool_of_threads.result

  • Committer: Jay Pipes
  • Date: 2009-02-04 15:44:25 UTC
  • mfrom: (829 drizzle)
  • mto: This revision was merged to the branch mainline in revision 830.
  • Revision ID: jpipes@serialcoder-20090204154425-th8xfk2ujz2y8xwg
Merge with trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/pool_of_threads.result
2064
2064
show full columns from t2;
2065
2065
Field   Type    Collation       Null    Key     Default Extra   Privileges      Comment
2066
2066
auto    int     NULL    NO      PRI     NULL    auto_increment  #       
2067
 
fld1    int     NULL    NO      UNI     0               #       
2068
 
companynr       int     NULL    NO              0               #       
2069
 
fld3    varchar(30)     utf8_general_ci NO      MUL                     #       
2070
 
fld4    varchar(35)     utf8_general_ci NO                              #       
2071
 
fld5    varchar(35)     utf8_general_ci NO                              #       
2072
 
fld6    varchar(4)      utf8_general_ci NO                              #       
 
2067
fld1    int     NULL    NO      UNI     NULL            #       
 
2068
companynr       int     NULL    NO              NULL            #       
 
2069
fld3    varchar(30)     utf8_general_ci NO      MUL     NULL            #       
 
2070
fld4    varchar(35)     utf8_general_ci NO              NULL            #       
 
2071
fld5    varchar(35)     utf8_general_ci NO              NULL            #       
 
2072
fld6    varchar(4)      utf8_general_ci NO              NULL            #       
2073
2073
show full columns from t2 from test like 'f%';
2074
2074
Field   Type    Collation       Null    Key     Default Extra   Privileges      Comment
2075
 
fld1    int     NULL    NO      UNI     0               #       
2076
 
fld3    varchar(30)     utf8_general_ci NO      MUL                     #       
2077
 
fld4    varchar(35)     utf8_general_ci NO                              #       
2078
 
fld5    varchar(35)     utf8_general_ci NO                              #       
2079
 
fld6    varchar(4)      utf8_general_ci NO                              #       
 
2075
fld1    int     NULL    NO      UNI     NULL            #       
 
2076
fld3    varchar(30)     utf8_general_ci NO      MUL     NULL            #       
 
2077
fld4    varchar(35)     utf8_general_ci NO              NULL            #       
 
2078
fld5    varchar(35)     utf8_general_ci NO              NULL            #       
 
2079
fld6    varchar(4)      utf8_general_ci NO              NULL            #       
2080
2080
show full columns from t2 from test like 's%';
2081
2081
Field   Type    Collation       Null    Key     Default Extra   Privileges      Comment
2082
2082
show keys from t2;
2091
2091
aufnr int NOT NULL default '0',
2092
2092
username varchar(50) NOT NULL default '',
2093
2093
hdl_nr int NOT NULL default '0',
2094
 
eintrag date NULL,
 
2094
eintrag date NOT NULL default '0000-00-00',
2095
2095
st_klasse varchar(40) NOT NULL default '',
2096
2096
st_wert varchar(40) NOT NULL default '',
2097
2097
st_zusatz varchar(40) NOT NULL default '',