|
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-2026 The PHP GroupAll rights reserved. |
Last updated: Mon Feb 02 16:00:01 2026 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