You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
$select = " SELECT tbl.{$ancestor} AS ancestor, ? AS descendant, tbl.{$depth}+1 AS depth FROM {$table} AS tbl WHERE tbl.{$descendant} = ? UNION ALL SELECT ? AS ancestor, ? AS descendant, 0 AS depth";
This will break SQL queries in case of non-standard column names are used. The above should be changed to the below:
$select = " SELECT tbl.{$ancestor} AS {$ancestor}, ? AS {$descendant}, tbl.{$depth}+1 AS {$depth} FROM {$table} AS tbl WHERE tbl.{$descendant} = ? UNION ALL SELECT ? AS {$ancestor}, ? AS {$descendant}, 0 AS {$depth}";
The text was updated successfully, but these errors were encountered:
Originally reported by @devig in #234.
ClosureTable::selectRowsToInsert()
uses hardcoded table column names:This will break SQL queries in case of non-standard column names are used. The above should be changed to the below:
The text was updated successfully, but these errors were encountered: