| 1 |
SET @save_sql_mode=@@global.sql_mode; |
| 2 |
SET sql_mode=ORACLE; |
| 3 |
SET GLOBAL sql_mode='ORACLE'; |
| 4 |
# MDEV-27769 Assertion failed in Field::ptr_in_record upon UPDATE |
| 5 |
CREATE TABLE t (s geometry, t text) engine innodb; |
| 6 |
Warnings: |
| 7 |
Warning 1286 Unknown storage engine 'innodb' |
| 8 |
Warning 1266 Using storage engine MyISAM for table 't' |
| 9 |
INSERT IGNORE INTO t () VALUES (); |
| 10 |
UPDATE IGNORE t SET t= '', s = 0; |
| 11 |
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field |
| 12 |
UPDATE IGNORE t SET t= '', s = 0; |
| 13 |
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field |
| 14 |
ALTER TABLE t force; |
| 15 |
DROP TABLE t; |
| 16 |
SET GLOBAL sql_mode=@save_sql_mode; |