← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/mix1.inc

  • Committer: Jay Pipes
  • Date: 2009-09-21 14:33:44 UTC
  • mfrom: (1126.10.26 dtrace-probes)
  • mto: This revision was merged to the branch mainline in revision 1133.
  • Revision ID: jpipes@serialcoder-20090921143344-jnarp7gcn6zmg19c
Merge fixes from Trond and Padraig on dtrace probes.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/include/mix1.inc
857
857
--echo
858
858
 
859
859
SELECT table_schema, table_name, row_format
860
 
FROM data_dictionary.TABLES
 
860
FROM INFORMATION_SCHEMA.TABLES
861
861
WHERE table_schema = DATABASE() AND table_name = 't1';
862
862
 
863
863
--echo
869
869
--echo
870
870
 
871
871
SELECT table_schema, table_name, row_format
872
 
FROM data_dictionary.TABLES
 
872
FROM INFORMATION_SCHEMA.TABLES
873
873
WHERE table_schema = DATABASE() AND table_name = 't1';
874
874
 
875
875
--echo
978
978
insert into t1(f1) values(1);
979
979
--replace_column 1 #
980
980
select @a:=f2 from t1;
 
981
--sleep 5
981
982
update t1 set f1=1;
982
983
--replace_column 1 #
983
984
select @b:=f2 from t1;
984
985
select if(@a=@b,"ok","wrong");
 
986
--sleep 5
985
987
insert into t1(f1) values (1) on duplicate key update f1="1";
986
988
--replace_column 1 #
987
989
select @b:=f2 from t1;
988
990
select if(@a=@b,"ok","wrong");
 
991
--sleep 5
989
992
insert into t1(f1) select f1 from t1 on duplicate key update f1="1";
990
993
--replace_column 1 #
991
994
select @b:=f2 from t1;