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

From: Date: Tue, 10 Feb 2004 13:04:23 +0000
Subject: #27203 [Opn->Fbk]: Querying database columns with name HIDE fails to get data
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-54685@lists.php.net to get a copy of this message 
 ID:               27203
 Updated by:       sniper@php.net
 Reported By:      jakob at grimstveit dot no
-Status:           Open
+Status:           Feedback
 Bug Type:         OCI8 related
 Operating System: RedHat 9.0
 PHP Version:      4.3.4
 New Comment:

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




Previous Comments:
------------------------------------------------------------------------

[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

Thread (7 messages)

« previous php.bugs (#54685) next »