#27203 [Fbk-Csd]: 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: Closed Bug Type: OCI8 related Operating System: RedHat 9.0 PHP Version: 4.3.4 New Comment: Closing. As cjbj at hotmail dot com states: The HIDE column was found as an other column in the same query, thus being a problem (not a bug) with the way the assoc arrays handles multiple columns with same name. Sorry if I didn' report this with enough data for you to study. Will this be implemented in a better way later? Previous Comments: [2004-02-10 21:13:19] cjbj at hotmail dot com With respect to the filer, (i) this bug contains no reproducible PHP code (ii) no table descriptions (iii) no sample data. However from looking at the very little information available, the data at http://www.starshipping.com/~jakobbg/datafound.txt shows both a HIDE column and a TYGGEGUMMI column. The HIDE column in datalacking.txt has the same data as the datafound.txt HIDE column. The datalacking.txt results are probably due to selecting two columns called HIDE from two tables e.g. as t1.hide and t2.hide. When doing this and using associative arrays, only one column is returned by PHP. There are a couple of recent user comments in http://www.php.net/manual/en/function.ocifetchinto.php talking about this. The solution I added there recently is to use column aliases. Given how PHP associative arrays do not include a table name qualifier, I'd say this isn't a bug. [2004-02-10 17:54:22] [EMAIL PROTECTED] Nobody is asking you to _install_ the snapshot, you can just as easily run the script with CLI..do NOT touch this report before you're giving the asked feedback. [2004-02-10 09:24:02] jakob at grimstveit dot no 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 :-) [2004-02-10 08:04:23] [EMAIL PROTECTED] 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. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/27203 -- Edit this bug report at http://bugs.php.net/?id=27203edit=1
#27203 [NEW]: Querying database columns with name HIDE fails to get data
From: jakob at grimstveit dot no Operating system: RedHat 9.0 PHP version: 4.3.4 PHP Bug Type: OCI8 related Bug description: Querying database columns with name HIDE fails to get data Description: When running this query it gives 10 NULL values out of 12 rows, while in SQLplusTora 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 bug report at http://bugs.php.net/?id=27203edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=27203r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=27203r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=27203r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=27203r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=27203r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=27203r=needscript Try newer version: http://bugs.php.net/fix.php?id=27203r=oldversion Not developer issue:http://bugs.php.net/fix.php?id=27203r=support Expected behavior: http://bugs.php.net/fix.php?id=27203r=notwrong Not enough info:http://bugs.php.net/fix.php?id=27203r=notenoughinfo Submitted twice:http://bugs.php.net/fix.php?id=27203r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=27203r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=27203r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=27203r=dst IIS Stability: http://bugs.php.net/fix.php?id=27203r=isapi Install GNU Sed:http://bugs.php.net/fix.php?id=27203r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=27203r=float
#27203 [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: Open Bug Type: OCI8 related Operating System: RedHat 9.0 PHP Version: 4.3.4 New Comment: About Reproduce code: Actual SQL is shown in URL's described in Actual result area. Sorry about that. Previous Comments: [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 SQLplusTora 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=27203edit=1
#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] [EMAIL PROTECTED] 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 SQLplusTora 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=27203edit=1
