IssuewiththeReservedTermHOSTSinSystemConfiguration

select * from hosts as h where h.hostid=10012
this works and return a result,

but

select * from hosts h where h.hostid=10012
does not return anything.

with the second syntax, pma is sending a correct query to mysqld:
"select SQL_CALC_FOUND_ROWS * from hosts h where h.hostid =10012 LIMIT 1;"

(tested with mysql 5.0.32, pma 2.11.5/2.11.4)

• Original URL: "https://sourceforge.net/p/phpmyadmin/bugs/2649/":https://sourceforge.net/p/phpmyadmin/bugs/2649/


• Original author: lordgun


• Found in version: 2.11.5

该提问来源于开源项目：phpmyadmin/phpmyadmin