SST_PRESENCES table uses an Oracle 10g reserved word for a column name (date)
GENERAL
TESTING
GENERAL
TESTING
Description
is depended on by
relates to
Activity
Show:
Hudson CI Server February 23, 2011 at 9:10 PM
Integrated in sakai trunk #447 (See http://builds.sakaiproject.org:8080/job/sakai%20trunk/447/)
merge trunk r88650, fix index length for oracle
SAK-19088, STAT-270, SAK-20076, update comments to include missing ticket numbers.
Hudson CI Server February 23, 2011 at 12:30 AM
Integrated in sitestats trunk (build and deploy) #267 (See http://builds.sakaiproject.org:8080/job/sitestats%20trunk%20(build%20and%20deploy)/267/)
fix index length for oracle
adjust date column name to p_date and adjust all references in ddl and updates
Steve Swinsburg February 21, 2011 at 2:29 PM
Second merge to 2.2 at r88652
Steve Swinsburg February 21, 2011 at 2:27 PM
Fixed in 2.8 conversion docs, r88651
Steve Swinsburg February 21, 2011 at 2:22 PM
Fixed in trunk conversion docs, r88650
The 2.8.0 conversions scripts includes the following CREATE TABLE statement that uses an Oracle 10g reserved word for a column name (date). The column should be renamed in order to avoid possible name resolution conflicts.
create table SST_PRESENCES (
ID bigint(20) not null auto_increment,
SITE_ID varchar(99) not null,
USER_ID varchar(99) not null,
DATE date not null,
DURATION bigint(20) not null default '0',
LAST_VISIT_START_TIME datetime default null,
primary key (ID)
);
For Oracle 10g reserved words see: http://download.oracle.com/docs/cd/B19306_01/em.102/b40103/app_oracle_reserved_words.htm