Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 13.0, 13.1
-
None
Description
Virtual POINT column empty value
CREATE OR REPLACE TABLE t1 (a VARBINARY(128) NOT NULL, b POINT AS (a)); |
INSERT INTO t1 (a) VALUES ('test'); |
SELECT * FROM t1; |
+------+------+
|
| a | b |
|
+------+------+
|
| test | |
|
+------+------+
|
1 row in set, 1 warning (0.000 sec)
|
The value 'test' is obviously a wrong binary POINT value. The column 'b' return an empty string as a result, which is a wrong POINT value.
It should probably mark the column 'b' as nullable and return NULL.
Attachments
Issue Links
- relates to
-
MDEV-37100 No value resolution for non-deterministic defaults
-
- Confirmed
-