ID: 27203 Comment by: cjbj at hotmail dot com Reported By: jakob at grimstveit dot no Status: Feedback Bug Type: OCI8 related Operating System: RedHat 9.0 PHP Version: 4.3.4 New Comment:
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. Previous Comments: ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ [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
