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

ID: 46438 Updated by: felipe@php.net Reported By: hostmaster at uuism dot net -Status: Open +Status: Closed Bug Type: MySQLi related Operating System: Fedora Core 4 PHP Version: 5.2.6 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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