php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #77986 Extra error
Submitted: 2019-05-07 20:42 UTC Modified: 2019-05-07 22:01 UTC
From: v-altruo at microsoft dot com Assigned: cmb (profile)
Status: Closed Package: Testing related
PHP Version: 7.3.5 OS: Windows
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: v-altruo at microsoft dot com
New email:
PHP Version: OS:

 

 [2019-05-07 20:42 UTC] v-altruo at microsoft dot com 
Description:
------------
Fails across all builds. There's just 1 extra line about expecting 0 (The [020] line). 

MySQL version: 5.7.25

Test file location: ext\pdo_mysql\tests\pdo_mysql_exec.phpt

Expected result:
----------------
Warning: PDO::exec(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your %s server version for the right syntax to use near 'THIS IS NOT VALID SQL, I HOPE' at line 1 in %s on line %d
[016] [42000] 42000 1064 You have an error in your SQL syntax; check the manual that corresponds to your %s server version for the right syntax to use near 'THIS IS NOT VALID SQL, I HOPE' at line %d
[035] With emulated PS it works but makes no sense given that exec() returns sort of affected rows...
done!

Actual result:
--------------
Warning: PDO::exec(): SQLSTATE[42000]: Syntax error or access violation: 1064 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 'THIS IS NOT VALID SQL, I HOPE' at line 1 in ... on line 6
[016] [42000] 42000 1064 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 'THIS IS NOT VALID SQL, I HOPE' at line 1
[020] Expecting '0'/integer got '1'/integer when running 'CALL p(@version)', [00000] 00000  
[035] With emulated PS it works but makes no sense given that exec() returns sort of affected rows...
done!

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2019-05-07 22:01 UTC] cmb@php.net
-Status: Open +Status: Closed -Assigned To: +Assigned To: cmb
 [2019-05-07 22:01 UTC] cmb@php.net 
Thanks for reporting!  This issue has recently been addressed[1];
the fixed test case will be shipped with the next PHP releases.

[1] <https://github.com/php/php-src/commit/fc9cdb723bcd02dfdb83962ca1eda57ec4c10296>
 
PHP Copyright © 2001-2026 The PHP Group
All rights reserved. 		Last updated: Fri Jan 02 07:00:01 2026 UTC