Bug #70384 [Com]: mysqli_real_query(): Unknown type 245 sent by the server

Edit report at https://bugs.php.net/bug.php?id=70384&edit=1 ID: 70384 Comment by: morgan dot tocker at oracle dot com Reported by: marc at infomarc dot info Summary: mysqli_real_query(): Unknown type 245 sent by the server Status: Open Type: Bug Package: MySQLi related Operating System: Linux PHP Version: 7.0.0RC1 Block user comment: N Private report: N New Comment: There is a temporary workaround available here. The test case can be modified to cast the JSON type to a CHAR, which is fine from PHP's perspective: select id, CAST(jsoncol as CHAR) from marctable Previous Comments: ------------------------------------------------------------------------ [2015-08-28 18:13:54] marc at infomarc dot info Description: ------------ I report this for 7.0.0RC1 but am able to reproduce also on PHP 5.6.7. MySQL Server is 5.7.8-rc. Test table created with CREATE TABLE marctable ( id int(11) NOT NULL AUTO_INCREMENT, jsoncol json DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 Test script: --------------- <?php $link = mysqli_init(); $connect_result = mysqli_real_connect($link, '127.0.0.1', 'userxxx', 'passxxx', 'marcdb'); echo "connect_result: " . $connect_result . "\n"; $query_result = mysqli_real_query($link, "select * from marctable"); echo "query result: " . $query_result . "\n"; echo "mysqli_error: " . mysqli_error($link) . "\n"; Expected result: ---------------- connect_result: 1 query result: 1 mysqli_error: Actual result: -------------- connect_result: 1 PHP Warning: mysqli_real_query(): Unknown type 245 sent by the server. Please send a report to the developers in bugjson.php on line 9 Warning: mysqli_real_query(): Unknown type 245 sent by the server. Please send a report to the developers in bugjson.php on line 9 zend_mm_heap corrupted ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=70384&edit=1