|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
Patchesphp5-bug64937.patch (last revision 2013-05-30 14:50 UTC by slavb18 at gmail dot com)Pull RequestsHistoryAllCommentsChangesGit/SVN commits
[2013-05-28 13:52 UTC] slavb18 at gmail dot com
[2013-05-30 14:52 UTC] slavb18 at gmail dot com
[2014-01-01 12:32 UTC] felipe@php.net
-Package: PDO related
+Package: PDO Firebird
[2014-04-08 11:19 UTC] mariuz@php.net
-Assigned To:
+Assigned To: mariuz
[2017-10-24 06:45 UTC] kalle@php.net
-Status: Assigned
+Status: Open
-Assigned To: mariuz
+Assigned To:
[2017-12-04 11:03 UTC] valentin at microtec dot fr
[2017-12-14 13:22 UTC] funtech dot n at gmail dot com
[2019-11-26 19:51 UTC] sim-mail at list dot ru
[2020-09-24 22:08 UTC] cmb@php.net
[2020-09-24 22:08 UTC] cmb@php.net
-Status: Open
+Status: Closed
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Oct 25 07:00:02 2025 UTC |
Description: ------------ Unable to run firebird unparametrized "execute block", containing :xxxx if query contains string like ":xxxx", pdo->query shows error SQLSTATE[HY000]: General error: -901 Dynamic SQL Error SQL error code = -901 undefined message number if I remove "where 1=:test", then execute block works And, also I cannot prepare and execute "paramerized" execute block if it contains :xxxxx Execute Block ( test integer=:test ) Returns( result varchar(100) ) as Begin select 'test' from rdb$database where 1=:test into result; Suspend; End I think solution is to ignore any parameters (:xxx) after Begin keyword in case of firebird Test script: --------------- $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); Expected result: ---------------- Array ( [RESULT] => test ) Actual result: -------------- SQLSTATE[HY000]: General error: -901 Dynamic SQL Error SQL error code = -901 undefined message number