| 1 |
SET @save_sql_mode=@@global.sql_mode; |
| 2 |
SET sql_mode=ORACLE; |
| 3 |
SET GLOBAL sql_mode='ORACLE'; |
| 4 |
|
| 5 |
|
| 6 |
--echo # MDEV-27769 Assertion failed in Field::ptr_in_record upon UPDATE |
| 7 |
CREATE TABLE t (s geometry, t text) engine innodb; |
| 8 |
INSERT IGNORE INTO t () VALUES (); |
| 9 |
--error ER_CANT_CREATE_GEOMETRY_OBJECT |
| 10 |
UPDATE IGNORE t SET t= '', s = 0; |
| 11 |
--error ER_CANT_CREATE_GEOMETRY_OBJECT |
| 12 |
UPDATE IGNORE t SET t= '', s = 0; |
| 13 |
|
| 14 |
ALTER TABLE t force; |
| 15 |
|
| 16 |
DROP TABLE t; |
| 17 |
|
| 18 |
# Test cleanup |
| 19 |
SET GLOBAL sql_mode=@save_sql_mode; |