#27203 [NEW]: Querying database columns with name HIDE fails to get data

From: Date: Tue, 10 Feb 2004 10:06:52 +0000
Subject: #27203 [NEW]: Querying database columns with name HIDE fails to get data
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-54671@lists.php.net to get a copy of this message 
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
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 bug report at http://bugs.php.net/?id=27203&edit=1
-- 
Try a CVS snapshot (php4):  http://bugs.php.net/fix.php?id=27203&r=trysnapshot4
Try a CVS snapshot (php5):  http://bugs.php.net/fix.php?id=27203&r=trysnapshot5
Fixed in CVS:               http://bugs.php.net/fix.php?id=27203&r=fixedcvs
Fixed in release:           http://bugs.php.net/fix.php?id=27203&r=alreadyfixed
Need backtrace:             http://bugs.php.net/fix.php?id=27203&r=needtrace
Need Reproduce Script:      http://bugs.php.net/fix.php?id=27203&r=needscript
Try newer version:          http://bugs.php.net/fix.php?id=27203&r=oldversion
Not developer issue:        http://bugs.php.net/fix.php?id=27203&r=support
Expected behavior:          http://bugs.php.net/fix.php?id=27203&r=notwrong
Not enough info:            http://bugs.php.net/fix.php?id=27203&r=notenoughinfo
Submitted twice:            http://bugs.php.net/fix.php?id=27203&r=submittedtwice
register_globals:           http://bugs.php.net/fix.php?id=27203&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=27203&r=php3
Daylight Savings:           http://bugs.php.net/fix.php?id=27203&r=dst
IIS Stability:              http://bugs.php.net/fix.php?id=27203&r=isapi
Install GNU Sed:            http://bugs.php.net/fix.php?id=27203&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=27203&r=float

Thread (7 messages)

« previous php.bugs (#54671) next »