summaryrefslogtreecommitdiff
path: root/mysql-test/t/innodb_bug47777.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/innodb_bug47777.test')
-rw-r--r--mysql-test/t/innodb_bug47777.test24
1 files changed, 0 insertions, 24 deletions
diff --git a/mysql-test/t/innodb_bug47777.test b/mysql-test/t/innodb_bug47777.test
deleted file mode 100644
index 8f2985b2cf0..00000000000
--- a/mysql-test/t/innodb_bug47777.test
+++ /dev/null
@@ -1,24 +0,0 @@
-# This is the test for bug 47777. GEOMETRY
-# data is treated as BLOB data in innodb.
-# Consequently, its key value generation/storing
-# should follow the process for the BLOB
-# datatype as well.
-
---source include/have_innodb.inc
-
-create table bug47777(c2 linestring not null, primary key (c2(1))) engine=innodb;
-
-insert into bug47777 values (geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)'));
-
-# Verify correct row get inserted.
-select count(*) from bug47777 where c2 =geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)');
-
-# Update table bug47777 should be successful.
-update bug47777 set c2=GeomFromText('POINT(1 1)');
-
-# Verify the row get updated successfully. The original
-# c2 value should be changed to GeomFromText('POINT(1 1)').
-select count(*) from bug47777 where c2 =geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)');
-select count(*) from bug47777 where c2 = GeomFromText('POINT(1 1)');
-
-drop table bug47777;