[MDEV-3843] Trying to UPDATE a Virtual Column does not produce an error Created: 2012-11-09  Updated: 2012-11-09  Resolved: 2012-11-09

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Federico Razzoli Assignee: Elena Stepanova
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

I created a table with a virtual column, tried to update the virtual column, and no error was issued.

MariaDB [test]> DROP VIEW IF EXISTS `t1`;
Query OK, 0 rows affected, 1 warning (0.01 sec)

MariaDB [test]> DROP TABLE IF EXISTS `t1`;
Query OK, 0 rows affected (0.11 sec)

MariaDB [test]> CREATE TABLE `t1` (
-> `a` INTEGER UNSIGNED NULL DEFAULT NULL,
-> `b` INTEGER UNSIGNED GENERATED ALWAYS AS (`a` + 100) VIRTUAL
-> )
-> ENGINE = Aria
-> ROW_FORMAT = PAGE;
Query OK, 0 rows affected (0.21 sec)

MariaDB [test]> UPDATE `t1` SET `b` = 1;
Query OK, 0 rows affected (0.01 sec)
Rows matched: 0 Changed: 0 Warnings: 0



 Comments   
Comment by Elena Stepanova [ 2012-11-09 ]

Hi Federico,

You are not getting an error because your UPDATE does not really update anything, the table is empty.
If you had had any rows that are supposed to be updated, you'd have gotten either a warning or an error, depending on the server version and sql_mode.

Comment by Federico Razzoli [ 2012-11-09 ]

Yes, I confirm that I get a warning if the table is not empty.

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