diff options
| author | unknown <aivanov/alexi@mysql.com/mysqld.localdomain> | 2006-09-18 03:21:00 +0400 |
|---|---|---|
| committer | unknown <aivanov/alexi@mysql.com/mysqld.localdomain> | 2006-09-18 03:21:00 +0400 |
| commit | 447f2333fe235fbac807a4f9699ec585642092cd (patch) | |
| tree | bdd85b273f781db4a57539a4268a5c17d4441cad /mysql-test/t/rpl_view.test | |
| parent | 370f8ec15f738e50c3d1419cc945af2c1a9f6fe5 (diff) | |
| download | mariadb-git-447f2333fe235fbac807a4f9699ec585642092cd.tar.gz | |
BUG#19419: VIEW: View that the column name is different
by master and slave is made.
mysql-test/r/rpl_view.result:
BUG#19419: VIEW: View that the column name is different
by master and slave is made.
Fixed result for the added test case.
mysql-test/t/rpl_view.test:
BUG#19419: VIEW: View that the column name is different
by master and slave is made.
Added test case.
sql/sql_parse.cc:
BUG#19419: VIEW: View that the column name is different
by master and slave is made.
Fixed: Add column_list to to the view creation statement
which is written to binlog.
Diffstat (limited to 'mysql-test/t/rpl_view.test')
| -rw-r--r-- | mysql-test/t/rpl_view.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_view.test b/mysql-test/t/rpl_view.test index d0990b4fbee..52db75aaf69 100644 --- a/mysql-test/t/rpl_view.test +++ b/mysql-test/t/rpl_view.test @@ -129,3 +129,23 @@ DROP TABLE t1; --sync_with_master --connection master +# +# BUG#19419: "VIEW: View that the column name is different +# by master and slave is made". +# +connection master; +create table t1(a int, b int); +insert into t1 values (1, 1), (1, 2), (1, 3); +create view v1(a, b) as select a, sum(b) from t1 group by a; + +sync_slave_with_master; +explain v1; +show create table v1; +select * from v1; + +connection master; +drop table t1; +drop view v1; + +sync_slave_with_master; + |