diff options
Diffstat (limited to 'mysql-test/suite/vcol/r/vcol_supported_sql_funcs_innodb.result')
-rw-r--r-- | mysql-test/suite/vcol/r/vcol_supported_sql_funcs_innodb.result | 49 |
1 files changed, 2 insertions, 47 deletions
diff --git a/mysql-test/suite/vcol/r/vcol_supported_sql_funcs_innodb.result b/mysql-test/suite/vcol/r/vcol_supported_sql_funcs_innodb.result index 899a19c68f0..f9a7e2cc65c 100644 --- a/mysql-test/suite/vcol/r/vcol_supported_sql_funcs_innodb.result +++ b/mysql-test/suite/vcol/r/vcol_supported_sql_funcs_innodb.result @@ -2539,7 +2539,7 @@ show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` datetime DEFAULT NULL, - `b` timestamp AS (timestamp(a)) VIRTUAL NULL ON UPDATE CURRENT_TIMESTAMP + `b` timestamp AS (timestamp(a)) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 insert into t1 values ('2008-12-31',default); select * from t1; @@ -2554,7 +2554,7 @@ show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` datetime DEFAULT NULL, - `b` timestamp AS (timestampadd(minute,1,a)) VIRTUAL NULL ON UPDATE CURRENT_TIMESTAMP + `b` timestamp AS (timestampadd(minute,1,a)) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 insert into t1 values ('2003-01-02',default); select * from t1; @@ -2756,51 +2756,6 @@ a b 5 2 drop table t1; set sql_warnings = 0; -# CHARSET() -set sql_warnings = 1; -create table t1 (a varchar(1024), b varchar(1024) as (charset(a))); -show create table t1; -Table Create Table -t1 CREATE TABLE `t1` ( - `a` varchar(1024) DEFAULT NULL, - `b` varchar(1024) AS (charset(a)) VIRTUAL -) ENGINE=InnoDB DEFAULT CHARSET=latin1 -insert into t1 values ('abc',default); -select * from t1; -a b -abc latin1 -drop table t1; -set sql_warnings = 0; -# COERCIBILITY() -set sql_warnings = 1; -create table t1 (a varchar(1024), b int as (coercibility(a))); -show create table t1; -Table Create Table -t1 CREATE TABLE `t1` ( - `a` varchar(1024) DEFAULT NULL, - `b` int(11) AS (coercibility(a)) VIRTUAL -) ENGINE=InnoDB DEFAULT CHARSET=latin1 -insert into t1 values ('abc',default); -select * from t1; -a b -abc 2 -drop table t1; -set sql_warnings = 0; -# COLLATION() -set sql_warnings = 1; -create table t1 (a varchar(1024), b varchar(1024) as (collation(a))); -show create table t1; -Table Create Table -t1 CREATE TABLE `t1` ( - `a` varchar(1024) DEFAULT NULL, - `b` varchar(1024) AS (collation(a)) VIRTUAL -) ENGINE=InnoDB DEFAULT CHARSET=latin1 -insert into t1 values ('abc',default); -select * from t1; -a b -abc latin1_swedish_ci -drop table t1; -set sql_warnings = 0; # COMPRESS(), UNCOMPRESS() set sql_warnings = 1; create table t1 (a varchar(1024), b varchar(1024) as (uncompress(compress(a)))); |