List:Commits« Previous MessageNext Message »
From:hema Date:April 20 2008 1:02am
Subject:bk commit into 6.0 tree (hsridharan:1.2612)
View as plain text  
Below is the list of changes that have just been committed into a local
6.0 repository of hsridharan.  When hsridharan does a push these changes
will be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2008-04-20 01:02:03+02:00, hsridharan@stripped +2 -0
  backup_views.result, backup_views.test:
    Test for metadata consistency for views

  mysql-test/suite/backup/r/backup_views.result@stripped, 2008-04-20 01:01:42+02:00,
hsridharan@stripped +453 -0
    Test for metadata consistency for views

  mysql-test/suite/backup/r/backup_views.result@stripped, 2008-04-20 01:01:42+02:00,
hsridharan@stripped +0 -0

  mysql-test/suite/backup/t/backup_views.test@stripped, 2008-04-20 01:01:14+02:00,
hsridharan@stripped +295 -0
    Test for metadata consistency for views

  mysql-test/suite/backup/t/backup_views.test@stripped, 2008-04-20 01:01:14+02:00,
hsridharan@stripped +0 -0

diff -Nrup a/mysql-test/suite/backup/r/backup_views.result
b/mysql-test/suite/backup/r/backup_views.result
--- /dev/null	Wed Dec 31 16:00:00 196900
+++ b/mysql-test/suite/backup/r/backup_views.result	2008-04-20 01:01:42 +02:00
@@ -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;
diff -Nrup a/mysql-test/suite/backup/t/backup_views.test
b/mysql-test/suite/backup/t/backup_views.test
--- /dev/null	Wed Dec 31 16:00:00 196900
+++ b/mysql-test/suite/backup/t/backup_views.test	2008-04-20 01:01:14 +02:00
@@ -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
• bk commit into 6.0 tree (hsridharan:1.2612)hema20 Apr
  • Re: bk commit into 6.0 tree (hsridharan:1.2612)Serge Kozlov20 Apr
    • RE: bk commit into 6.0 tree (hsridharan:1.2612)Hema Sridharan21 Apr