Download & Extend
Issues

Types is a reserved keyword as of MySQL 4.1.x

Posted by Dries on April 28, 2003 at 1:51pm
Project:Drupal core
Version:x.y.z
Component:Base system
Category:bug report
Priority:normal
Assigned:marco
Status:closed (fixed)

Issue Summary

"types" is a reserved keyword as of MySQL 4.x.x. See http://drupal.org/node/view/1612.

Login or register to post comments

Comments

#1

Posted by marco on May 10, 2003 at 8:42am
Priority:critical» normal
Assigned to:Anonymous» marco

This is a problem in MySQL 4.1.x only, which is alpha at the moment, while it doesn't seem to be a problem in MySQL 4.0.x, currently in production.
This can be fixed changing the field name as suggested by Ax, or using double quotes.

I lower the priority and wait for some feedback on the best way to fix (renaming or double quotes)

#2

Posted by Dries on May 10, 2003 at 3:04pm

I assume that using double quotes is a MySQL-ism and not ANSI SQL?

#3

Posted by marco on May 10, 2003 at 5:14pm

Double quotes is ANSI, but works in MySQL only in ANSI Mode. In standard mode you must use backticks, which is not ANSI.
So it seems table renaming is the only portable solution.

#4

Posted by moshe weitzman on May 30, 2003 at 7:37pm

fixed with a table rename. now in CVS. thanks marco

#5

Posted by Anonymous on June 1, 2003 at 12:16pm

#6

Posted by marco on June 4, 2003 at 10:05am

it has not been committed yet, I re-open

#7

Posted by al on June 11, 2003 at 7:03pm
Title:"Types" is a reserved keyword as of MySQL 4.x.x» Types is a reserved keyword as of MySQL 4.1.x

I think this has been fixed:
al@drupal:~/drupal/drupal> grep types database/database.mysql
Can someone please confirm and CLOSE this?

#8

Posted by killes@www.drop.org on June 11, 2003 at 7:14pm

Confirmed, did not find "types" in sql-statement in core.