Bug #60277 [NEW]: User Defined Types handlin
From:
Operating system: Linux
PHP version: 5.3.8
Package: PDO_IBM
Bug Type: Bug
Bug description:User Defined Types handlin
Description:
------------
PHP - 5.3.2 latest Ubuntu package, PDO_IBM-1.3.2
Using a PDO object to insert even the simplest UDT produced error. This
occurs
in cases when using PrepareStatements or calling query() directly. Using
the
following tutorial as an example:
http://www.ibm.com/developerworks/data/library/techarticle/dm-0506melnyk/
Executing the following produces - SQLSTATE[07001]: <<Unknown error>>:
-99999
[IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001
(SQLExecute[-99999] at /usr/share/php/PDO_IBM-1.3.2/ibm_statement.c:986)
$a = 'Some'; $b = 'Person'; $c = '21 Street'; $d = 'Some
City'; $e =
'MyState';
$f = '10101';
$stmt = $db->prepare("insert into clients (client_lname, client_fname)
values
(:1, :2, address_t() ..street(:3) ..city(:4) ..province(:5)
..postal_code(:6))");
$stmt->bindParam(':1',$e);
$stmt->bindParam(':2',$f);
$stmt->bindParam(':3',$a);
$stmt->bindParam(':4',$b);
$stmt->bindParam(':5',$c);
$stmt->bindParam(':6',$d);
The following produces - SQLSTATE[42601]: Syntax error: -104 [IBM][CLI
Driver]
[DB2/LINUX] SQL0104N
$db->query("insert into clients (client_lname, client_fname, address)
values
('Some', 'Person', address_t() ..street($c) ..city($d) ..province($e)
..postal_code($f))");
This works - but if you want to insert LOBs you really have no options:
$db->query("insert into clients (client_lname, client_fname, address)
values
('Some', 'Person', address_t() ..street('". $a ."')
..city('" .$b ."')
..province('". $c . "') ..postal_code('". $d ."'))");
Test script:
---------------
Create $db PDO connection and rung
try {
$a = 'Some'; $b = 'Person'; $c = '21 Street'; $d = 'Some
City'; $e =
'MyState'; $f = '10101';
/*
$stmt = $db->prepare("insert into clients (client_lname, client_fname)
values (:1, :2, address_t() ..street(:3) ..city(:4) ..province(:5)
..postal_code(:6))");
$stmt->bindParam(':1',$a);
$stmt->bindParam(':2',$b);
$stmt->bindParam(':3',$c);
$stmt->bindParam(':4',$d);
$stmt->bindParam(':5',$e);
$stmt->bindParam(':6',$f);
$stmt->execute();*/
$db->query("insert into clients (client_lname, client_fname, address)
values ('Some', 'Person', address_t() ..street($c) ..city($d)
..province($e) ..postal_code($f))");
#$db->query("insert into clients (client_lname, client_fname, address)
values ('Some', 'Person', address_t() ..street('". $a ."')
..city('" .$b
."') ..province('". $c . "') ..postal_code('". $d
."'))");
} catch (PDOException $e) {
print $e->getMessage() . "\n";
}
Expected result:
----------------
Named or unnamed placeholders should be bound properly and inserted.
Actual result:
--------------
See errors above
--
Edit bug report at https://bugs.php.net/bug.php?id=60277&edit=1
--
Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=60277&r=trysnapshot54
Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=60277&r=trysnapshot53
Try a snapshot (trunk): https://bugs.php.net/fix.php?id=60277&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=60277&r=fixed
Fixed in SVN and need be documented: https://bugs.php.net/fix.php?id=60277&r=needdocs
Fixed in release: https://bugs.php.net/fix.php?id=60277&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=60277&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=60277&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=60277&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=60277&r=support
Expected behavior: https://bugs.php.net/fix.php?id=60277&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=60277&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=60277&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=60277&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=60277&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=60277&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=60277&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=60277&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=60277&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=60277&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=60277&r=mysqlcfg
Thread (2 messages)
- ash at inode dot me