To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=95880
------- Additional comments from [EMAIL PROTECTED] Thu Nov 6 20:50:23 +0000
2008 -------
Correction: it looks like this isn't a java bug. I'm still using the Sun Java
VM, and I've gotten the same error again. To reproduce the bug I first did
DROP VIEW "Current Business Rules" CASCADE
in Tools->SQL, then restarted OpenOffice Database, and entered a series of
commands into Tools->SQL, all in one big chunk, by copy-pasting the entirety of
the second attached file (current_business*.script.sql).
When I did that, the first CREATE VIEW statement ("Current Business Rules")
executed successfully. The second CREATE VIEW statement, to create the view
"Current Retail Override Prices", caused the same error as before
(...StringIndexOutOfBoundsException ... "begin > end"...). Subsequent attempts
to execute this statement, even with other statements removed from the
Tools->SQL textbox, failed for the same reasons.
I saved the database, exited OpenOffice, and reopened my database. I
copy-pasted the commands over again and deleted the first command and the
comment so that the string of commands started with CREATE VIEW "Current Retail
Override Prices". Clicking Execute at this point successfully executed that
command and created the view.
The rest of the commands were also accepted, though of course I had to take
out the ones for already-existing views. Although there are some very long
commands in the list, the one causing the problem is completely on one line, and
that line is a lot longer than any other lines in the script.
The reconstructed database is working okay.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
