diff options
author | Sergei Golubchik <serg@mariadb.org> | 2016-11-08 14:57:43 +0100 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2016-12-12 20:35:49 +0100 |
commit | d1f3763323ff597e702f36e75633392dd52b60c1 (patch) | |
tree | a7375eea628c0f98c7586239bfbed0c18e733b5e /mysql-test/suite/vcol/r/vcol_keys_myisam.result | |
parent | 6b0f4c24ab9ac078d09d93f6f4ed7c46213f1a08 (diff) | |
download | mariadb-git-d1f3763323ff597e702f36e75633392dd52b60c1.tar.gz |
bugfix: non-deterministic vcols in indexes
Diffstat (limited to 'mysql-test/suite/vcol/r/vcol_keys_myisam.result')
-rw-r--r-- | mysql-test/suite/vcol/r/vcol_keys_myisam.result | 20 |
1 files changed, 18 insertions, 2 deletions
diff --git a/mysql-test/suite/vcol/r/vcol_keys_myisam.result b/mysql-test/suite/vcol/r/vcol_keys_myisam.result index 2a551956173..17f6fba7e89 100644 --- a/mysql-test/suite/vcol/r/vcol_keys_myisam.result +++ b/mysql-test/suite/vcol/r/vcol_keys_myisam.result @@ -260,5 +260,21 @@ drop table t1; # on virtual columns can be found in: # - vcol_ins_upd.inc # - vcol_select.inc -# -# TODO: CHECK +create table t1 (a int, b timestamp as (now()), key (b)); +ERROR HY000: Function or expression 'current_timestamp()' cannot be used in the GENERATED ALWAYS AS clause of `b` +create table t1 (a int, b timestamp as (now())); +alter table t1 add index (b); +ERROR HY000: Function or expression 'current_timestamp()' cannot be used in the GENERATED ALWAYS AS clause of `b` +drop table t1; +create table t1 (a int, b varchar(100) as (user()), key (b)); +ERROR HY000: Function or expression 'user()' cannot be used in the GENERATED ALWAYS AS clause of `b` +create table t1 (a int, b varchar(100) as (user())); +alter table t1 add index (b); +ERROR HY000: Function or expression 'user()' cannot be used in the GENERATED ALWAYS AS clause of `b` +drop table t1; +create table t1 (a int, b double as (rand()), key (b)); +ERROR HY000: Function or expression 'rand()' cannot be used in the GENERATED ALWAYS AS clause of `b` +create table t1 (a int, b double as (rand())); +alter table t1 add index (b); +ERROR HY000: Function or expression 'rand()' cannot be used in the GENERATED ALWAYS AS clause of `b` +drop table t1; |