Debian Codegraph @

mysql-test/suite/compat/oracle/t/update.test

raw
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;