| 1 |
CREATE TABLE tab(c1 int NOT NULL PRIMARY KEY,c2 POINT NOT NULL SRID 0); |
| 2 |
CREATE SPATIAL INDEX idx1 on tab(c2); |
| 3 |
INSERT INTO tab(c1,c2) VALUES(1,ST_GeomFromText('POINT(10 10)')); |
| 4 |
|
| 5 |
# On connection 1 |
| 6 |
set transaction isolation level serializable ; |
| 7 |
START TRANSACTION; |
| 8 |
SELECT ST_AsText(c2) FROM tab WHERE MBRWithin(c2, ST_GeomFromText('POLYGON((5 5, 15 5, 15 15, 5 15, 5 5))')); |
| 9 |
ST_AsText(c2) |
| 10 |
POINT(10 10) |
| 11 |
|
| 12 |
# On connection 2 |
| 13 |
start transaction; |
| 14 |
INSERT INTO tab(c1,c2) VALUES(7, ST_GeomFromText('POINT(11 11)'));; |
| 15 |
|
| 16 |
# On connection 3 |
| 17 |
include/start_transaction_high_prio.inc |
| 18 |
START TRANSACTION /* HIGH PRIORITY */; |
| 19 |
INSERT INTO tab(c1,c2) VALUES(8, ST_GeomFromText('POINT(10 10)')); |
| 20 |
COMMIT; |
| 21 |
|
| 22 |
# On connection 1 |
| 23 |
COMMIT; |
| 24 |
ERROR HY000: Got error 149 - 'Lock deadlock; Retry transaction' during COMMIT |
| 25 |
include/assert.inc ['There is a 8 in tab'] |
| 26 |
SELECT c1 FROM tab; |
| 27 |
c1 |
| 28 |
1 |
| 29 |
8 |
| 30 |
DROP TABLE tab; |