Re: CREATE DATABASE IF NOT EXISTS not working in 4.1.2-alpha?

Steve Hay writes:
> Hi,
>
> I'm just looking at 4.1.2-alpha for the first time and immediately ran
> into a problem. The IF NOT EXISTS part of CREATE DATABASE doesn't seem
> to be working -- it causes an error if the database does already exist,
> just as you would get without the IF NOT EXISTS bit:
>
> =====
> C:\mysql\bin>mysql -u root
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1 to server version: 4.1.2-alpha-nt-max
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> create database if not exists foo;
> Query OK, 1 row affected (0.00 sec)
>
> mysql> create database if not exists foo;
> ERROR 1006 (HY000): Can't create database 'foo' (errno: 17)
> =====
>
> The above SQL commands worked fine in 4.0.18. Has this been
> deliberately changed (I couldn't see anything different in the manual),
> or is it broken?
>
> - Steve
>
>

Hi!

I just tested it with 4.1.3 and it worked like a charm:


mysql> create database if not exists xxx;
Query OK, 1 row affected (0.06 sec)

mysql> create database if not exists xxx;
Query OK, 0 rows affected (0.00 sec)


--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

CREATE DATABASE IF NOT EXISTS not working in 4.1.2-alpha?

Hi,

I'm just looking at 4.1.2-alpha for the first time and immediately ran
into a problem. The IF NOT EXISTS part of CREATE DATABASE doesn't seem
to be working -- it causes an error if the database does already exist,
just as you would get without the IF NOT EXISTS bit:

=====
C:\mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.2-alpha-nt-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database if not exists foo;
Query OK, 1 row affected (0.00 sec)

mysql> create database if not exists foo;
ERROR 1006 (HY000): Can't create database 'foo' (errno: 17)
=====

The above SQL commands worked fine in 4.0.18. Has this been
deliberately changed (I couldn't see anything different in the manual),
or is it broken?

- Steve



------------------------------------------------
Radan Computational Ltd.

The information contained in this message and any files transmitted with it are confidential and intended for the addressee(s) only. If you have received this message in error or there are any problems, please notify the sender immediately. The unauthorized use, disclosure, copying or alteration of this message is strictly forbidden. Note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Radan Computational Ltd. The recipient(s) of this message should check it and any attached files for viruses: Radan Computational will accept no liability for any damage caused by any virus transmitted by this email.


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: CREATE DATABASE IF NOT EXISTS not working in 4.1.2-alpha?

Sinisa Milivojevic wrote:

>Steve Hay writes:
>
>
>>I'm just looking at 4.1.2-alpha for the first time and immediately ran
>>into a problem. The IF NOT EXISTS part of CREATE DATABASE doesn't seem
>>to be working -- it causes an error if the database does already exist,
>>just as you would get without the IF NOT EXISTS bit:
>>
>I just tested it with 4.1.3 and it worked like a charm:
>
>
>mysql> create database if not exists xxx;
>Query OK, 1 row affected (0.06 sec)
>
>mysql> create database if not exists xxx;
>Query OK, 0 rows affected (0.00 sec)
>
Where can I get 4.1.3? I tried the snapshots page
(http://downloads.mysql.com/snapshots.php), but there aren't any for 4.1.x.

Is there any estimate for when 4.1.x will become the "stable" production
version?

- Steve



------------------------------------------------
Radan Computational Ltd.

The information contained in this message and any files transmitted with it are confidential and intended for the addressee(s) only. If you have received this message in error or there are any problems, please notify the sender immediately. The unauthorized use, disclosure, copying or alteration of this message is strictly forbidden. Note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Radan Computational Ltd. The recipient(s) of this message should check it and any attached files for viruses: Radan Computational will accept no liability for any damage caused by any virus transmitted by this email.


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: CREATE DATABASE IF NOT EXISTS not working in 4.1.2-alpha?

Steve Hay writes:
> Sinisa Milivojevic wrote:
>
> >
> Where can I get 4.1.3? I tried the snapshots page
> (http://downloads.mysql.com/snapshots.php), but there aren't any for 4.1.x.
>
> Is there any estimate for when 4.1.x will become the "stable" production
> version?
>
> - Steve
>

4.1.3 should be out in one week approximately.

4.1 is planned to be production at the end of this year.

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org