[dba-issues] [Issue 114189] Base crashes when using f ilters / sorts on some query results with calc ulated boolean fields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114189 User oj changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from o...@openoffice.org Tue Oct 5 07:23:26 + 2010 --- Closing. - 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 114189] Base crashes when using f ilters / sorts on some query results with calc ulated boolean fields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114189 User oj changed the following: What|Old value |New value Status|STARTED |RESOLVED Resolution| |FIXED --- Additional comments from o...@openoffice.org Wed Sep 1 09:25:09 + 2010 --- Fixed in cws dba33i - 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 114189] Base crashes when using f ilters / sorts on some query results with calc ulated boolean fields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114189 User ul changed the following: What|Old value |New value OtherIssuesDependingOnTh| |12 is| | - 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 114189] Base crashes when using f ilters / sorts on some query results with calc ulated boolean fields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114189 User oj changed the following: What|Old value |New value Status|NEW |STARTED --- Additional comments from o...@openoffice.org Wed Sep 1 06:59:12 + 2010 --- . - 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 114189] Base crashes when using f ilters / sorts on some query results with calc ulated boolean fields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114189 User oj changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW OS/Version|Mac OS X, 10.5|All Platform|Macintosh |All Status whiteboard| |regression Target milestone|--- |OOo 3.3 --- Additional comments from o...@openoffice.org Wed Sep 1 06:56:45 + 2010 --- Worked in a.2 - 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 114189] Base crashes when using f ilters / sorts on some query results with calc ulated boolean fields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114189 --- Additional comments from amel...@openoffice.org Mon Aug 30 18:33:12 + 2010 --- Created an attachment (id=71486) New Test Database - 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 114189] Base crashes when using f ilters / sorts on some query results with calc ulated boolean fields
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=114189
User ameliab changed the following:
What|Old value |New value
Status|RESOLVED |UNCONFIRMED
Resolution|WORKSFORME|
Summary|Base crashes when using qu|Base crashes when using fi
|ery filters / sorts on col|lters / sorts on some quer
|umns created by correlated|y results with calculated
| subqueries |boolean fields
--- Additional comments from amel...@openoffice.org Mon Aug 30 18:31:30
+ 2010 ---
The file I'd posted is definitely still crashing and/or hanging on Mac OSX for
me. I re-downloaded to make sure the version saved on my computer wasn't
corrupted, and got the exact same behaviour as yesterday.
So... maybe an operating system-unique problem? Any other Mac users want to
give it a try?
*However*, I appear to have been wrong about what caused the crash. I tried
reproducing it in another test database, and very similar queries work fine --
but then others crashed.
After experimentation, I think I've narrowed it down to the boolean field that
is causing crashes, rather than the correlated subqueries. Which is strange
because I used two completely different ways of generating the boolean field
(one using a boolean expression, the other casting from a number).
The casting method (e.g., CAST(CAST("Random"*2 AS Integer) AS Boolean) ), run
through OO's SQL parser, results in crashes when I apply a filter to the boolean
field (sorts are okay), but *only* if I also have the primary key in the query.
(Note: these are "neat" crashes, where OO recovers itself without having to be
relaunched from the operating system)
The same query sent directly to the embedded HSQL DB, does not cause any
crashing when I try to sort/filter the results, although sorts and filters have
no effect (as noted in issue 114187).
The alternate method, using a boolean expression as a column definition (e.g.
SELECT "Random" >= 0.5 as "MoreThanHalf"), is not acceptable to OpenOffice's SQL
parser. When the query is sent directly to the HSQL DB, any attempt to apply a
filter or sort on the results either causes a complete crash of OpenOffice or
(in one case that I then couldn't reproduce) an indefinite hang.
I've changed the title of this issue to correspond to this new understanding,
and I'll attach my new file.
In the file, I've again got one table with just a list of random numbers and an
auto-generated primary key for each. All the queries are based directly on this
table. Each query name clearly indicates:
(1) whether it is sent directly to the embedded database ("DirectQuery") or
through the OpenOffice parser ("Query");
(2) What values it selects:
PK -- the primary key from the original table
Num -- a number value from the original table
Boolean -- a boolean value created by performing arithmetic and cast()
function on the number
BooleanExp -- a boolean value defined as a boolean expression
(I've gotten rid of the subquery-based fields, since they didn't affect the
outcome and were just complicating matters.)
(3) the behaviour (e.g., complete or "neat" crash, or hang) that happens on my
Mac.
---
Anyway, this has now become a very obscure problem, but at least I know which
particular conditions to avoid in my original database!
-
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
