[TORQUE-307] Qualified update columns do not work with Postgresql

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.0
• Fix Version/s: 5.0
• Component/s: Runtime
• Environment: postgresql 9.1.5
• Assignee: Thomas Fox
• Reporter: Thomas Fox
• Created: 15/Dec/13 13:05
• Updated: 04/Jan/14 20:57
• Resolved: 04/Jan/14 20:57

Description

In the current trunk, updates result in SQL like
UPDATE author SET author.name='NewName2' WHERE author.author_id=31147;

Note the qualified column name after the SET keyword

This does not work with postgreql. in postgresql, the update column name needs to be unqualified, like

UPDATE author SET name='NewName2' WHERE author.author_id=31147