← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/mix2.inc

  • Committer: Stewart Smith
  • Date: 2010-04-08 07:20:26 UTC
  • mto: This revision was merged to the branch mainline in revision 1456.
  • Revision ID: stewart@flamingspork.com-20100408072026-w3s8zblhs35uo5mg
https://launchpad.net/bugs/557880
remove CHECKSUM TABLE

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/include/mix2.inc
991
991
insert t4 select * from t1;
992
992
insert t5 select * from t1;
993
993
insert t6 select * from t1;
994
 
checksum table t1, t2, t3, t4, t5, t6, t7;
995
 
checksum table t1, t2, t3, t4, t5, t6, t7;
996
 
checksum table t1, t2, t3, t4, t5, t6, t7;
997
994
# #show table status;
998
995
drop table t1,t2,t3, t4, t5, t6;
999
996
 
1565
1562
}
1566
1563
# End of FOREIGN tests
1567
1564
 
1568
 
if ($test_transactions)
1569
 
{
1570
 
#
1571
 
# Test that checksum table uses a consistent read Bug #12669
1572
 
#
1573
 
connect (a,localhost,root,,);
1574
 
connect (b,localhost,root,,);
1575
 
connection a;
1576
 
eval create $temp table t1(a int not null) engine=$engine_type DEFAULT CHARSET=latin1;
1577
 
insert into t1 values (1),(2);
1578
 
set autocommit=0;
1579
 
checksum table t1;
1580
 
connection b;
1581
 
insert into t1 values(3);
1582
 
connection a;
1583
 
#
1584
 
# Here checksum should not see insert
1585
 
#
1586
 
checksum table t1;
1587
 
connection a;
1588
 
commit;
1589
 
checksum table t1;
1590
 
commit;
1591
 
drop table t1;
1592
 
#
1593
 
# autocommit = 1
1594
 
#
1595
 
connection a;
1596
 
eval create $temp table t1(a int not null) engine=$engine_type DEFAULT CHARSET=latin1;
1597
 
insert into t1 values (1),(2);
1598
 
set autocommit=1;
1599
 
checksum table t1;
1600
 
connection b;
1601
 
set autocommit=1;
1602
 
insert into t1 values(3);
1603
 
connection a;
1604
 
#
1605
 
# Here checksum sees insert
1606
 
#
1607
 
checksum table t1;
1608
 
drop table t1;
1609
 
 
1610
 
connection default;
1611
 
disconnect a;
1612
 
disconnect b;
1613
 
}
1614
 
 
1615
1565
# tests for bugs #9802 and #13778
1616
1566
 
1617
1567
if ($test_foreign_keys)