Project

General

Profile

Actions
Copy link

Bug #14125

closed

"HASH" is a reserved SQL keyword

Added by old_davide over 20 years ago. Updated over 18 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Robert Lemke
Category:
Backend API
Target version:
-
Start date:
2004-04-29
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

I cannot create tables who contain a field called "HASH" because in MySQL 4.1.0-alpha it is a SQL reserved keyword.

From file tables.sql

CREATE TABLE cache_hash (
hash varchar(32) DEFAULT '' NOT NULL,
content mediumblob NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
ident varchar(20) DEFAULT '' NOT NULL,
PRIMARY KEY (hash)
);

try:
mysql test < error-test.sql
ERROR 1064 at line 1: You have an error in your SQL syntax. Check the manual that correspondes to your MySQL server version for the right syntax to use near 'hash varchar(32) DEFAULT '' NOT NULL,
content mediumblob NOT

(issue imported from #M34)

Actions
Copy link

Also available in: Atom PDF