<![CDATA[PunBB Forums — SQL queries issue (WHERE id= vs WHERE t.id=)]]> https://punbb.informer.com/forums/topic/29517/sql-queries-issue-where-id-vs-where-tid/ Fri, 17 Jul 2015 22:18:30 +0000 PunBB <![CDATA[SQL queries issue (WHERE id= vs WHERE t.id=)]]> https://punbb.informer.com/forums/post/154820/#p154820 Table names in FROMs and JOINs are aliased with "AS" statement in all the queries.
On the other hand, in WHEREs we have a plenty of unaliased clauses like id=some_condition (vs t.id=some_condition, where t is a table alias).

The problem is in high probability of column name indetermination when we trying to patch the query with a hook to join some extra tables. As a result we have a broken query to "debug".

Of cause we can "rewrite" the WHERE statement with aliased conditions in the same hook or patch the php code in place. But i think it's better to get all of WHEREs aliased out of the box.

]]> Fri, 17 Jul 2015 22:18:30 +0000 https://punbb.informer.com/forums/post/154820/#p154820