To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=78577
User atjensen changed the following:
What |Old value |New value
================================================================================
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Jun 18 06:09:28 +0000
2007 -------
I can confirm this.
In the attached database if you open the query "numbertitle2-broken" in SQL view
you can fix-up the sql to be:
SELECT "main"."ID", "numbers"."title" AS "n1title", "numbers_1"."title" AS
"n2title" FROM "main", "numbers" "numbers", "numbers" "numbers_1" WHERE (
"main"."number1" = "numbers"."ID" AND "numbers_1"."ID" = "main"."number2" )
Then it will execute with no errors in SQL view. If you save it and open it,
again in SQL view no problem. Switch to designer view and it appears to be
correct also, but try to run it from designer view and then the error happens.
The SQL is reverted back to
SELECT "main"."ID", "numbers"."title" AS "n1title", "numbers_1"."title" AS
"n2title" FROM "main", "numbers" WHERE ( "main"."number1" = "numbers"."ID" AND
"numbers_1"."ID" = "main"."number2" )
Also, this may be a duplicate...I believe there is another issue dealing with
table aliases.
---------------------------------------------------------------------
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]
