You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
49 lines
1.0 KiB
49 lines
1.0 KiB
--source include/force_myisam_default.inc
|
|
--source include/have_myisam.inc
|
|
|
|
--echo #
|
|
--echo # Bug #21789000 SPATIAL INDEX CAUSES INCORRECT CARDINALITY FOR ALL
|
|
--echo # NON-PRIMARY INDEXES
|
|
--echo #
|
|
|
|
# With spatial index
|
|
CREATE TABLE t1 (
|
|
id INT NOT NULL AUTO_INCREMENT,
|
|
a VARCHAR(10) NOT NULL,
|
|
b VARCHAR(5) NOT NULL,
|
|
c GEOMETRY NOT NULL SRID 0,
|
|
PRIMARY KEY (id),
|
|
SPATIAL INDEX c (c),
|
|
INDEX a (a),
|
|
INDEX b (b)
|
|
) ENGINE=MyISAM;
|
|
|
|
# Without spatial index
|
|
CREATE TABLE t2 (
|
|
id INT NOT NULL AUTO_INCREMENT,
|
|
a VARCHAR(10) NOT NULL,
|
|
b VARCHAR(5) NOT NULL,
|
|
c GEOMETRY NOT NULL,
|
|
PRIMARY KEY (id),
|
|
INDEX a (a),
|
|
INDEX b (b)
|
|
) ENGINE=MyISAM;
|
|
|
|
INSERT INTO t1(a, b, c) VALUES
|
|
('a1', 'b1', POINT(0, 0)),
|
|
('a2', 'b2', POINT(0, 0)),
|
|
('a3', 'b3', POINT(0, 0)),
|
|
('a4', 'b4', POINT(0, 0)),
|
|
('a5', 'b5', POINT(0, 0)),
|
|
('a6', 'b6', POINT(0, 0)),
|
|
('a7', 'b7', POINT(0, 0));
|
|
|
|
INSERT INTO t2 SELECT * FROM t1;
|
|
|
|
ANALYZE TABLE t1;
|
|
SHOW INDEXES FROM t1;
|
|
|
|
ANALYZE TABLE t2;
|
|
SHOW INDEXES FROM t2;
|
|
|
|
DROP TABLE t1, t2;
|
|
|