MySQL Bugs: #11083: myisam.test fail w/ --without-geometry

Bug #11083	myisam.test fail w/ --without-geometry
Submitted:	3 Jun 2005 19:46	Modified:	15 Aug 2005 16:55
Reporter:	Francesco Riosa	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	>= 4.1	OS:
Assigned to:	Alexey Botchkov	CPU Architecture:	Any

Description:
When compiled without spatial extensions the statement

CREATE TABLE t1 (`a` int(11) NOT NULL default '0', `b` int(11) NOT NULL default '0', UNIQUE KEY `a` USING RTREE (`a`,`b`)) ENGINE=MyISAM;

fail with error 1289 instead of usual 1235 .

In "Suggested fix:" section there is a patch to accept both errors.

How to repeat:
./configure --without-geometry && make && make test

Suggested fix:
--- mysql.orig/mysql-test/t/myisam.test 2005-05-26 16:55:48.000000000 +0200
+++ mysql.fix/mysql-test/t/myisam.test  2005-06-03 21:26:28.000000000 +0200
@@ -479,7 +479,7 @@
 #
 # Test RTREE index
 #
---error 1235
+--error 1235,1289
 CREATE TABLE t1 (`a` int(11) NOT NULL default '0', `b` int(11) NOT NULL default '0', UNIQUE KEY `a` USING RTREE (`a`,`b`)) ENGINE=MyISAM;
 # INSERT INTO t1 VALUES (1,1),(1,1);
 # DELETE FROM rt WHERE a<1;
--- mysql.orig/mysql-test/r/myisam.result   2005-05-26 16:55:48.000000000 +0200
+++ mysql.fix/mysql-test/r/myisam.result    2005-06-03 21:27:20.000000000 +0200
@@ -506,7 +506,7 @@
 1  SIMPLE  t2  index   NULL    PRIMARY 4   NULL    2   Using index; Distinct
 drop table t1,t2;
 CREATE TABLE t1 (`a` int(11) NOT NULL default '0', `b` int(11) NOT NULL default '0', UNIQUE KEY `a` USING RTREE (`a`,`b`)) ENGINE=MyISAM;
-ERROR 42000: This version of MySQL doesn't yet support 'RTREE INDEX'
+Got one of the listed errors
 create table t1 (a int, b varchar(200), c text not null) checksum=1;
 create table t2 (a int, b varchar(200), c text not null) checksum=0;
 insert t1 values (1, "aaa", "bbb"), (NULL, "", "ccccc"), (0, NULL, "");

Thank you for the bug report i was able to repeat:

myisam                         [ fail ]

Errors are (from /home/miguel/dbs/mysql-4.1/mysql-test/var/log/mysqltest-time) :
/home/miguel/dbs/mysql-4.1/client/.libs/mysqltest: At line 480: query 'CREATE TABLE t1 (`a` int(11) NOT NULL default '0', `b` int(11) NOT NULL default '0', UNIQUE KEY `a` USING RTREE (`a`,`b`)) ENGINE=MyISAM' failed with wrong errno 1289 instead of 1235...

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/27649

Pushed into 4.1.14

Documented in 4.1.14 changelog:

<listitem><para><literal>myisam.test</literal> failed when server compiled using <option>--without-geometry</option> option. (Bug #11083)</para></listitem>

705_all_view_geometry.patch

Attachment: 705_all_view_geometry.patch (application/octet-stream, text), 2.48 KiB.

"view" test of MySQL-5.0.11-beta fail if compiled --without-geometry .

The provided patch move a slice of "view.test" into "gis-view.test" to workaround the problem.