Bug #64937 [Opn->Csd]: Unable to run firebird "execute block", containing :xxxx

Edit report at https://bugs.php.net/bug.php?id=64937&edit=1 ID: 64937 Updated by: cmb@php.net Reported by: slavb18 at gmail dot com Summary: Unable to run firebird "execute block", containing :xxxx -Status: Open +Status: Closed Type: Bug Package: PDO Firebird PHP Version: 5.4.15 Block user comment: N Private report: N New Comment: Automatic comment on behalf of sim-mail@list.ru Revision: http://git.php.net/?p=php-src.git;a=commit;h=17a789e27c31ca13ba4bab6fcfc265d2dd0589a2 Log: Fix #64937: Firebird PDO preprocessing sql Previous Comments: ------------------------------------------------------------------------ [2019-11-26 19:51:20] sim-mail at list dot ru I wrote a patch to solve these problems. The SQL preprocessing code has been ported from Firebird to handle EXECUTE STATEMENT. Both EXECUTE BLOCK work with parameters and skipping parameter markers in comments have been resolved. https://github.com/php/php-src/pull/4920 Unfortunately, there are no people who can check my code. ------------------------------------------------------------------------ [2017-12-14 13:22:27] funtech dot n at gmail dot com Parameter parser in the driver is very simple, and can be tricked by quote symbol inside a comment: $q="Execute Block Returns( result varchar(100) ) as declare variable test integer=1; Begin /*'*/ select 'test' from rdb\$database where 1=:test into result; Suspend; End "; $sth=$pdo->query($q); $row=$sth->fetch(PDO::FETCH_ASSOC); ------------------------------------------------------------------------ [2017-12-04 11:03:58] valentin at microtec dot fr Never fix ? ------------------------------------------------------------------------ [2013-05-30 14:52:17] slavb18 at gmail dot com patched version opensuse build service project: https://build.opensuse.org/package/show?package=php5&project=home%3Aslavb18%3Abranches%3Adevel%3Alanguages%3Aphp rpms: http://download.opensuse.org/repositories/home:/slavb18:/branches:/devel:/languages:/php/openSUSE_12.3/ ------------------------------------------------------------------------ [2013-05-28 13:52:57] slavb18 at gmail dot com don't know if it helps, but this is working example with parametrized execute block with ibase_XXX functions $conn=ibase_connect($base, $user,$pass); $q="Execute Block ( test integer=? ) Returns( result varchar(100) ) as Begin select 'test' from rdb\$database where 1=:test into result; Suspend; End "; $qu= ibase_prepare($conn,$q); $r_sql = ibase_execute($qu,1); $row=ibase_fetch_assoc($r_sql); print_r($row); ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=64937 -- Edit this bug report at https://bugs.php.net/bug.php?id=64937&edit=1