#46438 [Csd]: bug42548.phpt MySQL Syntax Error for MySQL 4.1

ID: 46438 User updated by: hostmaster at uuism dot net Reported By: hostmaster at uuism dot net Status: Closed Bug Type: MySQLi related Operating System: Fedora Core 4 PHP Version: 5.2.6 New Comment: Thanks. The revised php5.2-200810312330 test script skips this test perfectly. Jim Previous Comments: ------------------------------------------------------------------------ [2008-10-31 22:43:53] felipe@php.net This bug has been fixed in CVS. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. ------------------------------------------------------------------------ [2008-10-31 18:21:11] hostmaster at uuism dot net Description: ------------ When I run test ext/mysqli/tests/bug42548.phpt with PHP 5.2.6 and MySQL 4.1, I get a MySQL syntax error. "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 'PROCEDURE IF EXISTS p1' at line 1" This error occurs because MySQL version 4.1 does not support PROCEDUREs. Reproduce code: --------------- <?php include "connect.inc"; $mysqli = mysqli_init(); $mysqli->real_connect($host, $user, $passwd, 'test'); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } $mysqli->query("DROP PROCEDURE IF EXISTS p1") or die($mysqli->error); ?> Expected result: ---------------- This test should be skipped Actual result: -------------- it failed ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=46438&edit=1