#At file:///localhome/jl208045/mysql/bzrroot/mysql-6.0-backup/
2632 Jorgen Loland 2008-06-09
bug#36265 - "Views not backed up if they are dependent on tables from different Database"
Test case for backup of two databases with a view selecting from other db.
Test author: Hema Sridharan
added:
mysql-test/r/backup_views.result
mysql-test/t/backup_views.test
per-file comments:
mysql-test/r/backup_views.result
Expected result for backup test case with view selecting from other db
mysql-test/t/backup_views.test
Test case for backup of view selecting from other db
=== added file 'mysql-test/r/backup_views.result'
--- a/mysql-test/r/backup_views.result 1970-01-01 00:00:00 +0000
+++ b/mysql-test/r/backup_views.result 2008-06-09 13:54:06 +0000
@@ -0,0 +1,453 @@
+
+starting the test for backup
+
+DROP DATABASE IF EXISTS bup_db1;
+DROP DATABASE IF EXISTS bup_db2;
+CREATE DATABASE bup_db1;
+USE bup_db1;
+Creating Table t1
+CREATE TABLE t1(id int not null primary key, name char(10),city varchar(10));
+loading data
+INSERT INTO t1 VALUES
+(1,'aa1','RR1'),(2,'aa2','RR2'),(3,'aa3','RR3'),(4,'aa4','RR4'),(5,'aa5','RR5'),(6,'aa6','RR6'),(7,'aa7','RR7'),(8,'aa8','RR8');
+SELECT * FROM t1;
+id name city
+1 aa1 RR1
+2 aa2 RR2
+3 aa3 RR3
+4 aa4 RR4
+5 aa5 RR5
+6 aa6 RR6
+7 aa7 RR7
+8 aa8 RR8
+Creating Table t3
+CREATE TABLE t3(ccode int, District char(20) not null primary key, scode int, foreign key (scode) references t1(id));
+Loading Data
+INSERT INTO t3 VALUES
+(234, 'zuloa',1),(321,'yyy',2),(765,'iug',3),(124,'LKJ',4),(235,'uth',6);
+SELECT * FROM t3;
+ccode District scode
+234 zuloa 1
+321 yyy 2
+765 iug 3
+124 LKJ 4
+235 uth 6
+Creating Table t5
+CREATE TABLE t5(Gender char(5), cand_age int,foreign key(cand_age) references
+bup_db2.t2(age));
+Loading data into table t5
+INSERT INTO t5 VALUES
+('F',23),('F',24),('M',19),('F',28),('M',43),('F',30),('M',31),('M',27);
+SELECT * FROM t5;
+Gender cand_age
+F 23
+F 24
+M 19
+F 28
+M 43
+F 30
+M 31
+M 27
+*****Create views from the table t1 of bup_db1*******
+CREATE VIEW v1 AS SELECT * FROM t1;
+*****Creating views from 2 tables(t1 and t3) within same database******
+CREATE VIEW vcomb AS SELECT name, city, ccode FROM t1, t3 WHERE id=scode;
+CREATE DATABASE bup_db2;
+USE bup_db2;
+CREATE TABLE t2(idno int, age int primary key, education char(20) ,foreign key (idno) references bup_db1.t1(id));
+INSERT INTO t2 VALUES(1,23,'BS'),(2,24,'BE'),(3,19,'school'),(4,28,'MS'),(5,43,'PHD'),(6,30,'Doctor'),(7,31,'Lawyer'),(8,27,'undergrad');
+SELECT * FROM t2;
+idno age education
+1 23 BS
+2 24 BE
+3 19 school
+4 28 MS
+5 43 PHD
+6 30 Doctor
+7 31 Lawyer
+8 27 undergrad
+****Creating View****
+CREATE VIEW v2 AS SELECT age, education FROM t2;
+******Creating Views from combination of 2 databases*******
+CREATE VIEW v3 AS SELECT name, age, education FROM bup_db1.t1 , bup_db2.t2 WHERE id=idno;
+*********Creating View from another view ***********.
+*****Creating View from other Database********
+CREATE VIEW v4 AS SELECT * FROM bup_db1.t3;
+Rename the view name
+RENAME TABLE v4 to student_details;
+USE bup_db1;
+*******Creating View from database bup_db2**********
+CREATE VIEW v5 AS SELECT * FROM bup_db2.t2;
+******Creating View v6********
+USE bup_db1;
+SELECT * FROM t1;
+id name city
+1 aa1 RR1
+2 aa2 RR2
+3 aa3 RR3
+4 aa4 RR4
+5 aa5 RR5
+6 aa6 RR6
+7 aa7 RR7
+8 aa8 RR8
+SELECT * FROM t3;
+ccode District scode
+234 zuloa 1
+321 yyy 2
+765 iug 3
+124 LKJ 4
+235 uth 6
+SELECT * FROM t5;
+Gender cand_age
+F 23
+F 24
+M 19
+F 28
+M 43
+F 30
+M 31
+M 27
+SELECT * FROM v1;
+id name city
+1 aa1 RR1
+2 aa2 RR2
+3 aa3 RR3
+4 aa4 RR4
+5 aa5 RR5
+6 aa6 RR6
+7 aa7 RR7
+8 aa8 RR8
+SELECT * FROM vcomb;
+name city ccode
+aa1 RR1 234
+aa2 RR2 321
+aa3 RR3 765
+aa4 RR4 124
+aa6 RR6 235
+SELECT * FROM v5;
+idno age education
+1 23 BS
+2 24 BE
+3 19 school
+4 28 MS
+5 43 PHD
+6 30 Doctor
+7 31 Lawyer
+8 27 undergrad
+excercise objects of bup_db2
+USE bup_db2;
+SELECT * FROM t2;
+idno age education
+1 23 BS
+2 24 BE
+3 19 school
+4 28 MS
+5 43 PHD
+6 30 Doctor
+7 31 Lawyer
+8 27 undergrad
+SELECT * FROM v2;
+age education
+23 BS
+24 BE
+19 school
+28 MS
+43 PHD
+30 Doctor
+31 Lawyer
+27 undergrad
+SELECT * FROM v3;
+name age education
+aa1 23 BS
+aa2 24 BE
+aa3 19 school
+aa4 28 MS
+aa5 43 PHD
+aa6 30 Doctor
+aa7 31 Lawyer
+aa8 27 undergrad
+SELECT * FROM student_details;
+ccode District scode
+234 zuloa 1
+321 yyy 2
+765 iug 3
+124 LKJ 4
+235 uth 6
+showing objects and create statements.
+SHOW FULL TABLES FROM bup_db1;;
+Tables_in_bup_db1 t1
+Table_type BASE TABLE
+Tables_in_bup_db1 t3
+Table_type BASE TABLE
+Tables_in_bup_db1 t5
+Table_type BASE TABLE
+Tables_in_bup_db1 v1
+Table_type VIEW
+Tables_in_bup_db1 v5
+Table_type VIEW
+Tables_in_bup_db1 vcomb
+Table_type VIEW
+SHOW FULL TABLES FROM bup_db2;;
+Tables_in_bup_db2 student_details
+Table_type VIEW
+Tables_in_bup_db2 t2
+Table_type BASE TABLE
+Tables_in_bup_db2 v2
+Table_type VIEW
+Tables_in_bup_db2 v3
+Table_type VIEW
+SHOW CREATE VIEW bup_db1.v1;;
+View v1
+Create View CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `bup_db1`.`v1` AS select `bup_db1`.`t1`.`id` AS `id`,`bup_db1`.`t1`.`name` AS `name`,`bup_db1`.`t1`.`city` AS `city` from `bup_db1`.`t1`
+character_set_client latin1
+collation_connection latin1_swedish_ci
+SHOW CREATE VIEW bup_db1.vcomb;;
+View vcomb
+Create View CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `bup_db1`.`vcomb` AS select `bup_db1`.`t1`.`name` AS `name`,`bup_db1`.`t1`.`city` AS `city`,`bup_db1`.`t3`.`ccode` AS `ccode` from (`bup_db1`.`t1` join `bup_db1`.`t3`) where (`bup_db1`.`t1`.`id` = `bup_db1`.`t3`.`scode`)
+character_set_client latin1
+collation_connection latin1_swedish_ci
+SHOW CREATE VIEW bup_db2.v3;;
+View v3
+Create View CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `bup_db2`.`v3` AS select `bup_db1`.`t1`.`name` AS `name`,`bup_db2`.`t2`.`age` AS `age`,`bup_db2`.`t2`.`education` AS `education` from (`bup_db1`.`t1` join `bup_db2`.`t2`) where (`bup_db1`.`t1`.`id` = `bup_db2`.`t2`.`idno`)
+character_set_client latin1
+collation_connection latin1_swedish_ci
+backup data
+BACKUP DATABASE bup_db1, bup_db2 TO 'bup_objectview.bak';
+backup_id
+1
+BACKUP DATABASE bup_db1 TO 'bup_objectview1.bak';
+backup_id
+2
+BACKUP DATABASE bup_db2 TO 'bup_objectview2.bak';
+backup_id
+3
+dropping database.
+DROP DATABASE bup_db1;
+DROP DATABASE bup_db2;
+RESTORE FROM 'bup_objectview.bak';
+backup_id
+4
+showing objects and create statements
+SHOW CREATE DATABASE bup_db1;;
+Database bup_db1
+Create Database CREATE DATABASE `bup_db1` /*!40100 DEFAULT CHARACTER SET latin1 */
+SHOW FULL TABLES FROM bup_db1;;
+Tables_in_bup_db1 t1
+Table_type BASE TABLE
+Tables_in_bup_db1 t3
+Table_type BASE TABLE
+Tables_in_bup_db1 t5
+Table_type BASE TABLE
+Tables_in_bup_db1 v1
+Table_type VIEW
+Tables_in_bup_db1 v5
+Table_type VIEW
+Tables_in_bup_db1 vcomb
+Table_type VIEW
+SHOW FULL TABLES FROM bup_db2;;
+Tables_in_bup_db2 student_details
+Table_type VIEW
+Tables_in_bup_db2 t2
+Table_type BASE TABLE
+Tables_in_bup_db2 v2
+Table_type VIEW
+Tables_in_bup_db2 v3
+Table_type VIEW
+SHOW CREATE VIEW bup_db1.v1;;
+View v1
+Create View CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `bup_db1`.`v1` AS select `bup_db1`.`t1`.`id` AS `id`,`bup_db1`.`t1`.`name` AS `name`,`bup_db1`.`t1`.`city` AS `city` from `bup_db1`.`t1`
+character_set_client latin1
+collation_connection latin1_swedish_ci
+SHOW CREATE VIEW bup_db1.vcomb;;
+View vcomb
+Create View CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `bup_db1`.`vcomb` AS select `bup_db1`.`t1`.`name` AS `name`,`bup_db1`.`t1`.`city` AS `city`,`bup_db1`.`t3`.`ccode` AS `ccode` from (`bup_db1`.`t1` join `bup_db1`.`t3`) where (`bup_db1`.`t1`.`id` = `bup_db1`.`t3`.`scode`)
+character_set_client latin1
+collation_connection latin1_swedish_ci
+SHOW CREATE VIEW bup_db2.v3;;
+View v3
+Create View CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `bup_db2`.`v3` AS select `bup_db1`.`t1`.`name` AS `name`,`bup_db2`.`t2`.`age` AS `age`,`bup_db2`.`t2`.`education` AS `education` from (`bup_db1`.`t1` join `bup_db2`.`t2`) where (`bup_db1`.`t1`.`id` = `bup_db2`.`t2`.`idno`)
+character_set_client latin1
+collation_connection latin1_swedish_ci
+****check for view contents after Restore*****
+USE bup_db1;
+SELECT * FROM t1;
+id name city
+1 aa1 RR1
+2 aa2 RR2
+3 aa3 RR3
+4 aa4 RR4
+5 aa5 RR5
+6 aa6 RR6
+7 aa7 RR7
+8 aa8 RR8
+SELECT * FROM t3;
+ccode District scode
+234 zuloa 1
+321 yyy 2
+765 iug 3
+124 LKJ 4
+235 uth 6
+SELECT * FROM t5;
+Gender cand_age
+F 23
+F 24
+M 19
+F 28
+M 43
+F 30
+M 31
+M 27
+SELECT * FROM v1;
+id name city
+1 aa1 RR1
+2 aa2 RR2
+3 aa3 RR3
+4 aa4 RR4
+5 aa5 RR5
+6 aa6 RR6
+7 aa7 RR7
+8 aa8 RR8
+SELECT * FROM vcomb;
+name city ccode
+aa1 RR1 234
+aa2 RR2 321
+aa3 RR3 765
+aa4 RR4 124
+aa6 RR6 235
+SELECT * FROM v5;
+idno age education
+1 23 BS
+2 24 BE
+3 19 school
+4 28 MS
+5 43 PHD
+6 30 Doctor
+7 31 Lawyer
+8 27 undergrad
+excercise objects of bup_db2
+use bup_db2;
+SELECT * FROM t2;
+idno age education
+1 23 BS
+2 24 BE
+3 19 school
+4 28 MS
+5 43 PHD
+6 30 Doctor
+7 31 Lawyer
+8 27 undergrad
+SELECT * FROM v2;
+age education
+23 BS
+24 BE
+19 school
+28 MS
+43 PHD
+30 Doctor
+31 Lawyer
+27 undergrad
+SELECT * FROM v3;
+name age education
+aa1 23 BS
+aa2 24 BE
+aa3 19 school
+aa4 28 MS
+aa5 43 PHD
+aa6 30 Doctor
+aa7 31 Lawyer
+aa8 27 undergrad
+SELECT * FROM student_details;
+ccode District scode
+234 zuloa 1
+321 yyy 2
+765 iug 3
+124 LKJ 4
+235 uth 6
+DROP DATABASE bup_db1;
+DROP DATABASE bup_db2;
+Restoring Database
+RESTORE FROM 'bup_objectview.bak';
+backup_id
+5
+USE bup_db1;
+ALTER TABLE t1 CHANGE id id tinyint not null;
+SHOW CREATE TABLE t1;;
+Table t1
+Create Table CREATE TABLE `t1` (
+ `id` tinyint(4) NOT NULL,
+ `name` char(10) DEFAULT NULL,
+ `city` varchar(10) DEFAULT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1
+SELECT * FROM t1;
+id name city
+1 aa1 RR1
+2 aa2 RR2
+3 aa3 RR3
+4 aa4 RR4
+5 aa5 RR5
+6 aa6 RR6
+7 aa7 RR7
+8 aa8 RR8
+DELETE FROM t1 WHERE id=7;
+SELECT * FROM t1;
+id name city
+1 aa1 RR1
+2 aa2 RR2
+3 aa3 RR3
+4 aa4 RR4
+5 aa5 RR5
+6 aa6 RR6
+8 aa8 RR8
+SELECT * FROM v1;
+id name city
+1 aa1 RR1
+2 aa2 RR2
+3 aa3 RR3
+4 aa4 RR4
+5 aa5 RR5
+6 aa6 RR6
+8 aa8 RR8
+USE bup_db2;
+SELECT * FROM v3;
+name age education
+aa1 23 BS
+aa2 24 BE
+aa3 19 school
+aa4 28 MS
+aa5 43 PHD
+aa6 30 Doctor
+aa8 27 undergrad
+BACKUP DATABASE bup_db1, bup_db2 TO 'bup_objectview3.bak';
+backup_id
+6
+DROP DATABASE bup_db1;
+DROP DATABASE bup_db2;
+RESTORE FROM 'bup_objectview3.bak';
+backup_id
+7
+USE bup_db2;
+SELECT * FROM v3;
+name age education
+aa1 23 BS
+aa2 24 BE
+aa3 19 school
+aa4 28 MS
+aa5 43 PHD
+aa6 30 Doctor
+aa8 27 undergrad
+USE bup_db1;
+SELECT * FROM t1;
+id name city
+1 aa1 RR1
+2 aa2 RR2
+3 aa3 RR3
+4 aa4 RR4
+5 aa5 RR5
+6 aa6 RR6
+8 aa8 RR8
+
+*** DROP bup_db1, bup_db2 DATABASE ****
+
+DROP DATABASE bup_db1;
+DROP DATABASE bup_db2;
=== added file 'mysql-test/t/backup_views.test'
--- a/mysql-test/t/backup_views.test 1970-01-01 00:00:00 +0000
+++ b/mysql-test/t/backup_views.test 2008-06-09 13:54:06 +0000
@@ -0,0 +1,295 @@
+###########################################################################
+# Author: Hema
+# Date: 2008-04-11
+# Purpose: To test the metadata consistency of views.
+###############################################################################
+--source include/have_innodb.inc
+--source include/not_embedded.inc
+--source include/have_debug.inc
+
+connect (backup,localhost,root,,);
+connect (breakpoints,localhost,root,,);
+
+##############################################################
+--echo
+--echo starting the test for backup
+--echo
+##############################################################
+
+--error 0,1
+--remove_file $MYSQLTEST_VARDIR/master-data/bup_objectview.bak
+
+#Create Database and object view for this test.
+
+--disable_warnings
+DROP DATABASE IF EXISTS bup_db1;
+DROP DATABASE IF EXISTS bup_db2;
+
+
+#We are creating 2 databases bup_db1 and bup_db2 to accomplish wide testing of views in order to check their consistency # after BACKUP AND RESTORE.
+# In bup_db1 DATABASE consists of tables :t1 t3 t5
+# and views v1(based on t1 alone), vcomb(based on t1 and t3), v5( based on bup_db2.t2), v6(based on bup_db2.v2,bup_db1.t5)
+#
+# In bup_db2,it consists table t2
+# views v2(based on t2), v3( based on combination of bup_db1 and bup_db2),v4( based on bup_db1.t3), vv( based on v3)
+#
+
+--enable_warnings
+
+CREATE DATABASE bup_db1;
+USE bup_db1;
+
+#Create table and load with data.
+
+--echo Creating Table t1
+CREATE TABLE t1(id int not null primary key, name char(10),city varchar(10));
+
+--echo loading data
+INSERT INTO t1 VALUES
+(1,'aa1','RR1'),(2,'aa2','RR2'),(3,'aa3','RR3'),(4,'aa4','RR4'),(5,'aa5','RR5'),(6,'aa6','RR6'),(7,'aa7','RR7'),(8,'aa8','RR8');
+
+SELECT * FROM t1;
+
+--echo Creating Table t3
+
+CREATE TABLE t3(ccode int, District char(20) not null primary key, scode int, foreign key (scode) references t1(id));
+
+--echo Loading Data
+
+INSERT INTO t3 VALUES
+(234, 'zuloa',1),(321,'yyy',2),(765,'iug',3),(124,'LKJ',4),(235,'uth',6);
+
+SELECT * FROM t3;
+
+--echo Creating Table t5
+
+CREATE TABLE t5(Gender char(5), cand_age int,foreign key(cand_age) references
+bup_db2.t2(age));
+
+--echo Loading data into table t5
+
+INSERT INTO t5 VALUES
+('F',23),('F',24),('M',19),('F',28),('M',43),('F',30),('M',31),('M',27);
+
+SELECT * FROM t5;
+
+--echo *****Create views from the table t1 of bup_db1*******
+
+CREATE VIEW v1 AS SELECT * FROM t1;
+
+--echo *****Creating views from 2 tables(t1 and t3) within same database******
+
+CREATE VIEW vcomb AS SELECT name, city, ccode FROM t1, t3 WHERE id=scode;
+
+
+CREATE DATABASE bup_db2;
+USE bup_db2;
+
+CREATE TABLE t2(idno int, age int primary key, education char(20) ,foreign key (idno) references bup_db1.t1(id));
+
+INSERT INTO t2 VALUES(1,23,'BS'),(2,24,'BE'),(3,19,'school'),(4,28,'MS'),(5,43,'PHD'),(6,30,'Doctor'),(7,31,'Lawyer'),(8,27,'undergrad');
+
+
+SELECT * FROM t2;
+
+--echo ****Creating View****
+
+CREATE VIEW v2 AS SELECT age, education FROM t2;
+
+--echo ******Creating Views from combination of 2 databases*******
+
+CREATE VIEW v3 AS SELECT name, age, education FROM bup_db1.t1 , bup_db2.t2 WHERE id=idno;
+
+--echo *********Creating View from another view ***********.
+
+#Bug#35347 Mysql Server crash while doing restore with views for default driver
+# BUG#34758 Server crashes if database with views backed up using CS driver
+#Creatig view from another view is possible if bug#35347 and bug#34758 is fixed.
+
+#CREATE VIEW vv (N, A, E) AS SELECT * FROM v3;
+
+--echo *****Creating View from other Database********
+
+CREATE VIEW v4 AS SELECT * FROM bup_db1.t3;
+
+--echo Rename the view name
+
+RENAME TABLE v4 to student_details;
+
+USE bup_db1;
+
+--echo *******Creating View from database bup_db2**********
+
+CREATE VIEW v5 AS SELECT * FROM bup_db2.t2;
+
+--echo ******Creating View v6********
+
+#Bug#36213 Restore fails for a database that has views created using another database .
+
+#CREATE VIEW v6 AS SELECT education,gender FROM bup_db2.v2, t5 WHERE cand_age=age;
+
+#Excercise the objects of bup_db1
+
+USE bup_db1;
+
+SELECT * FROM t1;
+
+SELECT * FROM t3;
+
+SELECT * FROM t5;
+
+SELECT * FROM v1;
+
+SELECT * FROM vcomb;
+
+SELECT * FROM v5;
+
+#SELECT * FROM v6;
+
+--echo excercise objects of bup_db2
+
+USE bup_db2;
+
+SELECT * FROM t2;
+
+SELECT * FROM v2;
+
+SELECT * FROM v3;
+
+#SELECT * FROM vv;
+
+SELECT * FROM student_details; #view v4 is renamed as student_details
+
+#Show the data and Create statements
+
+--echo showing objects and create statements.
+--query_vertical SHOW FULL TABLES FROM bup_db1;
+--query_vertical SHOW FULL TABLES FROM bup_db2;
+--query_vertical SHOW CREATE VIEW bup_db1.v1;
+--query_vertical SHOW CREATE VIEW bup_db1.vcomb;
+--query_vertical SHOW CREATE VIEW bup_db2.v3;
+
+#Backup and restore data.
+--echo backup data
+
+BACKUP DATABASE bup_db1, bup_db2 TO 'bup_objectview.bak';
+
+BACKUP DATABASE bup_db1 TO 'bup_objectview1.bak';
+
+BACKUP DATABASE bup_db2 TO 'bup_objectview2.bak';
+
+--echo dropping database.
+DROP DATABASE bup_db1;
+
+DROP DATABASE bup_db2;
+
+#RESTORE FROM bup_objectview.bak;
+
+#Individual databases cannot be restored because of VIEW DEPENDENCY
+
+#--error 1146
+#RESTORE FROM 'bup_objectview1.bak';
+#--error 1146
+#RESTORE FROM 'bup_objectview2.bak';
+
+RESTORE FROM 'bup_objectview.bak';
+
+#show data and create statements
+--echo showing objects and create statements
+--query_vertical SHOW CREATE DATABASE bup_db1;
+--query_vertical SHOW FULL TABLES FROM bup_db1;
+--query_vertical SHOW FULL TABLES FROM bup_db2;
+--query_vertical SHOW CREATE VIEW bup_db1.v1;
+--query_vertical SHOW CREATE VIEW bup_db1.vcomb;
+--query_vertical SHOW CREATE VIEW bup_db2.v3;
+
+--echo ****check for view contents after Restore*****
+
+#Excercise the objects of bup_db1
+USE bup_db1;
+SELECT * FROM t1;
+
+SELECT * FROM t3;
+
+SELECT * FROM t5;
+
+SELECT * FROM v1;
+
+SELECT * FROM vcomb;
+
+SELECT * FROM v5;
+
+#SELECT * FROM v6;
+--echo excercise objects of bup_db2
+use bup_db2;
+SELECT * FROM t2;
+
+SELECT * FROM v2;
+
+SELECT * FROM v3;
+
+#SELECT * FROM vv;
+
+SELECT * FROM student_details;
+
+DROP DATABASE bup_db1;
+DROP DATABASE bup_db2;
+
+--echo Restoring Database
+
+RESTORE FROM 'bup_objectview.bak';
+
+USE bup_db1;
+
+#Alter table t1 and take BACKUP to see if view is not affected.
+
+ALTER TABLE t1 CHANGE id id tinyint not null;
+--query_vertical SHOW CREATE TABLE t1;
+
+SELECT * FROM t1;
+
+DELETE FROM t1 WHERE id=7;
+SELECT * FROM t1;
+
+SELECT * FROM v1;
+
+USE bup_db2;
+SELECT * FROM v3;
+
+#BUG#35249 Mysql server crash for delete operation followed by backup for Default Drivers.
+
+#DELETE FROM t2 WHERE age=24;
+#SELECT * FROM t2;
+#SELECT * FROM v3;
+
+BACKUP DATABASE bup_db1, bup_db2 TO 'bup_objectview3.bak';
+
+DROP DATABASE bup_db1;
+DROP DATABASE bup_db2;
+
+RESTORE FROM 'bup_objectview3.bak';
+
+USE bup_db2;
+SELECT * FROM v3;
+
+USE bup_db1;
+SELECT * FROM t1;
+
+# Test cleanup section
+
+--echo
+--echo *** DROP bup_db1, bup_db2 DATABASE ****
+--echo
+
+DROP DATABASE bup_db1;
+
+DROP DATABASE bup_db2;
+
+
+--remove_file $MYSQLTEST_VARDIR/master-data/bup_objectview.bak
+
+--remove_file $MYSQLTEST_VARDIR/master-data/bup_objectview1.bak
+
+--remove_file $MYSQLTEST_VARDIR/master-data/bup_objectview2.bak
+--remove_file $MYSQLTEST_VARDIR/master-data/bup_objectview3.bak
+#BUG#35249 Mysql server crash for delete operation followed by backup for Default Drivers.
| Thread |
|---|
| • bzr commit into mysql-6.0 branch (jorgen.loland:2632) Bug#36265 | Jorgen Loland | 9 Jun |
