|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
Patchesodbc_diff.txt (last revision 2015-04-27 13:39 UTC by einavitamar at gmail dot com)Pull RequestsHistoryAllCommentsChangesGit/SVN commits
[2015-04-28 13:46 UTC] ab@php.net
-Status: Open
+Status: Feedback
-Assigned To:
+Assigned To: ab
[2015-04-28 13:46 UTC] ab@php.net
[2015-05-04 10:31 UTC] einavitamar at gmail dot com
-Status: Feedback
+Status: Assigned
[2015-05-04 10:31 UTC] einavitamar at gmail dot com
[2016-02-24 07:58 UTC] ab@php.net
[2016-02-24 11:13 UTC] ab@php.net
-Status: Assigned
+Status: Closed
[2016-02-24 11:13 UTC] ab@php.net
[2016-02-24 12:50 UTC] einavitamar at gmail dot com
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Oct 26 19:00:01 2025 UTC |
Description: ------------ After odbc_prepare, when executing odbc_execute more than once, it fails starting the second time. It happens only in drivers that does not allow SQLDescribeParam to be called on a statement after its execution. By looking at the php odbc code, the reason is that SQLDescribeParam is called in odbc_execute instead of in odbc_prepare. It should be called only once per bound parameter, and it does not depend on the parameter value itself, so it should be called in odbc_prepare. This failure happens when using odbc both in TeraData and in Vertica. This failure happens only if there is parameter binding (for statements without variables it does not happen). The test script is for TeraData driver under windows. Test script: --------------- $conn = odbc_connect("driver={Teradata};DBCName=127.0.0.1;PortNumber=1025;DATABASE=dbname;",'user', 'pwd'); $sql = "SELECT * FROM einav where a >= ?;"; $stmt = odbc_prepare($conn,$sql); $params = array("abc"); odbc_execute($stmt,$params); odbc_result_all($stmt); odbc_execute($stmt,$params); odbc_result_all($stmt); Expected result: ---------------- Expected result: <table><tr><th>a</th></tr> <tr><td>abc</td></tr> <tr><td>cde</td></tr> </table> <table><tr><th>a</th></tr> <tr><td>abc</td></tr> <tr><td>cde</td></tr> </table> Actual result: -------------- <table><tr><th>a</th></tr> <tr><td>abc</td></tr> <tr><td>cde</td></tr> </table> PHP Warning: odbc_execute(): SQL error: [Teradata][ODBC Teradata Driver] Functi on Sequence Error, SQL state S1010 in SQLDescribeParameter in C:\Users\einav.000 \b.php on line 37 <h2>No rows found</h2>