#45851 [NEW]: mysqli_fetch_object should detect empty column names

[email protected] ("peterbelm at gmail dot com")
Newsgroups php.bugs
Message-ID <[email protected]>
From:             peterbelm at gmail dot com
Operating system: Any
PHP version:      5.2.6
PHP Bug Type:     MySQLi related
Bug description:  mysqli_fetch_object should detect empty column names

Description:
------------
If a column is select with an empty name like so:

SELECT id as ``...

You get a fatal error "Cannot access empty property". Looking through the
Zend code I found it happens when looking up property info.
Shouldn't mysqli check for empty property names when creating the object,
triggering it's own (more useful) error?

Reproduce code:
---------------
$link = mysqli_connect($host, $user, $pass);
mysqli_select_db($schema);
$result = mysqli_query("select 'test' as ``", $link);
$obj = mysqli_fetch_object($result);

Expected result:
----------------
A fatal error along the lines of "Empty column name in SQL"

Actual result:
--------------
Fatal error: "Cannot access empty property"

Generated from Zend/zend_object_handlers.c:188

-- 
Edit bug report at http://bugs.php.net/?id=45851&edit=1
-- 
Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=45851&r=trysnapshot52
Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=45851&r=trysnapshot53
Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=45851&r=trysnapshot60
Fixed in CVS:                 http://bugs.php.net/fix.php?id=45851&r=fixedcvs
Fixed in release:             http://bugs.php.net/fix.php?id=45851&r=alreadyfixed
Need backtrace:               http://bugs.php.net/fix.php?id=45851&r=needtrace
Need Reproduce Script:        http://bugs.php.net/fix.php?id=45851&r=needscript
Try newer version:            http://bugs.php.net/fix.php?id=45851&r=oldversion
Not developer issue:          http://bugs.php.net/fix.php?id=45851&r=support
Expected behavior:            http://bugs.php.net/fix.php?id=45851&r=notwrong
Not enough info:              http://bugs.php.net/fix.php?id=45851&r=notenoughinfo
Submitted twice:              http://bugs.php.net/fix.php?id=45851&r=submittedtwice
register_globals:             http://bugs.php.net/fix.php?id=45851&r=globals
PHP 4 support discontinued:   http://bugs.php.net/fix.php?id=45851&r=php4
Daylight Savings:             http://bugs.php.net/fix.php?id=45851&r=dst
IIS Stability:                http://bugs.php.net/fix.php?id=45851&r=isapi
Install GNU Sed:              http://bugs.php.net/fix.php?id=45851&r=gnused
Floating point limitations:   http://bugs.php.net/fix.php?id=45851&r=float
No Zend Extensions:           http://bugs.php.net/fix.php?id=45851&r=nozend
MySQL Configuration Error:    http://bugs.php.net/fix.php?id=45851&r=mysqlcfg
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.