Re: [PHP] help confirming a PDO_SQLITE bug
- From: fletch@xxxxxxxxx (Rick Fletcher)
- Date: Mon, 30 Oct 2006 21:03:56 -0800
Thanks to anyone who entertained my previous email, but I've solved my own problem.
It looks like the bug is in PDO_SQLITE 1.0.1. I've just compiled from that extension from CVS, changing nothing else, and the bug is gone.
--rick
Rick Fletcher wrote:
I've just upgraded to Fedora Core 6 and my personal site broke. Along with the upgrade came PHP 5.1.6 and SQLite 3.3.6. After the upgrade any SELECT returns all its values with the last character missing..
I've filed a bug at pecl.php.net (http://pecl.php.net/bugs/bug.php?id=9191), but it doesn't look as though that's reviewed very often. I need help confirming that it is a PDO or SQLite bug so that I can begin upgrading or downgrading to avoid it.
If you have matching versions of PHP and/or SQLite, can you try out the test script below and see if it's broken in the same way?
Thanks,
Rick Fletcher
Reproduce code:
---------------
<?php
$dbh = new PDO( 'sqlite::memory:' );
$dbh->query( 'CREATE TABLE "things" ( name VARCHAR NOT NULL )');
$dbh->query( 'INSERT INTO things VALUES ( "thing one" )');
foreach( $dbh->query( 'SELECT * FROM things' ) as $row ) {
print_r( $row );
}
$dbh = null;
?>
Expected result:
----------------
Array
(
[name] => thing one
[0] => thing one
)
Actual result:
--------------
Array
(
[name] => thing on
[0] => thing on
)
- References:
- help confirming a PDO_SQLITE bug
- From: Rick Fletcher
- help confirming a PDO_SQLITE bug
- Prev by Date: help confirming a PDO_SQLITE bug
- Next by Date: Re: [PHP] Decide witch table within a union
- Previous by thread: help confirming a PDO_SQLITE bug
- Next by thread: Stupid question of the day (Editing text file in $HOME via web)
- Index(es):
Relevant Pages
|
