| 1 |
--source include/have_innodb.inc |
| 2 |
|
| 3 |
CREATE TABLE t ( |
| 4 |
id INT AUTO_INCREMENT, |
| 5 |
c BINARY(226) DEFAULT '', |
| 6 |
s POINT NOT NULL, |
| 7 |
PRIMARY KEY(id,c) |
| 8 |
) ENGINE=InnoDB; |
| 9 |
INSERT INTO t (s) VALUES |
| 10 |
(POINTFromText('POINT(0.78 0.72)')),(POINTFromText('POINT(0.44 0.21)')), |
| 11 |
(POINTFromText('POINT(0.93 0.56)')),(POINTFromText('POINT(0.57 0.21)')), |
| 12 |
(POINTFromText('POINT(0.12 0.65)')),(POINTFromText('POINT(0.20 0.96)')), |
| 13 |
(POINTFromText('POINT(0.99 0.71)')),(POINTFromText('POINT(0.27 0.23)')), |
| 14 |
(POINTFromText('POINT(0.68 0.14)')),(POINTFromText('POINT(0.20 0.05)')), |
| 15 |
(POINTFromText('POINT(0.47 0.57)')),(POINTFromText('POINT(0.89 0.79)')), |
| 16 |
(POINTFromText('POINT(0.09 0.57)')),(POINTFromText('POINT(0.58 0.52)')), |
| 17 |
(POINTFromText('POINT(0.73 0.32)')),(POINTFromText('POINT(0.87 0.35)')), |
| 18 |
(POINTFromText('POINT(0.60 0.12)')),(POINTFromText('POINT(0.14 0.17)')), |
| 19 |
(POINTFromText('POINT(0.76 0.29)')),(POINTFromText('POINT(0.60 0.35)')), |
| 20 |
(POINTFromText('POINT(0.48 0.69)')),(POINTFromText('POINT(0.79 0.45)')), |
| 21 |
(POINTFromText('POINT(0.85 0.11)')),(POINTFromText('POINT(0.59 0.99)')), |
| 22 |
(POINTFromText('POINT(0.95 0.18)')),(POINTFromText('POINT(0.78 0.49)')), |
| 23 |
(POINTFromText('POINT(0.11 0.22)')),(POINTFromText('POINT(0.26 0.85)')), |
| 24 |
(POINTFromText('POINT(0.28 0.10)')),(POINTFromText('POINT(0.45 0.25)')), |
| 25 |
(POINTFromText('POINT(0.70 0.40)')),(POINTFromText('POINT(0.65 0.86)')), |
| 26 |
(POINTFromText('POINT(0.69 0.98)')),(POINTFromText('POINT(0.56 0.11)')), |
| 27 |
(POINTFromText('POINT(0.94 0.59)')),(POINTFromText('POINT(0.19 0.94)')), |
| 28 |
(POINTFromText('POINT(0.82 0.85)')),(POINTFromText('POINT(0.74 0.07)')), |
| 29 |
(POINTFromText('POINT(0.33 0.48)')),(POINTFromText('POINT(0.37 0.37)')), |
| 30 |
(POINTFromText('POINT(0.40 0.08)')),(POINTFromText('POINT(0.45 0.74)')), |
| 31 |
(POINTFromText('POINT(0.57 0.07)')),(POINTFromText('POINT(0.36 0.11)')), |
| 32 |
(POINTFromText('POINT(0.94 0.60)')),(POINTFromText('POINT(0.75 0.76)')), |
| 33 |
(POINTFromText('POINT(0.92 0.56)')),(POINTFromText('POINT(0.88 0.52)')), |
| 34 |
(POINTFromText('POINT(0.49 0.24)')),(POINTFromText('POINT(0.96 0.08)')), |
| 35 |
(POINTFromText('POINT(0.93 0.99)')),(POINTFromText('POINT(0.88 0.31)')), |
| 36 |
(POINTFromText('POINT(0.93 0.78)')),(POINTFromText('POINT(0.62 0.50)')), |
| 37 |
(POINTFromText('POINT(0.54 0.53)')),(POINTFromText('POINT(0.66 0.83)')), |
| 38 |
(POINTFromText('POINT(0.21 0.87)')),(POINTFromText('POINT(0.42 0.28)')), |
| 39 |
(POINTFromText('POINT(0.80 0.84)')),(POINTFromText('POINT(0.39 0.68)')), |
| 40 |
(POINTFromText('POINT(0.05 0.24)')),(POINTFromText('POINT(0.05 0.58)')); |
| 41 |
ALTER TABLE t ADD SPATIAL INDEX(s); |
| 42 |
OPTIMIZE TABLE t; |
| 43 |
# Cleanup |
| 44 |
DROP TABLE t; |