summaryrefslogtreecommitdiff
path: root/mysql-test/suite/vcol/r
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2016-11-21 16:16:52 +0100
committerSergei Golubchik <serg@mariadb.org>2016-12-12 20:27:32 +0100
commit8b6c0542db908bba548bdb217d78bae25d4522ca (patch)
tree04929cda5034711c67cd3194d3b368c0e4197820 /mysql-test/suite/vcol/r
parent10089493bdc3f7b782d01fa8d2f3221449965458 (diff)
downloadmariadb-git-8b6c0542db908bba548bdb217d78bae25d4522ca.tar.gz
bugfix: stored column depends on virtual depends on updated
TABLE::mark_virtual_col() was polluting table->vcol_set and that confused the following mark_virtual_col()
Diffstat (limited to 'mysql-test/suite/vcol/r')
-rw-r--r--mysql-test/suite/vcol/r/update.result10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/suite/vcol/r/update.result b/mysql-test/suite/vcol/r/update.result
new file mode 100644
index 00000000000..d56f85c1f1c
--- /dev/null
+++ b/mysql-test/suite/vcol/r/update.result
@@ -0,0 +1,10 @@
+create table t1 (a int, b int as (a+1), c int as (b+1) stored);
+insert t1 set a=1;
+select * from t1;
+a b c
+1 2 3
+update t1 set a=2;
+select * from t1;
+a b c
+2 3 4
+drop table t1;