ID: 50416
Updated by: jani@php.net
Reported By: ernesto_vargas at yahoo dot com
Status: Assigned
Bug Type: MySQL related
Operating System: *
PHP Version: 5.3, 6
Assigned To: mysql
New Comment:
Uwe, please notice my comment: It _works_ with PHP 5.2.x but NOT with
5.3, ergo, there's a bug in _PHP_ mysql stuff..
Previous Comments:
------------------------------------------------------------------------
[2010-01-05 14:53:47] ernesto_vargas at yahoo dot com
@uw@php.net;
The store procedure code is a simple Hello World. Code is below.
DELIMITER $$
CREATE PROCEDURE myproc()
BEGIN
SELECT 'it works!';
END$$
------------------------------------------------------------------------
[2010-01-04 10:51:19] uw@php.net
This may be a valid error message,
http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
. What's
the code of the SP?
------------------------------------------------------------------------
[2009-12-17 08:23:52] jani@php.net
Works with latest PHP 5.2, fails with 5.3+.
------------------------------------------------------------------------
[2009-12-08 22:44:04] ermesto_vargas at yahoo dot com
./configure --build=x86_64-redhat-linux-gnu
--host=x86_64-redhat-linux-gnu --target=x86_64-redhat-linux-gnu
--program-prefix= --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin
--sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--includedir=/usr/include --libdir=/usr/lib64 --libexecdir=/usr/libexec
--localstatedir=/var --sharedstatedir=/var/lib --mandir=/usr/share/man
--infodir=/usr/share/info --cache-file=../config.cache
--with-libdir=lib64 --with-config-file-path=/etc
--with-config-file-scan-dir=/etc/php.d --disable-debug --with-pic
--disable-rpath --without-pear --with-bz2 --with-exec-dir=/usr/bin
--with-freetype-dir=/usr --with-png-dir=/usr --with-xpm-dir=/usr
--enable-gd-native-ttf --with-t1lib=/usr --without-gdbm --with-gettext
--with-gmp --with-iconv --with-jpeg-dir=/usr --with-openssl
--with-pcre-regex=/usr --with-zlib --with-layout=GNU --enable-exif
--enable-ftp --enable-magic-quotes --enable-sockets --enable-sysvsem
--enable-sysvshm --enable-sysvmsg --with-kerberos --enable-ucd-snmp-hack
--enable-shmop --enable-calendar --without-mime-magic --without-sqlite
--with-libxml-dir=/usr --enable-xml --with-system-tzdata --with-mysql
--without-gd --disable-dom --disable-dba --without-unixODBC
--disable-pdo --disable-xmlreader --disable-xmlwriter --without-sqlite3
--disable-phar --disable-fileinfo --disable-json --without-pspell
--disable-wddx --without-curl --disable-posix --disable-sysvmsg
--disable-sysvshm --disable-sysvsem
Same results here is the result:
---------------------------------------------------------------------
Current PHP version: 5.3.2-dev
Current MYSQL version: 1.0
Warning: mysql_query(): PROCEDURE test.myproc can't return a result set
in the given context in /home/html/sp_test.php on line 14
Invalid query: PROCEDURE test.myproc can't return a result set in the
given context
Whole query: CALL myproc();
------------------------------------------------------------------------
[2009-12-08 21:57:29] jani@php.net
Please try using this snapshot:
http://snaps.php.net/php5.3-latest.tar.gz
For Windows:
http://windows.php.net/snapshots/
And if that does not work, please provide your configure line.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/50416--
Edit this bug report at http://bugs.php.net/?id=50416&edit=1