Hi Nirbhay, Joro!
Use case #5:
I have a dump provided by mysqldump tool:
--
USE `non_existent_db`;
CREATE TABLE `table_in_non_existent_db`(a INT);
USE `test`;
CREATE TABLE `table_in_test`(a INT);
--
Note: I simplified dump for better readability.
I have no `non_existent_db` database.
I have empty `test` database.
I want to load tables from `test` database.
I read manual for one-database option:
--
Ignore statements except those that occur while the default database
is the one named on the command line. This option is rudimentary and
should be used with care. Statement filtering is based only on USE
statements.
--
I think this option does what I need.
I do "mysql --one-database test".
I expect new table in `test`: `table_in_test`.
Without this patch I get new table.
With this patch `test` database is empty.
Regards,
Sergey
On Wed, Nov 17, 2010 at 10:09:46AM +0000, Nirbhay Choubey wrote:
> #At file:///home/nirbhay/Project/mysql/repo/wl/mysql-5.1-bugteam-54899/ based on
> revid:guilhem@stripped
>
> 3554 Nirbhay Choubey 2010-11-17
> Bug#54899 : --one-database option cannot handle DROP/CREATE DATABASE
> commands
...skip...
> @@ -1449,8 +1450,9 @@ static struct my_option my_long_options[
> &opt_sigint_ignore, &opt_sigint_ignore, 0, GET_BOOL,
> NO_ARG, 0, 0, 0, 0, 0, 0},
> {"one-database", 'o',
> - "Only update the default database. This is useful for skipping updates "
> - "to other database in the update log.",
> + "Ignore statements except those that occur while the default "
> + "database is the one named at the command line and USE command "
> + "is not executed with some other database.",
> 0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
> #ifdef USE_POPEN
> {"pager", OPT_PAGER,
Are you sure your addendum is correct?
Regards,
Sergey
--
Sergey Vojtovich <svoj@stripped>
MySQL AB, Software Engineer
Izhevsk, Russia, www.mysql.com
