comment with "foreign key" text causes innodb CREATE TABLE failure

am 14.03.2003 23:33:54 von Brandon Bird

From: brandonb@pacercats.com
To: mysql@lists.mysql.com
Subject: comment with "foreign key" text causes innodb CREATE TABLE
failure

Description:=09
If an innodb table is created with a comment with the words "foreign
key", the table creation fails.=20

The syntax used to work with MySQL-4.0.4-beta-win and earlier,
running on both Linux and Windows. This query (missing the comment)
executes successfully:

CREATE TABLE a(a INT) TYPE=3Dinnodb;

I consider this bug pretty important since many of our existing scripts
use this style of comments.

How-To-Repeat:=09
Execute this query:
CREATE TABLE a(a INT /* foreign key */) TYPE=3Dinnodb;
=20
You'll get this output:
ERROR 1005: Can't create table '.\a\a.frm' (errno: 150)=09

Fix:=09
Change the /* foreign key */ comment in all database scripts.
"foreign-key" works.

Synopsis: comment with "foreign key" text causes innodb table
creation failure
Submitter-Id:=09
Originator: Brandon Bird
Organization: Pacer/CATS
MySQL support: none
Severity: serious
Priority:=09
Category: mysqld
Class: sw-bug
Release: mysql-4.0.11

Exectutable: mysqld-max-nt=20
Environment: dell 4400; ntfs
System: WinXP
Compiler: =20
Architecture: i

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

comment with "foreign key" text causes innodb CREATE TABLE failure

am 16.03.2003 17:24:11 von Michael Widenius

Hi!

>>>>> "Brandon" == Brandon Bird writes:

Brandon> From: brandonb@pacercats.com
Brandon> To: mysql@lists.mysql.com
Brandon> Subject: comment with "foreign key" text causes innodb CREATE TABLE
Brandon> failure

Brandon> Description:
Brandon> If an innodb table is created with a comment with the words "foreign
Brandon> key", the table creation fails.

Just a short note about this.

Currently the InnoDB table handler scans the CREATE statement and
handles the foreign key definition infernally in InnoDB.

In 4.1 MySQL will handle the parsing of the foreign key definition and
will store the foreign key definitions in the normal table definition
file. This will fix these kind of problems once and for all.

Regards,
Monty

--
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ 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
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

comment with "foreign key" text causes innodb CREATE TABLE failure

am 16.03.2003 17:24:11 von Michael Widenius

broken database? or?

am 16.03.2003 18:04:37 von joe

I'm a total newbie. If this issue does not belong here, please suggest a
more appropriate mailing list or fourm.

I have recently moved onto a new server. For a brief period after the move
I could access the mySQL database using GUI clients such as mysqlf and
sqlyog. And the web site that it supported was accessible in various
browsers (msie, mozilla, opera, etc.)

Now the PHP-based forum that the MySQL serves is down. When I try to open
it in the browser I get four error error messages that say MySQL has
problems with login in, passwords, etc.

I can't get into MySQL using the MySQL front ends. Attempting that gets an
error that says "Error 1130 - host dialup (and then it lists the first node
in my internet connection) is not allowed to connect to this MySQL
server." I gather from this that the login and pw are not even getting to
the server. I am not seeing this error with any other application nor am I
having any problem with any other app using the net.

I'm over my head here. I can't even claim to understand the fundamentals of
PHP and MySQL.

Can anyone suggest how I can begin to address this? Or is someone here
willing to help me fix it?

TIA

------------------------------------------------------------ ---------
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
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: broken database? or?

am 16.03.2003 19:20:23 von leifkris

On Sun, 16 Mar 2003 12:04:37 -0500, joe wrote:

>I have recently moved onto a new server. For a brief period after the =
move=20
>I could access the mySQL database using GUI clients such as mysqlf and=20
>sqlyog. And the web site that it supported was accessible in various=20
>browsers (msie, mozilla, opera, etc.)
>
>Now the PHP-based forum that the MySQL serves is down. When I try to =
open=20
>it in the browser I get four error error messages that say MySQL has=20
>problems with login in, passwords, etc.

Joe,
your PHP scripts are probably out of date, using global variables. As of
PHP 4.2, the setting register_globals =3D off as default, and this made a
lot of PHP scripts all but obsolete overnight. You can verify for
yourself what the PHP settings are if you upload a little code to your
webserver:

Save this as phpinfo.php on the document root, then point your browser
to it. You'll get all kinds of useful information.

I have not found documentation with a comprehensive explanation of how
scripts should be rewritten, but there's a lot of information out there
if you know what to look for. See especially
.

By the way, replies belong to the list, not to you personally. Please
remove your address from the Reply-To field when addressing mail lists.

regards,
--=20
Leif Biberg Kristensen
http://solumslekt.org/

------------------------------------------------------------ ---------
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
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php