php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #40198 Column name is not double quoted
Submitted: 2007-01-22 18:53 UTC Modified: 2007-11-26 01:00 UTC
Votes:2
Avg. Score:5.0 ± 0.0
Reproduced:2 of 2 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: chores at jp1 dot cx Assigned: yohgaki (profile)
Status: No Feedback Package: PostgreSQL related
PHP Version: 5.2.4 OS: FreeBSD 6.2
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: chores at jp1 dot cx
New email:
PHP Version: OS:

 

 [2007-01-22 18:53 UTC] chores at jp1 dot cx
Description:
------------
Column name is not double quoted

% psql -U testuser testdb
testdb=# CREATE TABLE t_test ("c1" char(10), "C2" char(10));
testdb=# \q

% ./test.php
INSERT INTO t_test (c1,C2) VALUES ('0','0');

% psql -U testuser testdb
testdb=# INSERT INTO t_test (c1,C2) VALUES ('0','0');
ERROR:  column "c2" of relation "t_test" does not exist

Reproduce code:
---------------
(test.php)
#!/usr/local/bin/php
<?php
$db = pg_connect('dbname=testdb user=testuser');
$vals['c1'] = '0';
$vals['C2'] = '0';
echo pg_insert($db, 't_test', $vals, PGSQL_DML_STRING);
?>

Expected result:
----------------
INSERT INTO t_test (c1,"C2") VALUES ('0','0');

Actual result:
--------------
INSERT INTO t_test (c1,C2) VALUES ('0','0');

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2007-01-23 00:26 UTC] chores at jp1 dot cx
Expected result (Correction):
-----------------------------
INSERT INTO "t_test" ("c1","C2") VALUES ('0','0');
 [2007-11-17 06:02 UTC] chores at jp1 dot cx
non-fix v5.2.4
 [2007-11-18 23:48 UTC] jani@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows (zip):
 
  http://snaps.php.net/win32/php5.2-win32-latest.zip

For Windows (installer):

  http://snaps.php.net/win32/php5.2-win32-installer-latest.msi

Really, try the snapshot..
 [2007-11-26 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Dec 27 11:01:30 2024 UTC