note 115380 added to function.mysql-field-table

This note may apply to anyone who might still be running MySQL 5.0.32 on Debian 4.0. The mysql_field_table function may return an empty table name if the SELECT query involved uses GROUP BY or ORDER BY and references a view in the FROM clause. This is caused by MySQL bug 28898, which was fixed in 5.0.46. I encountered this when I noticed a difference between our production RSS feeds generated on a Debian 5.0.10 server running MySQL 5.0.51a, and the same feed generated on one of our test servers running MySQL 5.0.32 on Debian 4.0. ---- Server IP: 216.194.115.244 Probable Submitter: 198.7.225.122 ---- Manual Page -- http://php.net/manual/en/function.mysql-field-table.php Edit -- https://master.php.net/note/edit/115380 Del: integrated -- https://master.php.net/note/delete/115380/integrated Del: useless -- https://master.php.net/note/delete/115380/useless Del: bad code -- https://master.php.net/note/delete/115380/bad+code Del: spam -- https://master.php.net/note/delete/115380/spam Del: non-english -- https://master.php.net/note/delete/115380/non-english Del: in docs -- https://master.php.net/note/delete/115380/in+docs Del: other reasons-- https://master.php.net/note/delete/115380 Reject -- https://master.php.net/note/reject/115380 Search -- https://master.php.net/manage/user-notes.php