Bug #71863 [Fbk->Asn]: Segfault when EXPLAIN with "Unknown column" error
| From: | andrey@php.net | Date: | Tue, 19 Jul 2016 19:10:21 +0000 |
| Subject: | Bug #71863 [Fbk->Asn]: Segfault when EXPLAIN with "Unknown column" error | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-202428@lists.php.net to get a copy of this message | ||
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: Feedback
+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:
I confirm a segfault with MariaDB 10.1.16 . Will have to check how it is incompatible with the MySQL
client server protocol.
Previous Comments:
------------------------------------------------------------------------
[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'
------------------------------------------------------------------------
[2016-07-13 20:11:58] nikic@php.net
@andrey: The PR (https://github.com/php/php-src/pull/1858) points out that this is likely caused by
https://github.com/php/php-src/commit/4bb784cd0d80c330364cdfebc824a434cc27f05a.
Could you please take a look at the PR and check if it is correct?
------------------------------------------------------------------------
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