Re: bk commit into 6.0 tree (hsridharan:1.2612)

[Serge Kozlov]

Hi, Hema.

My comments start with "skozlov" below.

I approve if you agree with these notes and will fix them.

hema@stripped wrote:
> 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.
skozlov:
Please extend purpose of test: what means metadata consistency of views.


> +############################################################################### 
> 
> +--source include/have_innodb.inc
> +--source include/not_embedded.inc
> +--source include/have_debug.inc

skozlov:
Are you really use debug options in the test case? If not please remove it.

> +
> +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;

skozlov:
Please use for any SELECT with two or more rows ORDER BY clause or 
--sorted-result mysqltest command.

> +
> +--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.
> 
> -- 
> MySQL Code Commits Mailing List
> For list archives: http://lists.mysql.com/commits
> To unsubscribe:    http://lists.mysql.com/commits?unsub=1
> 


-- 
Serge Kozlov, QA Developer
MySQL AB, Moscow, Russia, www.mysql.com
Office:

Are you MySQL certified?  www.mysql.com/certification