List:Commits« Previous MessageNext Message »
From:Nirbhay Choubey Date:November 19 2010 10:17am
Subject:Re: bzr commit into mysql-5.1-bugteam branch (nirbhay.choubey:3554)
Bug#54899
View as plain text  
Hi Sergey,

I just wanted to put forward a 'valid' case where prompt and
database at command-line do not match (i.e. null vs test), but
still we do not filter statements.

This is against the opinion that

"queries to be accepted when one-database is
"test" and prompt says "test"."


Thanks,
Nirbhay

On Friday 19 November 2010 03:25 PM, Sergey Vojtovich wrote:
> Hi Nirbhay,
>
> what is expected in the below example?
>
>    
>> 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=1
>>
>>      
>    

Thread
bzr commit into mysql-5.1-bugteam branch (nirbhay.choubey:3554)Bug#54899Nirbhay Choubey9 Nov
  • Re: bzr commit into mysql-5.1-bugteam branch(nirbhay.choubey:3554) Bug#54899Sergey Vojtovich16 Nov
    • Re: bzr commit into mysql-5.1-bugteam branch (nirbhay.choubey:3554)Bug#54899Nirbhay Choubey17 Nov
      • Re: bzr commit into mysql-5.1-bugteam branch(nirbhay.choubey:3554) Bug#54899Sergey Vojtovich17 Nov
        • Re: bzr commit into mysql-5.1-bugteam branch (nirbhay.choubey:3554)Bug#54899Nirbhay Choubey18 Nov
          • Re: bzr commit into mysql-5.1-bugteam branch (nirbhay.choubey:3554)Bug#54899Nirbhay Choubey19 Nov
            • Re: bzr commit into mysql-5.1-bugteam branch(nirbhay.choubey:3554) Bug#54899Sergey Vojtovich19 Nov
              • Re: bzr commit into mysql-5.1-bugteam branch (nirbhay.choubey:3554)Bug#54899Nirbhay Choubey19 Nov
                • Re: bzr commit into mysql-5.1-bugteam branch(nirbhay.choubey:3554) Bug#54899Sergey Vojtovich19 Nov
                  • Re: bzr commit into mysql-5.1-bugteam branch (nirbhay.choubey:3554)Bug#54899Nirbhay Choubey19 Nov
                    • Re: bzr commit into mysql-5.1-bugteam branch(nirbhay.choubey:3554) Bug#54899Sergey Vojtovich19 Nov
                      • Re: bzr commit into mysql-5.1-bugteam branch (nirbhay.choubey:3554)Bug#54899Nirbhay Choubey22 Nov