public function testAddIndexWithLimit() { $table = new \Phinx\Db\Table('table1', array(), $this->adapter); $table->addColumn('email', 'string')->save(); $this->assertFalse($table->hasIndex('email')); $table->addIndex('email', array('limit' => 50))->save(); $this->assertTrue($table->hasIndex('email')); $index_data = $this->adapter->query('SELECT SUB_PART FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = "phinx_testing" AND TABLE_NAME = "table1" AND INDEX_NAME = "email"')->fetch(\PDO::FETCH_ASSOC); $expected_limit = $index_data['SUB_PART']; $this->assertEquals($expected_limit, 50); }