Fields are not quoted during Insert for Mysql #518

Closed
Kitof opened this Issue Jan 10, 2014 · 4 comments

Projects

None yet

2 participants

@Kitof
Kitof commented Jan 10, 2014

In one of my table, I've got a field named 'regexp' (I know, it's bad).

As REGEXP is a reserved word in Mysql, Insert queries failed.

Apparently fields aren't backticked during insert.

Kitof commented Jan 10, 2014

I think it's related to #323

Owner
marcj commented Apr 11, 2014

Have you tried to enable --enable-identifier-quoting in the model:build command?

Owner
marcj commented Aug 1, 2014

Closing due to no response and no confirmation of a bug.

@marcj marcj closed this Aug 1, 2014
@mpscholten mpscholten added a commit to mpscholten/Propel2 that referenced this issue Aug 24, 2014
@marcj @mpscholten marcj + mpscholten Fixed relation handling. Fixed #473, #518, #262.
Fixed bug: crossTable with at least one FK with multiple local columns
Fixed bug: crossTable with more than two FKs
Fixed bug: crossTable with two PK-FK and one PK-nonFK
Fixed bug: crossTable: setRelations(Collection),
removeRelation($rel), save() doesn’t remove $rel.
Added Partial-checking also to CrossFK getter.
Fixed bug: wrong "if ($obj->isNew())” check in getRelation() methods.
Improved performance of hashCode.
Improved ObjectCollection checks
Modified clearAllReferences as in PHP 5.4 there's no workaround like
that necessary anymore.
Fixed internal object relation reference tracking, especially
unlinking back-references.

Added also the table rename fix for #477, so we do not rename tables
anymore. This was necessary because otherwise with this new incoming
tests for relations the test suite won't be green.
f2be2d3
Kitof commented Mar 25, 2015

--enable-identifier-quoting in the model:build doesn't work.
propel.disableIdentifierQuoting = false in the buid.properties doesn't work.
but
identifierQuoting="true" in the schema.xml works !

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment