[dba-issues] [Issue 20306] SQL function LIMIT fails when Analyze SQL command is set to YES

2011-02-21 Thread msc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=20306


User msc changed the following:

What|Old value |New value

  Status|RESOLVED  |VERIFIED





--- Additional comments from m...@openoffice.org Mon Feb 21 09:41:06 + 
2011 ---
However it's still not possible to switch to the graphic design. The LIMIT and
OFFSET keyword can only be insert into the SQL view.

If someone wants it also in the graphic view please write a new issue.

verified in CWS dba34c

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/dba34c

-
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



[dba-issues] [Issue 20306] SQL function LIMIT fails when Analyze SQL command is set to YES

2011-01-14 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=20306


User oj changed the following:

What|Old value |New value

 Assigned to|oj|msc





--- Additional comments from o...@openoffice.org Fri Jan 14 08:36:26 + 
2011 ---
Please verify. Thanks.

repro:

SELECT * FROM `testdb`.`employees` AS `employees` LIMIT 10 OFFSET 3

now works

-
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