diff options
Diffstat (limited to 'mysql-test/suite/vcol/r/vcol_keys_innodb.result')
-rw-r--r-- | mysql-test/suite/vcol/r/vcol_keys_innodb.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/suite/vcol/r/vcol_keys_innodb.result b/mysql-test/suite/vcol/r/vcol_keys_innodb.result index 857dcb8423f..5070981f08f 100644 --- a/mysql-test/suite/vcol/r/vcol_keys_innodb.result +++ b/mysql-test/suite/vcol/r/vcol_keys_innodb.result @@ -19,7 +19,7 @@ t1 CREATE TABLE `t1` ( describe t1; Field Type Null Key Default Extra a int(11) YES NULL -b int(11) YES UNI NULL VIRTUAL +b int(11) YES UNI NULL PERSISTENT drop table t1; create table t1 (a int, b int as (a*2), unique key (b)); ERROR HY000: Key/Index cannot be defined on a non-stored computed column @@ -34,7 +34,7 @@ t1 CREATE TABLE `t1` ( describe t1; Field Type Null Key Default Extra a int(11) YES NULL -b int(11) YES UNI NULL VIRTUAL +b int(11) YES UNI NULL PERSISTENT drop table t1; create table t1 (a int, b int as (a*2)); alter table t1 add unique key (b); @@ -64,7 +64,7 @@ t1 CREATE TABLE `t1` ( describe t1; Field Type Null Key Default Extra a int(11) YES NULL -b int(11) YES MUL NULL VIRTUAL +b int(11) YES MUL NULL PERSISTENT drop table t1; create table t1 (a int, b int as (a*2) persistent, index (a,b)); show create table t1; @@ -77,7 +77,7 @@ t1 CREATE TABLE `t1` ( describe t1; Field Type Null Key Default Extra a int(11) YES MUL NULL -b int(11) YES NULL VIRTUAL +b int(11) YES NULL PERSISTENT drop table t1; create table t1 (a int, b int as (a*2)); alter table t1 add index (b); |