zendframework/zend-db

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 '',
....

This repository has been closed and moved to laminas/laminas-db; a new issue has been opened at laminas/laminas-db#112.