From: [EMAIL PROTECTED]
Operating system: Linux 2.4.28
PHP version: 4.3.10
PHP Bug Type: MySQL related
Bug description: Reproducible garbage array using MYSQL_ASSOC
Description:
------------
mysql_fetch_array with MYSQL_ASSOC returns bogus array keys and some
corrupted data fields in 4.3.10 (but not 4.3.9). Reproducible always with
this particular query. Reproduced in both dotdeb.org packaged version and
minimal cli version compiled from source:
./configure '--enable-cli' '--disable-cgi' '--disable-debug'
'--disable-debug' '--disable-pear' '--without-pear' '--with-mysql=/usr'
'--with-mysql-sock=/var/run/mysqld/mysqld.sock'
May be related to the long DESCRIPTION field in the first result row, but
problem does not occur if LIMIT is changed to anything other than 6
(hence, sorry for the long expected/actual output!)
Reproduce code:
---------------
<?
$connection = mysql_connect("localhost", "test", "test") or die("Could
not connect to database.");
mysql_select_db("test") or die("Could not select database.");
$query = "SELECT * FROM STORE_ITEM WHERE SUBSECTION_NAME IS NULL
AND pkSTORE_ITEM_ID NOT IN (406, 407, 408) ORDER BY pkSTORE_ITEM_ID DESC
LIMIT 6";
$result = mysql_query($query) or trigger_error("Featured Item
Select Query Failed.", E_USER_ERROR);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
print '<pre>'; print_r($row); print '</pre>';
}
?>
Expected result:
----------------
(from 4.3.9)
<pre>Array
(
[pkSTORE_ITEM_ID] => 404
[fkSTORE_ARTIST_ID] => 33
[ITEM_TYPE] => the drama magazine
[ITEM_NAME] => The Drama Issue Four
[ITEM_NAME_ABBR] => Issue Four
[ARTIST_NAME] =>
[DESCRIPTION] => Our fourth issue, The Inside/Out Issue, includes 88
pages in a mixture of black/white & full color and perfect-bound. We've
got a wraparound cover and ten-page feature on New Jersey artist Matt
Leines, exclusive artwork and interviews with <a
href="http://www.keepsakesociety.com"; target="_blank">Chris Duncan</a>, <a
href="http://www.hackleyspress.com"; target="_blank">David Abbott</a>, <a
href="http://www.workbymarco.com"; target="_blank">Marco Cibola</a>, <a
href="http://www.tinyindustries.com"; target="_blank">Megan Whitmarsh</a>,
Isaac Lin, Marc Bell, <a href="http://www.madreal.com";
target="_blank">Derrick Hodgson</a>, <a
href="http://www.southersalazar.net"; target="_blank">Souther Salazar</a>,
& <a href="http://www.taylormckimens.com"; target="_blank">Taylor
McKimens</a>, photography by <a href="http://www.mayahayuk.com";
target="_blank">Maya Hayuk</a>, <a href="http://www.crownfarmer.com";
target="_blank">Bob Kronbauer</a>, & <a href="http://www.yerinmok.com";
target="_blank">Ye Rin Mok</a>, a talk with several independent art
galleries across the U.S., including <a
href="http://www.branchgallery.com"; target="_blank">Branch Gallery</a>, <a
href="http://www.lumpgallery.com"; target="_blank">Lump Gallery</a>, <a
href="http://www.spectorspector.com"; target="_blank">Spector Gallery</a>,
<a href="http://www.artprostitute.com"; target="_blank">Art Prostitute</a>,
<a href="http://www.newimageartgallery.com"; target="_blank">New Image
Art</a>, <a href="http://www.reupmag.com"; target="_blank">Selective
Hearing Gallery</a>, & <a href="http://www.subliminalprojects.com";
target="_blank">Subliminal Projects</a>, comics by Max Hubenthal & Travis
Robertson, and much more. <br><br>Subscriptions are also available! Please
click <a
href="http://www.thedramastore.org/section.php?s=the%20drama%20subscription";>here</a>
for more information.
[BASE_FILENAME] => magazine04
[PRICE] => 6.00
[OPTION1] =>
[OPTION2] =>
[FLAG_SOLD_OUT] => 0
[FLAG_FEATURED] => 1
[ORDER_ID] => 4
[SUBSECTION_NAME] =>
)
</pre><pre>Array
(
[pkSTORE_ITEM_ID] => 403
[fkSTORE_ARTIST_ID] => 22
[ITEM_TYPE] => misc
[ITEM_NAME] => k.parel Button Set
[ITEM_NAME_ABBR] =>
[ARTIST_NAME] =>
[DESCRIPTION] => A 2-button set by the kind folks at k.parel. Check
out their website at <a href="http://www.kparel.com";
target="_blank">www.kparel.com</a>. We like them.
[BASE_FILENAME] => k01
[PRICE] => 3.00
[OPTION1] =>
[OPTION2] =>
[FLAG_SOLD_OUT] => 0
[FLAG_FEATURED] => 0
[ORDER_ID] => 12
[SUBSECTION_NAME] =>
)
</pre><pre>Array
(
[pkSTORE_ITEM_ID] => 402
[fkSTORE_ARTIST_ID] => 44
[ITEM_TYPE] => art
[ITEM_NAME] => Time and Tide
[ITEM_NAME_ABBR] =>
[ARTIST_NAME] => Hackley's Press
[DESCRIPTION] => 9-colour screenprint by Hackley's Press. Edition of
10.
[BASE_FILENAME] => hackleys02
[PRICE] => 40.00
[OPTION1] =>
[OPTION2] =>
[FLAG_SOLD_OUT] => 0
[FLAG_FEATURED] => 0
[ORDER_ID] => 1
[SUBSECTION_NAME] =>
)
</pre><pre>Array
(
[pkSTORE_ITEM_ID] => 401
[fkSTORE_ARTIST_ID] => 0
[ITEM_TYPE] => misc
[ITEM_NAME] => I Heart Gossip
[ITEM_NAME_ABBR] =>
[ARTIST_NAME] =>
[DESCRIPTION] => Be the talk of the town with this super cute tote
designed by Charles Wilkin of <a href="http://www.automatic-iam.com";
target="_blank">Automatic</a>. They are made of 100% cotton canvas and
available in red or yellow. The size is 13"x14".
[BASE_FILENAME] => charles01
[PRICE] => 15.00
[OPTION1] =>
[OPTION2] =>
[FLAG_SOLD_OUT] => 0
[FLAG_FEATURED] => 0
[ORDER_ID] => 10
[SUBSECTION_NAME] =>
)
</pre><pre>Array
(
[pkSTORE_ITEM_ID] => 400
[fkSTORE_ARTIST_ID] => 0
[ITEM_TYPE] => misc
[ITEM_NAME] => Art Pins
[ITEM_NAME_ABBR] =>
[ARTIST_NAME] =>
[DESCRIPTION] => Hand-made art pins by Jason Hevener. Several to
choose from!
[BASE_FILENAME] => jason01
[PRICE] => 3.00
[OPTION1] => Choose, Bug Me, Bull, Ruff, Ninja (red), Jazz, I Heart
Teeth
[OPTION2] =>
[FLAG_SOLD_OUT] => 0
[FLAG_FEATURED] => 0
[ORDER_ID] => 1
[SUBSECTION_NAME] =>
)
</pre><pre>Array
(
[pkSTORE_ITEM_ID] => 399
[fkSTORE_ARTIST_ID] => 36
[ITEM_TYPE] => prints by the mitten gallery
[ITEM_NAME] => Postcard Set
[ITEM_NAME_ABBR] =>
[ARTIST_NAME] => The Mitten Gallery
[DESCRIPTION] => Set of 5 silkscreened postcards from the Mitten
Gallery.
[BASE_FILENAME] => mitten04
[PRICE] => 3.00
[OPTION1] =>
[OPTION2] =>
[FLAG_SOLD_OUT] => 0
[FLAG_FEATURED] => 0
[ORDER_ID] => 4
[SUBSECTION_NAME] =>
)
Actual result:
--------------
(from 4.3.10)
$ sapi/cli/php -n ~/drama-testcase.php
<pre>Array
(
[B] => 404
[ @] => 33
[] => the drama magazine
[] => 4
[] =>
[] => .com" target="_blank">Megan Whitmarsh</a>, Isaac Lin, Marc Bell,
<a href="http://www.madreal.com"; target="_blank">Derrick Hodgson</a>, <a
href="http://www.southersalazar.net"; Our fourth issue, The Inside/Out
Issue, includes 88 pages in a mixture of black/white & full color and
perfect-bound. We've got a wraparound cover and ten-page feature on New
Jersey artist Matt Leines, exclusive artwork and interviews with <a
href="http://www.keepsakesociety.com"; target="_blank">Chris Duncan</a>, <a
href="http://www.hackleyspress.com"; target="_blank">David Abbott</a>, <a
href="http://www.workbymarco.com"; target="_blank">Marco Cibola</a>, <a
href="http://www.tinyindustriestarget="_blank";>Souther Salazar</a>, & <a
href="http://www.taylormckimens.com"; target="_blank">Taylor McKimens</a>,
photography by <a href="http://www.mayahayuk.com"; target="_blank">Maya
Hayuk</a>, <a href="http://www.crownfarmer.com"; target="_blank">Bob
Kronbauer</a>, & <a href="http://www.yerinmok.com"; target="_blank">Ye Rin
Mok</a>, a talk with several independent art galleries across the U.S.,
including <a href="http://www.branchgallery.com"; target="_blank">Branch
Gallery</a>, <a href="http://www.lumpgallery.com"; target="_blank">Lump
Gallery</a>, <a href="http://www.spectorspector.com";
target="_blank">Spector Gallery</a>, <a
href="http://www.artprostitute.com"; target="_blank">Art Prostitute</a>, <a
href="http://www.newimageartgallery.com"; target="_blank">New Image Art</a>,
<a href="http://www.reupmag.com"; target="_blank">Selective Hearing
Gallery</a>, & <a href="http://www.subliminalprojects.com";
target="_blank">Subliminal Projects</a>, comics by Max Hubenthal & Travis
Robertson, and much more. <br><br>Subscriptions are also available! Please
click <a
href="http://www.thedramastore.org/section.php?s=the%20drama%20subscription";>here</a>
for more information.
@] =>
)
</pre><pre>Array
(
[B] => 403
[ @] => 22
[] => misc
[] => 12
[] =>
[] => A 2-button set by the kind folks at k.parel. Check out their
website at <a href="http://www.kparel.com";
target="_blank">www.kparel.com</a>. We like them.
@] =>
)
</pre><pre>Array
(
[B] => 402
[ @] => 44
[] => art
[] => 1
[] =>
[] => 9-colour screenprint by Hackley's Press. Edition of 10.
@] =>
)
</pre><pre>Array
(
[B] => 401
[ @] => 0
[] => misc
[] => 10
[] =>
[] => Be the talk of the town with this super cute tote designed by
Charles Wilkin of <a href="http://www.automatic-iam.com";
target="_blank">Automatic</a>. They are made of 100% cotton canvas and
available in red or yellow. The size is 13"x14".
@] =>
)
</pre><pre>Array
(
[B] => 400
[ @] => 0
[] => misc
[] => 1
[] =>
[] => Hand-made art pins by Jason Hevener. Several to choose from!
@] =>
)
</pre><pre>Array
(
[B] => 399
[ @] => 36
[] => prints by the mitten gallery
[] => 4
[] =>
[] => Set of 5 silkscreened postcards from the Mitten Gallery.
@] =>
)
</pre>
--
Edit bug report at http://bugs.php.net/?id=31637&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=31637&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=31637&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=31637&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=31637&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=31637&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=31637&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=31637&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=31637&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=31637&r=support
Expected behavior: http://bugs.php.net/fix.php?id=31637&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=31637&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=31637&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=31637&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=31637&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=31637&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=31637&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=31637&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=31637&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=31637&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=31637&r=mysqlcfg
