php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #59156 bind NULL Values to DATE columns does not work
Submitted: 2010-04-13 08:06 UTC Modified: 2011-09-02 04:59 UTC
From: christoph dot lukas at gmx dot net Assigned:
Status: Closed Package: PDO_IBM (PECL)
PHP Version: 5.2.13 OS: Linux CentOS 5.4
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: christoph dot lukas at gmx dot net
New email:
PHP Version: OS:

 

 [2010-04-13 08:06 UTC] christoph dot lukas at gmx dot net 
Description:
------------
DB2-Client: 9.7
Informix Dynamic Server: 11.50

Trying to insert a row into a simple table which should contain null for a DATE column fails using dynamic SQL.


Reproduce code:
---------------
    /**
    CREATE TABLE test
    (
        id SERIAL NOT NULL,
        text VARCHAR(20),
        date DATE,
        PRIMARY KEY (id)
    )
     */
    $dbh = new PDO("ibm:test");
    $sql = 'INSERT INTO test (ID, TEXT, DATE) VALUES (1, "foobar", null)'; 
    $stmt = $dbh->query($sql);
    var_dump($stmt->errorInfo());
    
    $sql = 'INSERT INTO test (ID, TEXT, DATE) VALUES (?, ?, ?)'; 
    $stmt = $dbh->prepare($sql);
    $stmt->bindValue(1, 2, PDO::PARAM_INT);
    $stmt->bindValue(2, "foobar", PDO::PARAM_STR);
    $stmt->bindValue(3, null, PDO::PARAM_STR);
    $result = $stmt->execute();
    var_dump($stmt->errorInfo());


Expected result:
----------------
Expected that two rows are inserted.

Expected Output:

array(3) {
  [0]=>
  string(5) "00000"
  [1]=>
  int(0)
  [2]=>
  string(24) " ((null)[0] at (null):0)"
}
array(3) {
  [0]=>
  string(5) "00000"
  [1]=>
  int(0)
  [2]=>
  string(24) " ((null)[0] at (null):0)"
}


Actual result:
--------------
The first row is inserted correctly while the second insert fails:

array(3) {
  [0]=>
  string(5) "00000"
  [1]=>
  int(0)
  [2]=>
  string(24) " ((null)[0] at (null):0)"
}
array(3) {
  [0]=>
  string(5) "07001"
  [1]=>
  int(-99999)
  [2]=>
  string(150) "[IBM][CLI Driver] CLI0100E  Wrong number of parameters. SQLSTATE=07001 (SQLExecute[-99999] at /usr/src/redhat/BUILD/PDO_IBM-1.3.2/ibm_statement.c:986)"
}

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2010-04-19 04:18 UTC] abhargav at in dot ibm dot com 
Hi,

I will analyze the issue and will update you.

Regards,
Ambrish Bhargava
 [2010-11-30 04:27 UTC] abhargav at in dot ibm dot com 
Hi,

Here is the patch for this bug. I will include this in future release:

566,573c566,592
< 				rc = SQLBindParameter(stmt_res->hstmt, curr->paramno + 1,
< 						inputOutputType, param_res->ctype,
< 						param_res->data_type,
< 						param_res->param_size,
< 						param_res->scale,
< 						&((curr->parameter)->value.lval),
< 						curr->max_value_len,
< 						&param_res->transfer_length);
---
> 				switch(param_res->data_type) {
> 					case SQL_TYPE_DATE:
> 					case SQL_DATETIME:
> 					case SQL_TYPE_TIME:
> 					case SQL_TYPE_TIMESTAMP:
> 						param_res->transfer_length = SQL_NULL_DATA;
> 						param_res->ctype = SQL_C_CHAR;
> 						rc = SQLBindParameter(stmt_res->hstmt, curr->paramno + 1,
> 								inputOutputType, param_res->ctype,
> 								param_res->data_type,
> 								param_res->param_size,
> 								param_res->scale, NULL,
> 								curr->max_value_len <=
> 								0 ? 0 : curr->max_value_len,
> 								&param_res->transfer_length);
> 						break;
> 
> 					default:
> 						rc = SQLBindParameter(stmt_res->hstmt, curr->paramno + 1,
> 								inputOutputType, param_res->ctype,
> 								param_res->data_type,
> 								param_res->param_size,
> 								param_res->scale,
> 								&((curr->parameter)->value.lval),
> 								curr->max_value_len,
> 								&param_res->transfer_length);
> 				}
585a605
> 


Regards,
Ambrish Bhargava
 [2011-09-02 04:59 UTC] abhargav at in dot ibm dot com 
This bug has been fixed in SVN.

In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on pecl.php.net.

In case this was a pecl.php.net website problem, the change will show
up on the website in short time.
 
Thank you for the report, and for helping us make PECL better.

Hi,

This is fixed in SVN.

Regards,
Ambrish Bhargava
 
PHP Copyright © 2001-2023 The PHP Group
All rights reserved. 		Last updated: Sat Sep 30 16:01:24 2023 UTC