Main Overview Wiki Issues Forum Build Fisheye
Issue Details (XML | Word | Printable)

Key: CMP-362
Type: Bug Bug
Status: Open Open
Priority: Minor Minor
Assignee: Shay Banon
Reporter: Tom Jensen
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.

DB2 table schema generation doesn't work with DB2 8.2 on linux

Created: 23/Jan/07 01:04 PM   Updated: 23/Jan/07 01:04 PM
Component/s: Compass::Core
Affects Version/s: 1.1 RC1
Fix Version/s: None

Environment: db2 linux 8.2

 Description  « Hide
This is the DDL that compass generated:

create table index_discovery (name_ varchar(50) , value_ blob(500000 K) , size_ integer , lf_ timestamp , deleted_ smallint, primary key (name_) )

I had to alter the SQL to work with the db as follows (there were two problems I found, name_ wasn't specified to be 'not null' even though it was the primary key and our instance of db2 choked on blob(500000 K)):

create table index_discovery (name_ varchar(50) not null, value_ blob(500000000) , size_ integer , lf_ timestamp , deleted_ smallint, primary key (name_) )

Checking through the DB2 documentation, the 500000 K seems like correct syntax but it didn't like that.

 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.