zend-db icon indicating copy to clipboard operation
zend-db copied to clipboard

Varchar DDL creation error for SQLite

Open GeeH opened this issue 9 years ago • 1 comments

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

GeeH avatar Jun 28 '16 13:06 GeeH

This repository has been closed and moved to laminas/laminas-db; a new issue has been opened at https://github.com/laminas/laminas-db/issues/112.

michalbundyra avatar Jan 16 '20 19:01 michalbundyra