diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2022-08-03 07:12:27 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2022-08-03 07:12:27 +0200 |
| commit | af143474d8925cdbcfc0795a2bc274cbeaad8889 (patch) | |
| tree | 790022e64c90ce37310d20f1de25af35b0f722c9 /mysql-test/suite/vcol | |
| parent | 7b500f04fb0baf56b02583f82982508203e58d38 (diff) | |
| parent | 48e35b8cf61cbedb515787762708afe7bd75386b (diff) | |
| download | mariadb-git-af143474d8925cdbcfc0795a2bc274cbeaad8889.tar.gz | |
Merge branch '10.4' into 10.5
Diffstat (limited to 'mysql-test/suite/vcol')
| -rw-r--r-- | mysql-test/suite/vcol/r/vcol_misc.result | 16 | ||||
| -rw-r--r-- | mysql-test/suite/vcol/t/vcol_misc.test | 14 |
2 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/suite/vcol/r/vcol_misc.result b/mysql-test/suite/vcol/r/vcol_misc.result index 4ec57413a15..a09939c8cc2 100644 --- a/mysql-test/suite/vcol/r/vcol_misc.result +++ b/mysql-test/suite/vcol/r/vcol_misc.result @@ -550,3 +550,19 @@ drop table t1; # # End of 10.2 tests # +# +# RAND is session func +# +create table t1 (a int, b float default rand(1)); +insert into t1 (a) values (1); +insert into t1 (a) values (2); +insert into t1 (a) values (3); +select * from t1; +a b +1 0.405404 +2 0.405404 +3 0.405404 +drop table t1; +# +# End of 10.3 tests +# diff --git a/mysql-test/suite/vcol/t/vcol_misc.test b/mysql-test/suite/vcol/t/vcol_misc.test index 3062e5a685d..c3f36d93316 100644 --- a/mysql-test/suite/vcol/t/vcol_misc.test +++ b/mysql-test/suite/vcol/t/vcol_misc.test @@ -514,3 +514,17 @@ drop table t1; --echo # --echo # End of 10.2 tests --echo # + +--echo # +--echo # RAND is session func +--echo # +create table t1 (a int, b float default rand(1)); +insert into t1 (a) values (1); +insert into t1 (a) values (2); +insert into t1 (a) values (3); +select * from t1; +drop table t1; + +--echo # +--echo # End of 10.3 tests +--echo # |