#27203 [Fbk->Opn]: Querying database columns with name HIDE fails to get data

ID: 27203 User updated by: jakob at grimstveit dot no Reported By: jakob at grimstveit dot no -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: RedHat 9.0 PHP Version: 4.3.4 New Comment: Will do this as soon as possible. Creating a SuSE9 vmware installation and will compile apache and php with same options as on the rhl9-box used here. Can't deploy into same place since this is a prod-server :-) Previous Comments: ------------------------------------------------------------------------ [2004-02-10 08:04:23] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip ------------------------------------------------------------------------ [2004-02-10 05:09:58] jakob at grimstveit dot no About "Reproduce code": Actual SQL is shown in URL's described in "Actual result" area. Sorry about that. ------------------------------------------------------------------------ [2004-02-10 05:06:52] jakob at grimstveit dot no Description: ------------ When running this query it gives 10 NULL values out of 12 rows, while in SQLplus&Tora it gives me the value actually found in the database for all rows. When renaming column to something random in the query, the data gets through to PHP, thus I guess it's related to the HIDE column being a keyword of some kind. Reproduce code: --------------- $query = "select hide from something" Expected result: ---------------- A complete resultset Actual result: -------------- A resultset lacking values in the column named HIDE in 10 out of 12 rows. See http://www.starshipping.com/~jakobbg/datafound.txt (correct resultset with sql row renamed to tyggegummi and http://www.starshipping.com/~jakobbg/datalacking.txt with original buggy resultset. Data ($result) printed with print_r() Hope this will be fixed soon. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=27203&edit=1