[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`; MariaDB [test]> DROP TABLE IF EXISTS `t1`; MariaDB [test]> CREATE TABLE `t1` ( MariaDB [test]> UPDATE `t1` SET `b` = 1; |
| 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. |
| Comment by Federico Razzoli [ 2012-11-09 ] |
|
Yes, I confirm that I get a warning if the table is not empty. |