|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2008-10-31 22:43 UTC] felipe@php.net
[2008-11-01 03:33 UTC] hostmaster at uuism dot net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Wed Dec 03 02:00:01 2025 UTC |
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