diff options
Diffstat (limited to 'mysql-test/t/myisam.test')
| -rw-r--r-- | mysql-test/t/myisam.test | 23 |
1 files changed, 21 insertions, 2 deletions
diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index f8d9f15fab1..76d37fdc734 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -4,7 +4,7 @@ # Initialise --disable_warnings -drop table if exists t1,t2; +drop table if exists t1,t2,t3; --enable_warnings SET SQL_WARNINGS=1; @@ -1477,5 +1477,24 @@ CREATE TABLE t1 ( --exec $MYISAMCHK -d $MYSQLTEST_VARDIR/master-data/test/t1 DROP TABLE t1; ---echo End of 5.1 tests +# Test warnings with transactional=1 with MyISAM +# +create table t1 (n int not null, c char(1)) transactional=1; +show create table t1; +drop table t1; + +# +# Test of BUG#35570 CHECKSUM TABLE unreliable if LINESTRING field +# (same content / differen checksum) +# +CREATE TABLE t1 (line LINESTRING NOT NULL) engine=myisam; +INSERT INTO t1 VALUES (GeomFromText("POINT(0 0)")); +checksum table t1; +CREATE TABLE t2 (line LINESTRING NOT NULL) engine=myisam; +INSERT INTO t2 VALUES (GeomFromText("POINT(0 0)")); +checksum table t2; +CREATE TABLE t3 select * from t1; +checksum table t3; +drop table t1,t2,t3; +--echo End of 5.1 tests |