Bug #121368 Possible to store an empty value into a non-NULL GEOMETRY column

• Submitted: 24 Sep 8:43
• Modified: 24 Sep 11:00
• Reporter: Laurynas Biveinis (OCA)
• Status: Verified
• Category: MySQL Server: GIS
• Severity: S3 (Non-critical)
• Version: 8.4.11, 9.7.2, 26.7.0
• OS: Any
• CPU Architecture: Any

[24 Sep 8:43] Laurynas Biveinis

Description:
MTR:

CREATE TABLE t (g GEOMETRY NOT NULL);

# Correctly rejected:
--error ER_BAD_NULL_ERROR_NOT_IGNORED
INSERT IGNORE INTO t VALUES (@v := CAST(NULL AS DOUBLE));
--error ER_BAD_NULL_ERROR_NOT_IGNORED
INSERT IGNORE INTO t VALUES (@v := CAST(NULL AS SIGNED));
--error ER_BAD_NULL_ERROR_NOT_IGNORED
INSERT IGNORE INTO t VALUES (@v := CAST(NULL AS CHAR));
--error ER_BAD_NULL_ERROR_NOT_IGNORED
INSERT IGNORE INTO t VALUES (@v := NULL);
--error ER_BAD_NULL_ERROR_NOT_IGNORED
INSERT IGNORE INTO t VALUES (CAST(NULL AS DECIMAL));

# Goes through:
INSERT IGNORE INTO t VALUES (@v := CAST(NULL AS DECIMAL));

SELECT * FROM t;

DROP TABLE t;

How to repeat:
See above

[24 Sep 11:00] Chaithra Marsur Gopala Reddy

Hi Laurynas Biveinis,

Thank you for the test case. Verified as described.