php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2020 The PHP Group
All rights reserved.
Last updated: Mon Aug 10 00:01:25 2020 UTC