|
@@ 290-300 (lines=11) @@
|
| 287 |
|
self::assertEquals(array('CREATE TABLE spatial_table (point LONGTEXT NOT NULL, SPATIAL INDEX spatial_text (point)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = MyISAM'), $sql); |
| 288 |
|
} |
| 289 |
|
|
| 290 |
|
public function testClobTypeDeclarationSQL() |
| 291 |
|
{ |
| 292 |
|
self::assertEquals('TINYTEXT', $this->_platform->getClobTypeDeclarationSQL(array('length' => 1))); |
| 293 |
|
self::assertEquals('TINYTEXT', $this->_platform->getClobTypeDeclarationSQL(array('length' => 255))); |
| 294 |
|
self::assertEquals('TEXT', $this->_platform->getClobTypeDeclarationSQL(array('length' => 256))); |
| 295 |
|
self::assertEquals('TEXT', $this->_platform->getClobTypeDeclarationSQL(array('length' => 65535))); |
| 296 |
|
self::assertEquals('MEDIUMTEXT', $this->_platform->getClobTypeDeclarationSQL(array('length' => 65536))); |
| 297 |
|
self::assertEquals('MEDIUMTEXT', $this->_platform->getClobTypeDeclarationSQL(array('length' => 16777215))); |
| 298 |
|
self::assertEquals('LONGTEXT', $this->_platform->getClobTypeDeclarationSQL(array('length' => 16777216))); |
| 299 |
|
self::assertEquals('LONGTEXT', $this->_platform->getClobTypeDeclarationSQL(array())); |
| 300 |
|
} |
| 301 |
|
|
| 302 |
|
public function testBlobTypeDeclarationSQL() |
| 303 |
|
{ |
|
@@ 302-312 (lines=11) @@
|
| 299 |
|
self::assertEquals('LONGTEXT', $this->_platform->getClobTypeDeclarationSQL(array())); |
| 300 |
|
} |
| 301 |
|
|
| 302 |
|
public function testBlobTypeDeclarationSQL() |
| 303 |
|
{ |
| 304 |
|
self::assertEquals('TINYBLOB', $this->_platform->getBlobTypeDeclarationSQL(array('length' => 1))); |
| 305 |
|
self::assertEquals('TINYBLOB', $this->_platform->getBlobTypeDeclarationSQL(array('length' => 255))); |
| 306 |
|
self::assertEquals('BLOB', $this->_platform->getBlobTypeDeclarationSQL(array('length' => 256))); |
| 307 |
|
self::assertEquals('BLOB', $this->_platform->getBlobTypeDeclarationSQL(array('length' => 65535))); |
| 308 |
|
self::assertEquals('MEDIUMBLOB', $this->_platform->getBlobTypeDeclarationSQL(array('length' => 65536))); |
| 309 |
|
self::assertEquals('MEDIUMBLOB', $this->_platform->getBlobTypeDeclarationSQL(array('length' => 16777215))); |
| 310 |
|
self::assertEquals('LONGBLOB', $this->_platform->getBlobTypeDeclarationSQL(array('length' => 16777216))); |
| 311 |
|
self::assertEquals('LONGBLOB', $this->_platform->getBlobTypeDeclarationSQL(array())); |
| 312 |
|
} |
| 313 |
|
|
| 314 |
|
/** |
| 315 |
|
* @group DBAL-400 |
doctrine /
dbal
