diff options
Diffstat (limited to 'mysql-test/suite/vcol/r/update_binlog.result')
-rw-r--r-- | mysql-test/suite/vcol/r/update_binlog.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/suite/vcol/r/update_binlog.result b/mysql-test/suite/vcol/r/update_binlog.result index 9a22005f062..977037535b4 100644 --- a/mysql-test/suite/vcol/r/update_binlog.result +++ b/mysql-test/suite/vcol/r/update_binlog.result @@ -10,13 +10,13 @@ select * from t1; a b c 2 3 4 drop table t1; -create table t1 (a int, c int as(a), p varchar(20) as(y), y char(20), index (p,c)); +create table t1 (a int, c int as(a), p varchar(20) as(rtrim(y)), y char(20), index (p,c)); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS (`a`) VIRTUAL, - `p` varchar(20) GENERATED ALWAYS AS (`y`) VIRTUAL, + `p` varchar(20) GENERATED ALWAYS AS (rtrim(`y`)) VIRTUAL, `y` char(20) DEFAULT NULL, KEY `p` (`p`,`c`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 @@ -190,13 +190,13 @@ select * from t1; a b c 2 3 4 drop table t1; -create table t1 (a int, c int as(a), p varchar(20) as(y), y char(20), index (p,c)); +create table t1 (a int, c int as(a), p varchar(20) as(rtrim(y)), y char(20), index (p,c)); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS (`a`) VIRTUAL, - `p` varchar(20) GENERATED ALWAYS AS (`y`) VIRTUAL, + `p` varchar(20) GENERATED ALWAYS AS (rtrim(`y`)) VIRTUAL, `y` char(20) DEFAULT NULL, KEY `p` (`p`,`c`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 |