MySQL Bugs: #121391: UPDATE IGNORE set geometry DEFAULT fails after DROP DEFAULT where INSERT IGNORE stores NULL

Bug #121391	UPDATE IGNORE set geometry DEFAULT fails after DROP DEFAULT where INSERT IGNORE stores NULL
Submitted:	29 Sep 7:50	Modified:	30 Sep 6:28
Reporter:	Laurynas Biveinis (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: GIS	Severity:	S3 (Non-critical)
Version:	8.0.46, 8.4.11, 9.7.2, 26.07	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
MTR:

CREATE TABLE t1 (id INT PRIMARY KEY, g GEOMETRY);
INSERT INTO t1 VALUES (1, ST_GeomFromText('POINT(1 1)'));
ALTER TABLE t1 ALTER COLUMN g DROP DEFAULT;

INSERT IGNORE INTO t1 VALUES (2, DEFAULT);

Warnings:
Warning	1364	Field 'g' doesn't have a default value

UPDATE IGNORE t1 SET g = DEFAULT WHERE id = 1;

ERROR 1416 (22003): Cannot get geometry object from data you send to the GEOMETRY field

How to repeat:
See above

Hi Laurynas Biveinis,

Thank you for the test case. Verified as described.