summaryrefslogtreecommitdiff
path: root/mysql-test/suite/gcol/r/gcol_blocked_sql_funcs_myisam.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/gcol/r/gcol_blocked_sql_funcs_myisam.result')
-rw-r--r--mysql-test/suite/gcol/r/gcol_blocked_sql_funcs_myisam.result12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/suite/gcol/r/gcol_blocked_sql_funcs_myisam.result b/mysql-test/suite/gcol/r/gcol_blocked_sql_funcs_myisam.result
index 99921c658b3..ac8bd0a3322 100644
--- a/mysql-test/suite/gcol/r/gcol_blocked_sql_funcs_myisam.result
+++ b/mysql-test/suite/gcol/r/gcol_blocked_sql_funcs_myisam.result
@@ -175,6 +175,18 @@ drop table t1;
#
# End of 10.3 tests
#
+#
+# MDEV-29029 Index corruption and/or assertion failure upon using RANDOM_BYTES for indexed virtual column
+#
+create table t1 (a int);
+alter table t1 add column b binary(32) generated always as (random_bytes(a));
+ERROR HY000: Function or expression 'random_bytes()' cannot be used in the GENERATED ALWAYS AS clause of `b`
+alter table t1 add column b binary(32) default (random_bytes(a));
+drop table t1;
+#
+#
+# End of 10.10 tests
+#
DROP VIEW IF EXISTS v1,v2;
DROP TABLE IF EXISTS t1,t2,t3;
DROP PROCEDURE IF EXISTS p1;