From: Sergey Vojtovich
Date: November 19 2010 9:55am
Subject: Re: bzr commit into mysql-5.1-bugteam branch
 (nirbhay.choubey:3554) Bug#54899
List-Archive: http://lists.mysql.com/commits/124390
Message-Id: <20101119095522.GA9994@june>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Hi Nirbhay,

what is expected in the below example?

Thanks,
Sergey

On Fri, Nov 19, 2010 at 12:01:49PM +0530, Nirbhay Choubey wrote:
> 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.
> 
> -- 
> MySQL Code Commits Mailing List
> For list archives: http://lists.mysql.com/commits
> To unsubscribe:    http://lists.mysql.com/commits?unsub=svoj@stripped
> 

-- 
Sergey Vojtovich <svoj@stripped>
MySQL AB, Software Engineer
Izhevsk, Russia, www.mysql.com