Bug #22682 Tests fails in a --without-geometry build

• Submitted: 25 Sep 2006 20:53
• Modified: 21 Jun 2010 1:01
• Reporter: Marc ALFF
• Status: Closed
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.1.12-BK
• OS: Any
• Assigned to: Alexey Botchkov
• CPU Architecture: Any

[25 Sep 2006 20:53] Marc ALFF

Description:
When performing a build --without-geometry,
the following 2 tests fails :

1) innodb
create table t1 (g geometry not null, spatial gk(g)) engine=innodb;
ERROR HY000: The 'Spatial extentions' feature is disabled; you need MySQL built with 'HAVE_SPATIAL' to have it working

which is not the expected error.

2) view
create table t1 (f1 tinyint(1), f2 char(1), f3 varchar(1), f4 geometry, f5 datetime);
Same error, where none is expected

Found in 5.1

How to repeat:
See above

Suggested fix:
Move the offending tests to :
- innodb_gis
- view_gis (new test, which should have -- source include/have_geometry.inc)

so that both builds (--with-geometry, --without-geometry) can pass

[26 Sep 2006 19:30] Valeriy Kravchuk

Thank you for a problem report. Verified just as described with 5.1.12-BK on Linux.

[14 Jan 2007 13:35] 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/commits/18098

ChangeSet@1.2391, 2007-01-14 17:38:44+04:00, [e-mail] +8 -0
  bug #22682 Tests fails --without-geometry
  geometry-dependent parts moved to tests working --with-geometry only

[24 Jan 2007 10:46] 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/commits/18693

ChangeSet@1.2394, 2007-01-24 14:49:36+04:00, [e-mail] +9 -0
  bug #22682 Test fails --without-geometry
  geometry dependent parts moved to proper .test files

[28 Jan 2007 2:31] Igor Babaev

The fix has been pushed into 5.1.16-beta main tree.

[28 Jan 2007 2:33] Paul DuBois

Test suite change only. No changelog entry needed.

[5 May 2010 15:18] Bugs System

Pushed into 5.1.47 (revid:[e-mail]-20100505145753-ivlt4hclbrjy8eye) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[6 May 2010 2:26] Paul DuBois

Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug. Re-closing.

[28 May 2010 5:57] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100524190136-egaq7e8zgkwb9aqi) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (pib:16)

[28 May 2010 6:26] Bugs System

Pushed into 6.0.14-alpha (revid:[e-mail]-20100524190941-nuudpx60if25wsvx) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[28 May 2010 6:54] Bugs System

Pushed into 5.5.5-m3 (revid:[e-mail]-20100524185725-c8k5q7v60i5nix3t) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[17 Jun 2010 12:00] Bugs System

Pushed into 5.1.47-ndb-7.0.16 (revid:[e-mail]-20100617114014-bva0dy24yyd67697) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[17 Jun 2010 12:40] Bugs System

Pushed into 5.1.47-ndb-6.2.19 (revid:[e-mail]-20100617115448-idrbic6gbki37h1c) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[17 Jun 2010 13:26] Bugs System

Pushed into 5.1.47-ndb-6.3.35 (revid:[e-mail]-20100617114611-61aqbb52j752y116) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)