diff options
author | unknown <guilhem@gbichot4.local> | 2008-04-02 18:37:01 +0200 |
---|---|---|
committer | unknown <guilhem@gbichot4.local> | 2008-04-02 18:37:01 +0200 |
commit | 50808b211527a165386b771c6f13d3ca7ba29f1a (patch) | |
tree | 12bc0d2daa49555ab76920346559c3a50e259bec /mysql-test/r/myisam.result | |
parent | 3651e3285d11c42a77e332009155b96132e5ba6e (diff) | |
download | mariadb-git-50808b211527a165386b771c6f13d3ca7ba29f1a.tar.gz |
Fix for BUG#35570 "CHECKSUM TABLE unreliable if LINESTRING field (same content / differen checksum)"
This will be back-ported to 5.x trees but the work for R-tree logging critically needs this patch in Maria now.
mysql-test/r/myisam.result:
checksums are identical; without the code fix they were all different
mysql-test/t/myisam.test:
test that same tables give same checksums
sql/sql_table.cc:
Type GEOMETRY is implemented on top of type BLOB, so, just like for BLOB, its 'field' contains pointers
which it does not make sense to include in the checksum; it rather has to be converted to a string and
then we can compute the checksum.
Diffstat (limited to 'mysql-test/r/myisam.result')
-rw-r--r-- | mysql-test/r/myisam.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index 3a0cbd3c32d..4fbe134156f 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -2033,4 +2033,19 @@ t1 CREATE TABLE `t1` ( `c` char(1) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 TRANSACTIONAL=1 drop table t1; +CREATE TABLE t1 (line LINESTRING NOT NULL) engine=myisam; +INSERT INTO t1 VALUES (GeomFromText("POINT(0 0)")); +checksum table t1; +Table Checksum +test.t1 326284887 +CREATE TABLE t2 (line LINESTRING NOT NULL) engine=myisam; +INSERT INTO t2 VALUES (GeomFromText("POINT(0 0)")); +checksum table t2; +Table Checksum +test.t2 326284887 +CREATE TABLE t3 select * from t1; +checksum table t3; +Table Checksum +test.t3 326284887 +drop table t1,t2,t3; End of 5.1 tests |