php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #37674 exception not thrown in multi_query's
Submitted: 2006-06-02 09:55 UTC Modified: 2008-11-10 01:00 UTC
Votes:4
Avg. Score:4.8 ± 0.4
Reproduced:4 of 4 (100.0%)
Same Version:1 (25.0%)
Same OS:1 (25.0%)
From: camka at email dot ee Assigned: andrey (profile)
Status: No Feedback Package: MySQLi related
PHP Version: 5.1.4 OS: Windows XP
Private report: No CVE-ID: None
 [2006-06-02 09:55 UTC] camka at email dot ee
Description:
------------
When trying to execute multiple queryes with multi_query method, when first query is ok, and second one is broken, the exception is not thrown when iterating second function's resultset of the multiquery. Only ::error is set.

Reproduce code:
---------------
<?php
mysqli_report( MYSQLI_REPORT_STRICT | MYSQLI_REPORT_ERROR );

try
{
	$m = new mysqli('**', '**', '**', '**');
	$m->multi_query('select 1; bug;');
	do {

       /* store first result set */
       if ($result = $m->store_result())
       {
           while ($row = $result->fetch_row())
           {
               printf("%s\n", $row[0]);
           }
           $result->close();
       }
       /* print divider */
       if ($m->more_results()) {
           printf("-----------------\n");
       }
   }
   while ($m->next_result());
   echo $m->error;
}
catch (mysqli_sql_exception  $e)
{
	var_dump($e);
}




Expected result:
----------------
1 ----------------- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'bug' at line 1

Actual result:
--------------
1 ----------------- 
object(mysqli_sql_exception)[2]
  protected 'message' => 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &apos;bug; bug&apos; at line 1' (length=154)
  private 'string' => '' (length=0)
  protected 'code' => 1064
  protected 'file' => '**' (length=35)
  protected 'line' => 7
  private 'trace' => 
    array
      0 => 
        array
          'file' => '**' (length=35)
          'line' => 7
          'function' => 'multi_query' (length=11)
          'class' => 'mysqli' (length=6)
          'type' => '->' (length=2)
          'args' => 
            array
              0 => 'bug; bug;' (length=9)
  protected 'sqlstate' => '42000' (length=5)



Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-06-02 09:56 UTC] camka at email dot ee
Sorry. Expected and actual results are mixed.
 [2006-06-05 07:21 UTC] camka at email dot ee
Same problem with latest cvs snapshot.
 [2006-06-26 11:03 UTC] camka at email dot ee
any hope the issue is on the way to be solved?
 [2008-07-21 18:27 UTC] andrey@php.net
Reassigning
 [2008-11-02 12:36 UTC] jani@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows:

  http://windows.php.net/snapshots/


 [2008-11-10 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 21 12:01:31 2024 UTC