Bug #6655

column Default

Details

Submitted	2006-02-01 13:50 UTC
From	arne dot bippes at brandao dot de
Assigned	wiesemann
Status	Closed
Package	DB_Table
PHP Version	Irrelevant
OS	irrelevant
Roadmaps	(Not assigned)

Comments

[2006-02-01 13:50 UTC] arne dot bippes at brandao dot de

Description:
------------
Create String with default values for char-type columns is improperly coded.

Test script:
---------------
Just a short patch (Manager.php):

// set the "DEFAULT" portion
if ($default) {
switch ($coltype) {
case 'char':
case 'varchar':
case 'clob':
$declare .= " DEFAULT '$default'";
break;
default:
$declare .= " DEFAULT $default";
break;
}
}

Expected result:
----------------
CREATE TABLE mytable (
char_columnCHAR(2) NOT NULL DEFAULT '3I'
)

Actual result:
--------------
CREATE TABLE mytable (
char_columnCHAR(2) NOT NULL DEFAULT 3I
)