Bug #33639

Error in mySQL Statements with columnnames like "from" or "char"

Added by Jan Roth over 9 years ago. Updated over 9 years ago.

Status:
Rejected
Priority:
Won't have this time
Category:
Persistence
Target version:
-
Start date:
2012-02-02
Due date:
% Done:

0%

Estimated time:
PHP Version:
Has patch:
No
Complexity:

Description

The mySQL Statements must be escaped with `columnname`

SQLSTATE42000: Syntax error or access violation: 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 'from VARCHAR DEFAULT NULL, PRIMARY KEY) ENGIN' at line 1


Related issues

Has duplicate TYPO3.Flow - Bug #34864: inproper escape of attribute namesRejectedKarsten Dambekalns2012-03-14

Actions
#1

Updated by Karsten Dambekalns over 9 years ago

  • Category set to Persistence
  • Status changed from New to Rejected
  • Assignee set to Karsten Dambekalns
  • Priority changed from Must have to Won't have this time

As per the recommendations in Doctrine 2, no automatic quoting is done. You are advised to not use reserved words as column names. If needed you can add a Column annotation and provide a different column name for a property.

Also available in: Atom PDF