From: hostmaster at uuism dot net
Operating system: Fedora Core 4
PHP version: 5.2.6
PHP Bug Type: MySQLi related
Bug description: bug42548.phpt MySQL Syntax Error for MySQL 4.1
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 bug report at http://bugs.php.net/?id=46438&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=46438&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=46438&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=46438&r=trysnapshot60
Fixed in CVS:
http://bugs.php.net/fix.php?id=46438&r=fixedcvs
Fixed in CVS and need be documented:
http://bugs.php.net/fix.php?id=46438&r=needdocs
Fixed in release:
http://bugs.php.net/fix.php?id=46438&r=alreadyfixed
Need backtrace:
http://bugs.php.net/fix.php?id=46438&r=needtrace
Need Reproduce Script:
http://bugs.php.net/fix.php?id=46438&r=needscript
Try newer version:
http://bugs.php.net/fix.php?id=46438&r=oldversion
Not developer issue:
http://bugs.php.net/fix.php?id=46438&r=support
Expected behavior:
http://bugs.php.net/fix.php?id=46438&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=46438&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=46438&r=submittedtwice
register_globals:
http://bugs.php.net/fix.php?id=46438&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=46438&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=46438&r=dst
IIS Stability:
http://bugs.php.net/fix.php?id=46438&r=isapi
Install GNU Sed:
http://bugs.php.net/fix.php?id=46438&r=gnused
Floating point limitations:
http://bugs.php.net/fix.php?id=46438&r=float
No Zend Extensions:
http://bugs.php.net/fix.php?id=46438&r=nozend
MySQL Configuration Error:
http://bugs.php.net/fix.php?id=46438&r=mysqlcfg
