MySQL Forums
Forum List  »  Merge Storage Engine

No spatial support in merge table
Posted by: Arild Berg
Date: April 12, 2007 07:20AM

Is it correct that merge tables (should not) support spatial attributes,
or is this a bug ?

To duplicate:

select version();
show variables like 'have%';
create table t1 (a1 int, pt POINT) engine=MyISAM;
create table t2 (a1 int, pt POINT) engine=MyISAM;
create table tMerge (a1 int, pt POINT) ENGINE=MERGE UNION=(t1,t2) INSERT_METHOD=FIRST;

Output.................................

mysql> select version();
+-------------------------+
| version() |
+-------------------------+
| 5.0.37-community-nt-log |
+-------------------------+
1 row in set (0.00 sec)

mysql> show variables like 'have%';
+-----------------------+----------+
| Variable_name | Value |
+-----------------------+----------+
| have_archive | YES |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | NO |
| have_csv | NO |
| have_dynamic_loading | YES |
| have_example_engine | NO |
| have_federated_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_merge_engine | YES |
| have_ndbcluster | NO |
| have_openssl | DISABLED |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
+-----------------------+----------+
19 rows in set (0.00 sec)

mysql> create table t1 (a1 int, pt POINT) engine=MyISAM;
Query OK, 0 rows affected (0.02 sec)

mysql> create table t2 (a1 int, pt POINT) engine=MyISAM;
Query OK, 0 rows affected (0.02 sec)

mysql> create table tMerge (a1 int, pt POINT) ENGINE=MERGE UNION=(t1,t2) INSERT_
METHOD=FIRST;
ERROR 1178 (42000): The storage engine for the table doesn't support GEOMETRY
mysql>

Options: ReplyQuote


Subject
Views
Written By
Posted
No spatial support in merge table
7918
April 12, 2007 07:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.