public function testGetGeometrySpatialColumnInfo()
{
$schemaManager = new SchemaManager($this->_getConnection());
$this->assertNull($schemaManager->getGeometrySpatialColumnInfo('foo.points', 'text'));
$expected = array('type' => 'GEOMETRY', 'srid' => 0);
$this->assertEquals($expected, $schemaManager->getGeometrySpatialColumnInfo('points', 'geometry'));
$expected = array('type' => 'POINT', 'srid' => 0);
$this->assertEquals($expected, $schemaManager->getGeometrySpatialColumnInfo('points', 'point'));
$expected = array('type' => 'POINT', 'srid' => 3785);
$this->assertEquals($expected, $schemaManager->getGeometrySpatialColumnInfo('points', 'point_2d'));
$expected = array('type' => 'POINTZ', 'srid' => 3785);
$this->assertEquals($expected, $schemaManager->getGeometrySpatialColumnInfo('points', 'point_3dz'));
$expected = array('type' => 'POINTM', 'srid' => 3785);
$this->assertEquals($expected, $schemaManager->getGeometrySpatialColumnInfo('points', 'point_3dm'));
$expected = array('type' => 'POINTZM', 'srid' => 3785);
$this->assertEquals($expected, $schemaManager->getGeometrySpatialColumnInfo('points', 'point_4d'));
$expected = array('type' => 'POINT', 'srid' => 3785);
$this->assertEquals($expected, $schemaManager->getGeometrySpatialColumnInfo('points', 'point_2d_nullable'));
$expected = array('type' => 'POINT', 'srid' => 0);
$this->assertEquals($expected, $schemaManager->getGeometrySpatialColumnInfo('points', 'point_2d_nosrid'));
}