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

[SourceForge.net]

Bugs item #947723, was opened at 2004-05-04 10:38
Message generated for change (Tracker Item Submitted) made by Item Submitter
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: Open
Resolution: None
Priority: 5
Submitted By: Robert T. Brown (dashrb)
Assigned to: Jim Alateras (jalateras)
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:
***@cyclone{42}cvs -z3
-d:pserver:***@cvs.sourceforge.net:/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

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

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

[SourceForge.net]

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:
***@cyclone{42}cvs -z3
-d:pserver:***@cvs.sourceforge.net:/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