PHP 4.0 Bug #10121: Case Sensitive Associative Arrays
| From: | dranor at dracon dot net | Date: | Mon, 02 Apr 2001 20:11:52 +0000 |
| Subject: | PHP 4.0 Bug #10121: Case Sensitive Associative Arrays | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-50618@lists.php.net to get a copy of this message | ||
From: dranor@dracon.net
Operating system: Redhat Linux 7.0
PHP version: 4.0.4pl1
PHP Bug Type: PostgreSQL related
Bug description: Case Sensitive Associative Arrays
The scenario is described here:
mydb=> CREATE TABLE test ( U_Name char(50), U_Pass char(16) );
mydb=> INSERT INTO test values ('Bob', 'password');
query.php:
<?
$conn = pg_connect("dbname=mydb");
$result = pg_exec($conn, "select U_Name, U_Pass from test")
$arr = pg_fetch_array($result, 0);
echo "U_Name: " + $arr[U_Name] + " U_Pass: " + $arr[U_Pass] +
"<BR>";
echo "u_name: " + $arr[u_name] + " u_pass: " + $arr[u_pass] +
"<BR>";
?>
results that are printed:U_Name: U_Pass:
u_name: Bob u_pass: password
( arr[0] = Bob, arr[1] = password)
U_Name is not being automatically lowercased when using associative arrays. As of v6.1 PostgreSQL
lowercases all table names as well as all columns. So searching on mixed case or uppercase names
will not work unless they are enclosed in quotes..
--
Edit Bug report at: http://bugs.php.net/?id=10121&edit=1