Bug in MysqlCC 0.8.10-beta

How-To-Repeat:
Create a table:
CREATE TABLE `stat_intermediate_consumption` (
`id` int(11) NOT NULL auto_increment,
`year` smallint(6) NOT NULL default '0',
`zone` smallint(6) NOT NULL default '0',
`frombusiness` smallint(6) NOT NULL default '0',
`tobusiness` smallint(6) NOT NULL default '0',
`intermediate_consumption` int(11) NOT NULL default '0',
`project_run_id` smallint(6) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

Change the column `intermediate_consumption` to double with mysqlcc.

Error:
[panda@localhost:mysql.sock] ERROR 1064: You have an error in your SQL
syntax. Check the manual that corresponds to your MySQL server version
for the right syntax to use near ') NOT NULL DEFAULT '0' AFTER
`tobusiness`,
CHANGE `project_run_



------------------------------------------------------------ ---------
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-thread13913@lists.mysql.com
To unsubscribe, e-mail

Re: Bug in MysqlCC 0.8.10-beta

Hi!

The problem with the below query is that intermediate_consumption is
originally defined as:
`intermediate_consumption` int(11) NOT NULL default '0',

As you can see, it has a field length of 11 and when you switch the field
type to "double" it maintains the field length thus creating an incorrect
SQL statement because double(11) is not valid. I don't agree this is a bug
as such but I do agree it creates confusion and it's missleading.

I have just added a warning message to the messages panel that will notify
users when situation occures.

Thanks for your report.

Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/?ref=mjdc
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Jorge del Conde
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
<___/ www.mysql.com

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

----- Original Message -----
From: "Sebastian Dransfeld"
To:
Sent: Thursday, March 06, 2003 6:38 AM
Subject: Bug in MysqlCC 0.8.10-beta


> How-To-Repeat:
> Create a table:
> CREATE TABLE `stat_intermediate_consumption` (
> `id` int(11) NOT NULL auto_increment,
> `year` smallint(6) NOT NULL default '0',
> `zone` smallint(6) NOT NULL default '0',
> `frombusiness` smallint(6) NOT NULL default '0',
> `tobusiness` smallint(6) NOT NULL default '0',
> `intermediate_consumption` int(11) NOT NULL default '0',
> `project_run_id` smallint(6) NOT NULL default '0',
> PRIMARY KEY (`id`)
> ) TYPE=MyISAM;
>
> Change the column `intermediate_consumption` to double with mysqlcc.
>
> Error:
> [panda@localhost:mysql.sock] ERROR 1064: You have an error in your SQL
> syntax. Check the manual that corresponds to your MySQL server version
> for the right syntax to use near ') NOT NULL DEFAULT '0' AFTER
> `tobusiness`,
> CHANGE `project_run_
>
>
>
> ------------------------------------------------------------ ---------
> 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-thread13913@lists.mysql.com
> To unsubscribe, e-mail
>



------------------------------------------------------------ ---------
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-thread13915@lists.mysql.com
To unsubscribe, e-mail