Edit report at https://bugs.php.net/bug.php?id=71863&edit=1
ID: 71863
Updated by: andrey@php.net
Reported by: Azq2 at ya dot ru
Summary: Segfault when EXPLAIN with "Unknown column" error
Status: Assigned
Type: Bug
Package: MySQLi related
Operating System: Ubuntu 14.04
PHP Version: master-Git-2016-03-20 (Git)
Assigned To: andrey
Block user comment: N
Private report: N
New Comment:
MySQL sends an error directly after the query is executed, as it should happen. MariaDB does send
OK, meaning that there are fields and sends meta for 10 fields, then EOF (marking end of metadata)
and only then it sends an error message. Such sending of errors is not common. It exists when we
talk calling stored procedures because they can fail in the middle after some meta is sent.
Previous Comments:
------------------------------------------------------------------------
[2016-07-19 19:10:20] andrey@php.net
I confirm a segfault with MariaDB 10.1.16 . Will have to check how it is incompatible with the MySQL
client server protocol.
------------------------------------------------------------------------
[2016-07-19 14:05:08] andrey@php.net
MariaDB might be an issue. I don't know. Keep in mind that mysqlnd supports officially only
MySQL and not any forks.
I will try to get MariaDB up and running to test with it.
Best,
Andrey
------------------------------------------------------------------------
[2016-07-19 14:01:06] reyad dot attiyat at gmail dot com
@andrey
I still get this bug on PHP 7.1. However I'm using Windows 10, previously on Windows 7, and am
using PHP 7.1.0alpha3 Thread Safe. I downloaded the build from here: http://windows.php.net/qa/. I also just test the non thread
safe build and encounter the same problem.
I will test on linux to eliminate that as a possible cause.
Also I'm using MariaDB and not Oracle's MySQL could this be the reason for segmentation
fault?
------------------------------------------------------------------------
[2016-07-19 08:10:27] andrey@php.net
I can't reproduce also with the test script from this bug report (in the previous comment I
tested with the test script from the Pull Request)
------------------------------------------------------------------------
[2016-07-19 08:08:32] andrey@php.net
I can't reproduce with 7.1 and MySQL 5.7.13
andrey@poohie:/work/dev/php/php-src$ ./php -v
PHP 7.1.0-dev (cli) (built: Jul 19 2016 11:03:23) ( NTS DEBUG )
Copyright (c) 1997-2016 The PHP Group
Zend Engine v3.1.0-dev, Copyright (c) 1998-2016 Zend Technologies
andrey@poohie:/work/dev/php/php-src$ ./php ext/mysqli/tests/bug71863.php
Unknown column 'owner_id' in 'where clause'
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=71863
--
Edit this bug report at https://bugs.php.net/bug.php?id=71863&edit=1