[MDEV-10964] Support for NULL/NOT NULL syntax for virtual columns Created: 2016-10-06  Updated: 2022-04-25

Status: Open
Project: MariaDB Server
Component/s: Virtual Columns
Fix Version/s: None

Type: Task Priority: Major
Reporter: Federico Razzoli Assignee: Unassigned
Resolution: Unresolved Votes: 8
Labels: Compatibility

Issue Links:
Relates
relates to MDEV-7687 Can't create SPATIAL index on top of ... Confirmed

 Description   

Please support NULL/NOT NULL syntax and semantics, for compatibility with MySQL if nothing else.



 Comments   
Comment by Sergei Golubchik [ 2017-01-09 ]

Semantically it should be equivalent to creating a constraint, like

MySQL

  col INT GENERATED ALWAYS AS (a+1) NOT NULL

MariaDB

  col INT GENERATED ALWAYS AS (a+1),
  CONSTRAINT col_not_null CHECK (col IS NOT NULL)

Generated at Thu Feb 08 07:46:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.