To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=95880
Issue #|95880
Summary|Error on creation of table view
Component|Database access
Version|OOo 2.4.1
Platform|Opteron/x86_64
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|intuited
------- Additional comments from [EMAIL PROTECTED] Wed Nov 5 16:59:08 +0000
2008 -------
When attempting to create a table view I'm getting the following error message:
S1000 General error java.lang.StringIndexOutOfBoundsException: start > end in
statement [
SELECT "RSU"."retail unit ID", "RPO"."override price"
FROM "Retail Sales Units" AS "RSU", "Retail Price Overrides" AS "RPO"
WHERE "RSU"."retail unit ID" = "RPO"."retail unit ID"
AND "RPO"."override date" = (
SELECT MAX( "RPO2"."override date" )
FROM "Retail Price Overrides" AS "RPO2", "Current Business Rules" AS "CBR"
WHERE "RSU"."retail unit ID" = "RPO2"."retail unit ID"
AND (
( "CBR"."override price usage policy" = 2
AND ( "RPO2"."approval status" = 2 OR "RPO2"."approval status" = 0 )
) OR (
"CBR"."override price usage policy" = 1
AND ( "RPO2"."approval status" = 2 )
)
)
) ]
Note that i've reformatted the message by adding carriage returns and
indentation for legibility.
The same query, when set up as a Query, works without problems, both with and
without the Edit->Run SQL Command Directly option checked.
This error occurs when creating a Table View by drag-and-dropping the working
query to the Tables tab, when creating a Table View using Insert -> View, and
also when entering a CREATE VIEW statement in the Execute SQL... dialog.
Table views of shorter lengths are working without problems.
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
