Hello David.
I'm not quite sure current status of the project.
Then I hope you to judge when and how to commit the patch.
// It seems for me that Roller 3.0 is going to be released in a while and
// it is somehow sensitive to commit a patch now.
Best regards.
David Johnson (JIRA) wrote:
[ http://opensource.atlassian.com/projects/roller/browse/ROL-1248?page=comments#action_13382 ]
David Johnson commented on ROL-1248:
------------------------------------
You are correct again. If it's "default null" in the migration script, then it
should be default null in the create script. - Dave
Execution of /build/webapp/WEB-INF/dbscripts/derby/createdb.sql was failed.
---------------------------------------------------------------------------
Key: ROL-1248
URL: http://opensource.atlassian.com/projects/roller/browse/ROL-1248
Project: Roller
Type: Bug
Reporter: Tomohito Nakayama
Assignee: David Johnson
Attachments: ROLLER-1248.patch
I found next error was happend ...
ij> create table webpage (a
id varchar(48) not null primary key,
name varchar(255) not null,
description varchar(255),
link varchar(255),
websiteid varchar(48) not null,
template clob(102400) not null,
updatetime timestamp not null,
hidden smallint default 0 not null,
navbar smallint default 0 not null,
templatelang varchar(20) not null,
decorator varchar(255) null
);
ERROR 42X01: Syntax error: Encountered "null" at line 12, column 34.
ij> create index wp_name_idx on webpage( name );
ERROR 42Y55: 'CREATE INDEX' cannot be performed on 'WEBPAGE' because it does
not exist.
ij> create index wp_link_idx on webpage( link );
ERROR 42Y55: 'CREATE INDEX' cannot be performed on 'WEBPAGE' because it does
not exist.
ij> create index wp_id_idx on webpage( websiteid );
ERROR 42Y55: 'CREATE INDEX' cannot be performed on 'WEBPAGE' because it does
not exist.
I'm not sure correct definition of webpage.decorator ....
At least , grammer of SQL in derby supports "not null" but does'nt "null" as
Column-level-constraint ...
http://db.apache.org/derby/docs/10.1/ref/rrefsqlj16095.html#rrefsqlj16095
--
/*
Tomohito Nakayama
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Naka
http://www5.ocn.ne.jp/~tomohito/TopPage.html
*/
