[ openjms-Bugs-947723 ] syntax errors in create_sybase.sql

Bugs item #947723, was opened at 2004-05-05 00:38
Message generated for change (Comment added) made by tanderson
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=947723&group_id=54559

Category: persistence
Group: v0.7.6
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Robert T. Brown (dashrb)
>Assigned to: Tim Anderson (tanderson)
Summary: syntax errors in create_sybase.sql

Initial Comment:
In 0.7.6, the create_sybase.sql script contains 2
syntax errors.
1. It attempts to create an index on a non-existent
table message_id.
2. It contains a semicolon in an invalid location.


Patch shown:
[email protected]{42}cvs -z3
-d:pserver:[email protected]:/cvsroot/openjms
diff -u -w create_sybase.sql
Index: create_sybase.sql
===================================================================
RCS file:
/cvsroot/openjms/openjms/src/config/db/create_sybase.sql,v
retrieving revision 1.2
diff -u -w -r1.2 create_sybase.sql
--- create_sybase.sql   3 Jan 2004 03:31:57 -0000       1.2
+++ create_sybase.sql   4 May 2004 13:44:49 -0000
@@ -11,11 +11,6 @@
 alter table system_data lock datarows
 go
 
-create unique index message_id_pk on message_id(id)
-go
-alter table message_id lock datarows
-go
-
 drop table seeds
 go
 create table seeds (
@@ -95,7 +90,7 @@
 create table users (
   username             varchar(50) not null,
   password             varchar(50) not null
-);
+)
 go
 create unique index users_pk on users(username)
 go

----------------------------------------------------------------------

>Comment By: Tim Anderson (tanderson)
Date: 2004-05-05 16:37

Message:
Logged In: YES 
user_id=557161

Patch applied thanks. Note that patches should be added as 
attachments, as the bugtracker mangles the text making it 
unsuitable for use by the patch command.

Fix will be available in the 0.7.6.1 release.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=947723&group_id=54559


-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. 
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click