[MDEV-14702] Not helpful error message upon ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN Created: 2017-12-18  Updated: 2020-12-21

Status: Open
Project: MariaDB Server
Component/s: Virtual Columns
Affects Version/s: 5.5, 10.0, 10.1, 10.2, 10.3, 10.4
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 1
Labels: None

Issue Links:
Relates
relates to MDEV-15956 Strange ER_UNSUPPORTED_ACTION_ON_GENE... Closed

 Description    

MariaDB [test]> CREATE TABLE t1 (i INT, f INT AS (i) VIRTUAL);
 
Query OK, 0 rows affected (0.44 sec)
 
 
 
MariaDB [test]> ALTER TABLE t1 MODIFY COLUMN f INT;
 
ERROR 1907 (HY000): This is not yet supported for generated columns

"This" is really vague.

MySQL is somewhat better at it:

3106: 'Changing the STORED status' is not supported for generated columns



 Comments   
Comment by Elena Stepanova [ 2018-12-24 ]

Raising in hope something can be done about it at least in 10.4.

Comment by Riccardo Paolo Bestetti [ 2020-12-21 ]

+1. (Looks like the bug has a tendency to get noticed near Christmas.

Generated at Thu Feb 08 08:15:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.