Re: bzr commit into mysql-5.1-bugteam branch (nirbhay.choubey:3554) Bug#54899

[Nirbhay Choubey]

Hi Sergey, Joro,

One more use case :

./bin/mysql --one-database test

mysql> \R \d >
test > drop database test;             # Query OK
(none) > select 1;                          # Outputs 1
(none) > create database test;      # Query OK
(none) > select 1;                          # Outputs 1
(none) >use test;                           # Database changed
test >select 1;                               # Outputs 1

In the above scenario, notice how prompt changes.

>> Joro and Svoj expect queries to be accepted when one-databse is 
>> "test" and
>> prompt says "test".
>> Nirbhay does not.

Now, in the above scenario, one-database is "test" but prompt/current_db 
is not,
but we still have to keep executing the statements, as we started with 
'test' as
default database.

Regards,
Nirbhay

PS. Bug#54899 points to this scenario.