mysql client bug

Hi,

how-to-repeat:

mysql> create database `stupid db`;
Query OK, 1 row affected (0.00 sec)

mysql> use `stupid db`;
ERROR 1049: Unknown database '`stupid'


mysql_select_db or mysql_real_query with use works fine.

Georg

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13238@lists.mysql.com
To unsubscribe, e-mail

mysql client bug

Hi Georg,

Georg Richter writes:
> Hi,
>
> how-to-repeat:
>
> mysql> create database `stupid db`;
> Query OK, 1 row affected (0.00 sec)
>
> mysql> use `stupid db`;
> ERROR 1049: Unknown database '`stupid'
>
>
> mysql_select_db or mysql_real_query with use works fine.

This is fixed in mysql client 13.1 version, in MySQL 4.1.
Thanks for the report.

Regards,

- Jani

For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Jani Tolonen
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.com

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13262@lists.mysql.com
To unsubscribe, e-mail

Re: mysql client bug

On Wednesday 11 December 2002 15:57, Jani Tolonen wrote:
>
> This is fixed in mysql client 13.1 version, in MySQL 4.1.
> Thanks for the report.
>

Just detected that he same problem exists with connect

how-to-repeat:

mysql> connect `stupid db`;
ERROR 2005: Unknown MySQL Server Host 'db`' (1)
mysql>

Regards

Georg

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13352@lists.mysql.com
To unsubscribe, e-mail

Re: mysql client bug

On Wednesday 25 December 2002 16:34, Sinisa Milivojevic wrote:
> Georg Richter writes:
> > On Wednesday 11 December 2002 15:57, Jani Tolonen wrote:
> > > This is fixed in mysql client 13.1 version, in MySQL 4.1.
> > > Thanks for the report.
> >
> > Just detected that he same problem exists with connect
> >
> > how-to-repeat:
> >
> > mysql> connect `stupid db`;
> > ERROR 2005: Unknown MySQL Server Host 'db`' (1)
> > mysql>
> >
> > Regards
> >
> > Georg
>
> Sorry, but which OS supports hostnames with blanks ???

Hello SInisa,

Syntax is: connect database host, and the dbname is quoted in backticks in my
example:

mysql> connect test localhost;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Connection id: 14
Current database: test

mysql> connect `stupid db` localhost;
ERROR 2005: Unknown MySQL Server Host 'db`' (1)

Regards

Georg

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13359@lists.mysql.com
To unsubscribe, e-mail

Re: mysql client bug

Georg Richter writes:
> On Wednesday 11 December 2002 15:57, Jani Tolonen wrote:
> >
> > This is fixed in mysql client 13.1 version, in MySQL 4.1.
> > Thanks for the report.
> >
>
> Just detected that he same problem exists with connect
>
> how-to-repeat:
>
> mysql> connect `stupid db`;
> ERROR 2005: Unknown MySQL Server Host 'db`' (1)
> mysql>
>
> Regards
>
> Georg

Sorry, but which OS supports hostnames with blanks ???

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13358@lists.mysql.com
To unsubscribe, e-mail

Re: mysql client bug

Georg Richter writes:
> On Wednesday 25 December 2002 16:34, Sinisa Milivojevic wrote:
>
> Hello SInisa,
>
> Syntax is: connect database host, and the dbname is quoted in backticks in my
> example:
>
> mysql> connect test localhost;
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Connection id: 14
> Current database: test
>
> mysql> connect `stupid db` localhost;
> ERROR 2005: Unknown MySQL Server Host 'db`' (1)
>
> Regards
>
> Georg

Thanks for the explanation.

You are right and this should be fixed ...

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13360@lists.mysql.com
To unsubscribe, e-mail