Do you use mysqlnd with ext/mysql or libmysql, in either case does it solve switching the lib?

Is mysqli affected by this issue too on your machine?

I am using the php5 package from the Ubuntu Linux APT repository. It seems to use 
libmysql. And yes, mysqli is also affected.

Please use a recent snapshot from our site, we don't know what kind of patches Ubuntu applies. Please provide the table schema and data you are querying. Whcih MySQL server version?

In my current situation I cannot afford to set up a test box and try to compile 
the snapshot from php.net. However, I will do so as soon as I can. In the 
meantime here is the source-archive with all patches that I use, from the Ubuntu 
Repositories: 
http://archive.ubuntu.com/ubuntu/pool/main/p/php5/php5_5.3.2.orig.tar.gz

Also, I can confirm that the same problem exists on an x64 box with the same 
software versions too. All other requested information (schema, versions) are 
provided in detail on the link in the description.

Can't afford?  As in financially?  There are multiple free virtualization 
mechanisms out there and the OS images are free.  Setting up a clean vm on your 
existing machine is trivial and takes about 30 minutes, tops.

No, I meant that I cannot afford the time loss since the deadline for my work is 
*really* close, and this is just hobby project. :-P

Just let me get this straight: You have an issue and now you ask us to invest our (limited) time (for free) to rebuild your setup and find the causing component? - As you can imagine we all have our tasks to do and our deadlines and for some work on PHP is hobby, too.

With your given your schema I was unable to reproduce this case on any of my setups.

As reference, here the output I get:


array(3) {
  ["name"]=>
  string(4) "root"
  ["level"]=>
  string(1) "0"
  ["parent"]=>
  NULL
}
<br /><br />array(3) {
  ["name"]=>
  string(5) "error"
  ["level"]=>
  string(1) "1"
  ["parent"]=>
  string(4) "root"
}
<br /><br />array(3) {
  ["name"]=>
  string(11) "index_index"
  ["level"]=>
  string(1) "1"
  ["parent"]=>
  string(4) "root"
}
<br /><br />array(3) {
  ["name"]=>
  string(11) "error_error"
  ["level"]=>
  string(1) "2"
  ["parent"]=>
  string(5) "error"
}
<br /><br />array(3) {
  ["name"]=>
  string(12) "error_denied"
  ["level"]=>
  string(1) "2"
  ["parent"]=>
  string(5) "error"
}
<br /><br />

I am sorry, I was not clear enough. I wanted to say, that it will take some time 
for me to set up a test box, but wanted to share my other findings earlier. I do 
know that you are volunteers, and that others have work to do too.

Please try using this snapshot:

  http://snaps.php.net/php5.3-latest.tar.gz
 
For Windows:

  http://windows.php.net/snapshots/

Finally, I have set up a test system, and compiled snapshot 201008181230 on it. 
It works fine! However, if I copy the libphp5.so file from this test system to 
any of the servers where the error occurs, and restart apache, the bug is still 
there! Please help me figure out what is causing this issue. I am clueless.

Thanks,
gsx1022

It was my fault all the time. The error was in my code. Sorry for bothering you. 
Please close this report.

Closing upon request of the bug reporter.