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

[3 Jun 2005 19:46] Francesco Riosa
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, "");
[3 Jun 2005 20:53] Miguel Solorzano
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...
[27 Jul 2005 16:47] Bugs System
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
[8 Aug 2005 12:49] Alexey Botchkov
Pushed into 4.1.14
[15 Aug 2005 16:55] Mike Hillyer
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>
[15 Aug 2005 17:53] Francesco Riosa
705_all_view_geometry.patch

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

[15 Aug 2005 17:55] Francesco Riosa
"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.