To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=114188
User fs changed the following:
What |Old value |New value
================================================================================
Target milestone|--- |OOo Later
--------------------------------------------------------------------------------
------- Additional comments from f...@openoffice.org Thu Sep 2 09:12:23 +0000
2010 -------
I agree to this being an enhancement, since it seems that the HSQLDB is
responsible here, by not accepting this particular statement having an ORDER BY
clause in a sub select.
That is, if you create a native query constituted by
SELECT "ThrowNum", "Heads"
FROM
(
SELECT "ThrowNum", "MoreThanHalf" AS "Heads"
FROM "View"
ORDER BY "Heads" ASC
)
WHERE "Heads" = True
an switch on "Direct SQL", then this already leads to an error. And in this
case, Base is not involved at all, it just passes the SQL to HSQLDB. So, it
really looks like a limitation of the latter, not the former.
---------------------------------------------------------------------
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
