← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/select.result

  • Committer: Monty Taylor
  • Date: 2008-07-30 22:14:34 UTC
  • mfrom: (239 drizzle)
  • mto: (202.3.5 gettextize)
  • mto: This revision was merged to the branch mainline in revision 243.
  • Revision ID: monty@inaugust.com-20080730221434-aqmamn79nvzgbvks
Merged from trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/select.result
1943
1943
auto    int     NULL    NO      PRI     NULL    auto_increment  #       
1944
1944
fld1    int unsigned    NULL    NO      UNI     NULL            #       
1945
1945
companynr       tinyint(3) unsigned     NULL    NO              NULL            #       
1946
 
fld3    char(30)        latin1_swedish_ci       NO      MUL     NULL            #       
1947
 
fld4    char(35)        latin1_swedish_ci       NO              NULL            #       
1948
 
fld5    char(35)        latin1_swedish_ci       NO              NULL            #       
1949
 
fld6    char(4) latin1_swedish_ci       NO              NULL            #       
 
1946
fld3    varchar(30)     latin1_swedish_ci       NO      MUL     NULL            #       
 
1947
fld4    varchar(35)     latin1_swedish_ci       NO              NULL            #       
 
1948
fld5    varchar(35)     latin1_swedish_ci       NO              NULL            #       
 
1949
fld6    varchar(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
1952
fld1    int unsigned    NULL    NO      UNI     NULL            #       
1953
 
fld3    char(30)        latin1_swedish_ci       NO      MUL     NULL            #       
1954
 
fld4    char(35)        latin1_swedish_ci       NO              NULL            #       
1955
 
fld5    char(35)        latin1_swedish_ci       NO              NULL            #       
1956
 
fld6    char(4) latin1_swedish_ci       NO              NULL            #       
 
1953
fld3    varchar(30)     latin1_swedish_ci       NO      MUL     NULL            #       
 
1954
fld4    varchar(35)     latin1_swedish_ci       NO              NULL            #       
 
1955
fld5    varchar(35)     latin1_swedish_ci       NO              NULL            #       
 
1956
fld6    varchar(4)      latin1_swedish_ci       NO              NULL            #       
1957
1957
show full columns from t2 from test like 's%';
1958
1958
Field   Type    Collation       Null    Key     Default Extra   Privileges      Comment
1959
1959
drop table t4, t3, t2, t1;
3134
3134
t3.a=t2.a AND t3.c IN ('bb','ee') ;
3135
3135
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
3136
3136
1       SIMPLE  t1      const   PRIMARY PRIMARY 4       const   1       
3137
 
1       SIMPLE  t3      range   PRIMARY,ci      ci      5       NULL    6       Using where; Using index
 
3137
1       SIMPLE  t3      range   PRIMARY,ci      ci      7       NULL    6       Using where; Using index
3138
3138
1       SIMPLE  t2      ref     si,ai   ai      5       test.t3.a       1       Using where
3139
3139
EXPLAIN 
3140
3140
SELECT t3.a FROM t1,t2 FORCE INDEX (si),t3