[#KNL-160] syntax error in sakai_content.sql for DB2

Kernel - K1

syntax error in sakai_content.sql for DB2

Created: 16-Apr-2009 08:07 Updated: 05-Mar-2010 02:48

Component/s:

Other

Affects Version/s:

1.0.14, 1.1.0

Fix Version/s:

1.0.6, 1.1.0

Time Tracking:

Original Estimate:

1 day

Remaining Estimate:

1 day

Time Spent:

Not Specified

File Attachments:	1. KNL-160.patch (0.5 kB)
Environment:	DB2

1.0.x Status:

Resolved

Description

« Hide

This fix was for DB2 and addressed in ~~KNL-146~~ and SAK-15410 for increasing the size of BLOB to 2G bytes. Problem is a syntax error in CREATE TABLE CONTENT_RESOURCE_BODY_BINARY:
should be BODY BLOB(2G) NOT LOGGED

The code has a curly brace followed by a close parenthesis: BLOB{2G)

All

Comments

Work Log

Change History

Subversion Commits

git Commits

Sort Order:

[ Permlink | « Hide ]

David Horwitz added a comment - 16-Apr-2009 08:23

Hi Adam,

I trust this is right:

BODY BLOB(2G) NOT LOGGED