php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #30896 mysql(i)_fetch_*() fails on "SELECT * FROM t"
Submitted: 2004-11-25 11:05 UTC Modified: 2004-11-26 10:54 UTC
From: niklas dot lampen at publico dot com Assigned:
Status: Not a bug Package: MySQLi related
PHP Version: 5.0.2 OS: Linux Debian
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: niklas dot lampen at publico dot com
New email:
PHP Version: OS:

 

 [2004-11-25 11:05 UTC] niklas dot lampen at publico dot com 
Description:
------------
Fetching rows fail on both mysql_() and mysqli_() when query is simple "SELECT *".

Not working:
"SELECT * FROM t ORDER BY f"

Working:
"SELECT * FROM t WHERE 1=1 ORDER BY f"
"SELECT * FROM t ORDER BY f LIMIT n"
"SELECT f, f2, f3, f4 FROM t ORDER BY f"

Reproduce code:
---------------
$Res = mysql_query("SELECT * FROM t ORDER BY f", $Conn);
$R = mysql_fetch_object($Res);
var_dump($R);

Expected result:
----------------
object(stdClass)#2 (4) { ["f"]=>  string(4) "data" ["f2"]=>  string(4) "data" ["f3"]=>  string(4) "data" ["f4"]=>  string(4) "data" }

Actual result:
--------------
object(stdClass)#2 (2) { ["@"]=>  string(8) "#CERT11#" [""]=>  string(0) "" }

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-11-25 18:06 UTC] georg@php.net 
Can't repeat. Could you test the following script please: 
 
<?php 
 
$mysql = new mysqli("localhost", "user", "password", 
"test"); 
 
printf("Client-Version: %s\n", $mysql->client_version); 
printf("Server-Version: %s\n", $mysql->server_version); 
 
$mysql->query("DROP TABLE IF EXISTS f"); 
$mysql->query("CREATE TABLE f (f char(4), f2 char(4), f3 
char(4), f4 char(4))"); 
 
$mysql->query("INSERT INTO f VALUES ('data', 'data', 
'data', 'data')"); 
 
$result = $mysql->query("SELECT * FROM f ORDER BY f"); 
 
$row = $result->fetch_object(); 
var_dump($row); 
?> 
 
Output: 
Client-Version: 40108 
Server-Version: 40108 
object(stdClass)#3 (4) { 
  ["f"]=> 
  string(4) "data" 
  ["f2"]=> 
  string(4) "data" 
  ["f3"]=> 
  string(4) "data" 
  ["f4"]=> 
  string(4) "data" 
}
 [2004-11-26 09:18 UTC] niklas dot lampen at publico dot com 
It seems to work just fine now. I can't reproduce the error anymore even with the very same code I found this "bug".
I have not updated php nor mysql nor anything else on the box.

Sorry for the mistaken bug report.
 [2004-11-26 10:54 UTC] tony2001@php.net 
No bug -> bogus.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Fri May 09 13:01:28 2025 UTC