Package: php-db
Version: 1.7.6-2
Severity: Important
Greetings,
DECLARE/FETCH doesn't work in PHP-DB because it is foolishly assumed
that only 'select', 'explain' and 'show' return records. This is
certainly not the case as 'fetch' (like, from a cursor) can also
return rows. The way to fix this is pretty straight-forward:
/usr/share/php/db/pgsql.php, line 1097:
} elseif (preg_match('/^\s*\(*\s*(SELECT|EXPLAIN|SHOW)\s/si', $query)) {
changes to:
} elseif (preg_match('/^\s*\(*\s*(SELECT|EXPLAIN|SHOW|FETCH)\s/si', $query)) {
Please to be fixing.
Thanks,
Stephen
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
