Bug #79294 [Com]: ::columnType() may fail after SQLite3Stmt::reset()
Edit report at https://bugs.php.net/bug.php?id=79294&edit=1
ID: 79294
Comment by: david at grudl dot com
Reported by: cmb@php.net
Summary: ::columnType() may fail after SQLite3Stmt::reset()
Status: Closed
Type: Bug
Package: SQLite related
Operating System: *
PHP Version: 7.3Git-2020-02-21 (Git)
Assigned To: cmb
Block user comment: N
Private report: N
New Comment:
I think this fix caused a problem, and columnType() returns FALSE when it did not do before.
Previous Comments:
------------------------------------------------------------------------
[2020-02-21 12:41:55] cmb@php.net
Automatic comment on behalf of cmbecker69@gmx.de
Revision: http://git.php.net/?p=php-src.git;a=commit;h=f133f0024ec801dc9636ee5bf84a93de1300d4b2
Log: Fix #79294: ::columnType() may fail after SQLite3Stmt::reset()
------------------------------------------------------------------------
[2020-02-21 11:13:31] cmb@php.net
Description:
------------
As expected, after an SQLite3Result has been fully processed,
SQLite3Result::columnType() returns FALSE. If the result is
reset by calling SQLite3Result::reset(), ::columnType() yields
the expected results again; however, if the statement is reset by
calling SQLite3Stmt::reset(), ::columnType() keeps returning
FALSE.
In other words, whenever SQLite3Result::fetchArray() succeeds
(i.e. does not return FALSE), I expect SQLite3Result::columType()
to succeed (i.e. not to return FALSE). However, that does not
necessarily happen after calling SQLite3Stmt::reset().
Test script:
---------------
<?php
$db = new SQLite3(':memory:');
$db->exec("CREATE TABLE foo (bar INT)");
$db->exec("INSERT INTO foo VALUES (1)");
$stmt = $db->prepare("SELECT * FROM foo");
$res = $stmt->execute();
var_dump($res->fetchArray() !== false);
var_dump($res->columnType(0));
var_dump($res->fetchArray() !== false);
var_dump($res->columnType(0));
$stmt->reset();
var_dump($res->fetchArray() !== false);
var_dump($res->columnType(0));
$res->reset();
var_dump($res->fetchArray() !== false);
var_dump($res->columnType(0));
?>
Expected result:
----------------
bool(true)
int(1)
bool(false)
bool(false)
bool(true)
int(1)
bool(true)
int(1)
Actual result:
--------------
bool(true)
int(1)
bool(false)
bool(false)
bool(true)
bool(false)
bool(true)
int(1)
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=79294&edit=1
Thread (3 messages)