Varchar DDL creation error for SQLite
Opened this issue · 1 comments
GeeH commented
This issue has been moved from the zendframework
repository as part of the bug migration program as outlined here - http://framework.zend.com/blog/2016-04-11-issue-closures.html
Original Issue: https://api.github.com/repos/zendframework/zendframework/issues/7279
User: @debuger
Created On: 2015-02-28T15:08:25Z
Updated At: 2015-11-06T20:50:20Z
Body
DDL column, created with following code
$column = new Ddl\Column\Varchar('column', 255);
$column->setNullable(true);
$column->setDefault('');
creates sql
CREATE TABLE "table" (
....
"column" VARCHAR(255) '',
....
which causes SQL error.
Right SQL should be like for integer
CREATE TABLE "table" (
....
"column" VARCHAR(255) DEFAULT '',
....
michalbundyra commented
This repository has been closed and moved to laminas/laminas-db; a new issue has been opened at laminas/laminas-db#112.