← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/insert_select.result

Merge Stewart's dead code removal

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/insert_select.result
686
686
INSERT INTO t1 SELECT a + 2 FROM t1 LIMIT 1;
687
687
show status like 'Handler_read%';
688
688
Variable_name   Value
689
 
Handler_read_first      #
690
 
Handler_read_key        #
691
 
Handler_read_next       #
692
 
Handler_read_prev       #
693
 
Handler_read_rnd        #
694
 
Handler_read_rnd_next   #
 
689
Handler_read_first      1
 
690
Handler_read_key        2
 
691
Handler_read_next       0
 
692
Handler_read_prev       0
 
693
Handler_read_rnd        0
 
694
Handler_read_rnd_next   1
695
695
DROP TABLE t1;
696
696
CREATE TABLE t1 (
697
697
f1 int NOT NULL auto_increment PRIMARY KEY,
788
788
create table t1(f1 int);
789
789
insert into t1 values(1),(2),(3);
790
790
create temporary table t2 (key(f1)) engine=myisam select sql_buffer_result f1 from t1;
791
 
check table t2;
 
791
check table t2 extended;
792
792
Table   Op      Msg_type        Msg_text
793
793
test.t2 check   status  OK
794
794
drop table t1,t2;