public function test_mysql_field()
{
$this->getConnection("shim_test");
$result = mysql_query("SELECT * FROM testing LIMIT 1");
$this->assertEquals("testing", mysql_field_table($result, 0));
$this->assertEquals("id", mysql_field_name($result, 0));
$this->assertEquals("int", mysql_field_type($result, 0));
$this->assertEquals(11, mysql_field_len($result, 0));
$this->assertEquals("not_null primary_key auto_increment", mysql_field_flags($result, 0));
$this->assertEquals("testing", mysql_field_table($result, 1));
$this->assertEquals("one", mysql_field_name($result, 1));
$this->assertEquals("string", mysql_field_type($result, 1));
$this->assertEquals(255, mysql_field_len($result, 1));
$this->assertEquals("multiple_key", mysql_field_flags($result, 1));
$this->assertEquals("testing", mysql_field_table($result, 2));
$this->assertEquals("two", mysql_field_name($result, 2));
$this->assertEquals("string", mysql_field_type($result, 2));
$this->assertEquals(255, mysql_field_len($result, 2));
$this->assertEquals("unique_key", mysql_field_flags($result, 2));
$this->assertEquals("testing", mysql_field_table($result, 3));
$this->assertEquals("three", mysql_field_name($result, 3));
$this->assertEquals("string", mysql_field_type($result, 3));
$this->assertEquals(255, mysql_field_len($result, 3));
$this->assertEquals("multiple_key", mysql_field_flags($result, 3));
$this->assertEquals("testing", mysql_field_table($result, 4));
$this->assertEquals("four", mysql_field_name($result, 4));
$this->assertEquals("string", mysql_field_type($result, 4));
$this->assertEquals(255, mysql_field_len($result, 4));
$this->assertEquals("multiple_key", mysql_field_flags($result, 4));
$this->assertEquals("testing", mysql_field_table($result, 5));
$this->assertEquals("five", mysql_field_name($result, 5));
$this->assertEquals("string", mysql_field_type($result, 5));
$this->assertEquals(255, mysql_field_len($result, 5));
$this->assertEmpty(mysql_field_flags($result, 5));
$this->assertEquals("testing", mysql_field_table($result, 6));
$this->assertEquals("six", mysql_field_name($result, 6));
$this->assertEquals("string", mysql_field_type($result, 6));
$this->assertEquals(255, mysql_field_len($result, 6));
$this->assertEmpty(mysql_field_flags($result, 6));
$this->assertEquals("testing", mysql_field_table($result, 7));
$this->assertEquals("seven", mysql_field_name($result, 7));
$this->assertEquals("string", mysql_field_type($result, 7));
$this->assertEquals(255, mysql_field_len($result, 7));
$this->assertEquals("multiple_key", mysql_field_flags($result, 7));
$this->assertEquals("testing", mysql_field_table($result, 8));
$this->assertEquals("eight", mysql_field_name($result, 8));
$this->assertEquals("string", mysql_field_type($result, 8));
$this->assertEquals(255, mysql_field_len($result, 8));
$this->assertEmpty(mysql_field_flags($result, 8));
$this->assertEquals("testing", mysql_field_table($result, 9));
$this->assertEquals("nine", mysql_field_name($result, 9));
$this->assertEquals("string", mysql_field_type($result, 9));
$this->assertEquals(6, mysql_field_len($result, 9));
$this->assertEquals("enum", mysql_field_flags($result, 9));
$this->assertEquals("testing", mysql_field_table($result, 10));
$this->assertEquals("ten", mysql_field_name($result, 10));
$this->assertEquals("string", mysql_field_type($result, 10));
$this->assertEquals(15, mysql_field_len($result, 10));
$this->assertEquals("set", mysql_field_flags($result, 10));
$this->assertEquals("testing", mysql_field_table($result, 11));
$this->assertEquals("eleven", mysql_field_name($result, 11));
$this->assertEquals("blob", mysql_field_type($result, 11));
$this->assertEquals(16777215, mysql_field_len($result, 11));
$this->assertEquals("blob", mysql_field_flags($result, 11));
}