this test is a bit buggy. we cannot know which databases will exist on the server, so we cannot know which one will be at which position. so we check for a string as return value. but while testing i got things back like '0' and '1' and '2' which were accepted as valid strings, when i expected to get an error...
this gets a bit more complicated. in dos mysql, it looks like this:
mysql> select test.iD, field1 as field2, field2 as shit from test; +----+------------+--------+ | iD | field2 | shit | +----+------------+--------+ | 1 | hello | world | | 2 | foo | bar | | 3 | test | record | | 4 | new record | | +----+------------+--------+ 4 rows in set (0.00 sec)