Bug #6193

Field IDs quoted only in insert

Details

Submitted	2005-12-08 15:55 UTC
From	i at buro dot com dot ru
Assigned	datenpunk
Status	Wont fix
Package	DB_NestedSet
PHP Version	4.3.11
OS	FC3
Roadmaps	(Not assigned)

Comments

[2005-12-08 15:55 UTC] i at buro dot com dot ru

Description:
------------
When fields are specified for tree, they can be of any words including reserved. When function createRightNode called there are 2 queries to call before insertion. So only in insert query field ids are quoted with _quoteIdentifier. On the other two update queries no changes are made (when using sprintf).
The workaround is to quote them in that very place(createRightnode), but more general solution provides analysis for field id whether it is already quoted.

[2006-01-15 20:49 UTC] datenpunk at php dot net

Implementing the quoting was a mistake at all.
It leaded to much trouble with different RDBMS which have different ways of quoting.
I recommend that users should simply not use reserved words for now.

--
Daniel Khan