Solved XF\Db\Schema\Column::values() can generate invalid SQL

This topic has been solved
X

Xon

Guest
Given the example code:
PHP:

Code:
$this->schemaManager()->createTable('test', function(Create $table) {
    $table->addColumn('id','int')->values(null);
});

It will generate the following (invalid) SQL:
SQL:

Code:
  CREATE TABLE `test` (
        `id` INT(NULL) UNSIGNED NOT NULL
);

The issue is XF\Db\Schema\Column::values(), doesn't handle null sanely, and converts it into [null] unlike all the other fluent functions for XF\Db\Schema\Column

SQL:

public function...

Read more

Continue reading...