← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/select.result

  • Committer: Brian Aker
  • Date: 2010-01-15 01:41:40 UTC
  • mfrom: (1259.8.3 i_s_work)
  • Revision ID: brian@gaz-20100115014140-0n6kh7fqhp1abqs4
Merge Joe Daly

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/select.result
2448
2448
create table t11 like t1;
2449
2449
insert into t1 values(1,""),(2,"");
2450
2450
show table status like 't1%';
2451
 
Name    Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length    Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation       Checksum        Create_options  Comment
2452
 
t1      InnoDB  X       Compact 2       8192    X       X       X       X       X       X       X       X       utf8_general_ci NULL            
2453
 
t11     InnoDB  X       Compact 0       0       X       X       X       X       X       X       X       X       utf8_general_ci NULL            
 
2451
Name    Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length    Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation       Checksum        Create_options  Comment Plugin_name
 
2452
t1      InnoDB  X       Compact 2       8192    X       X       X       X       X       X       X       X       utf8_general_ci NULL                    NULL
 
2453
t11     InnoDB  X       Compact 0       0       X       X       X       X       X       X       X       X       utf8_general_ci NULL                    NULL
2454
2454
select 123 as a from t1 where f1 is null;
2455
2455
a
2456
2456
drop table t1,t11;