#35337 [NoF->Csd]: prepare update into longtext column broken
| From: | bill dot finn at sellingsource dot com | Date: | Sat, 03 Dec 2005 00:03:51 +0000 |
| Subject: | #35337 [NoF->Csd]: prepare update into longtext column broken | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-89661@lists.php.net to get a copy of this message | ||
ID: 35337
User updated by: bill dot finn at sellingsource dot com
Reported By: bill dot finn at sellingsource dot com
-Status: No Feedback
+Status: Closed
Bug Type: MySQLi related
Operating System: Gentoo 2.6.9
PHP Version: 6CVS-2005-11-19 (snap)
New Comment:
tested with 2005-11-29, works.
Previous Comments:
------------------------------------------------------------------------
[2005-11-30 01:00:10] 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".
------------------------------------------------------------------------
[2005-11-22 22:31:31] tony2001@php.net
Please try using this CVS snapshot:
http://snaps.php.net/php5-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5-win32-latest.zip
------------------------------------------------------------------------
[2005-11-22 19:43:44] bill dot finn at sellingsource dot com
Description:
------------
Performing an update into a non-null longtext column using prepare
syntax. Example code works in php 5.0.x. Upgraded to 5.1.x and it
started entering variations of empty strings, 0, or 0000-00-00
depending on how much data I was trying to enter. In a test that
allows null values, it enters null.
(mysql 5.0.13 && mysql 5.0.15)
Reproduce code:
---------------
CREATE TABLE test (col1 longtext not null);
<?php
$data = "whatever, some string";
$mysqli = new mysqli( HOST, USER, PASS, DB, PORT );
$query = "INSERT INTO test SET col1 = ?";
$prepared = $mysqli->prepare( $query );
$prepared->bind_param('s', $data );
$prepared->execute();
$prepared->close();
?>
Expected result:
----------------
contents of $data inserted into col1 of table.
Actual result:
--------------
SELECT col1 FROM test
shows one of three things:
0000-00-00
0
empty string
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=35337&edit=1