[dba-issues] [Issue 108415] Query Wizard not working with Date fields in langpacks
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108415 User oj changed the following: What|Old value |New value Status whiteboard| |reviewed --- Additional comments from o...@openoffice.org Thu Feb 10 08:49:21 + 2011 --- . - 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 108415] Query Wizard not working with Date fields in langpacks
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108415 --- Additional comments from jimmyj...@openoffice.org Mon Jan 10 13:49:58 + 2011 --- Thanks oj. Good work! - 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 108415] Query Wizard not working with Date fields in langpacks
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108415 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED Target milestone|OOo 3.x |OOo 3.4 --- Additional comments from o...@openoffice.org Mon Jan 10 12:44:32 + 2011 --- Fixed in cws 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 108415] Query Wizard not working with Date fields in langpacks
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108415 User thorstenziehm changed the following: What|Old value |New value Target milestone|OOo 3.2.1 |OOo 3.x --- Additional comments from thorstenzi...@openoffice.org Mon Jun 14 14:04:36 + 2010 --- I clean up the open issues for OOo 3.2.1. This release is final and released. I re-target this issue to target OOo 3.x. If the priority is high and it should be fixed in the next release, please change the target accordingly. - 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 108415] Query Wizard not working with Date fields in langpacks
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108415 --- Additional comments from r4z...@openoffice.org Fri Mar 19 10:00:04 + 2010 --- Created an attachment (id=68427) test database with queries created by wizards in langpacks - 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 108415] Query Wizard not working with Date fields in langpacks
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108415 --- Additional comments from r4z...@openoffice.org Fri Mar 19 09:54:52 + 2010 --- I tested again on win7 with Hungarian, Russian, Swedish, and German RC5 langpacks on en_US version of OOo 3.2 final. Created an example file, in Swedish settings, and queries with wizard in each different language settings. I upload this example. - 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 108415] Query Wizard not working with Date fields in langpacks
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108415 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW Keywords| |regression Priority|P4|P3 Target milestone|--- |OOo 3.2.1 --- Additional comments from atjen...@openoffice.org Thu Mar 18 20:55:14 + 2010 --- Confirmed @zoltan --- Yes, now I read issue text again and more carefully. I can confirm the issue. I installed Finnish langpack, and the query wizard created erroneous values in query, I added date in wizard, and get letters mixed in. The platform was opensuse 11.2, i586 - original issue submitted on win7, it is on all platform issue. I tested with Hungarian and Russian langpack, no such problems. @oj - not sure who to assign this to either - so here you go - 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 108415] Query Wizard not working with Date fields in langpacks
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108415 User atjensen changed the following: What|Old value |New value CC|'hatapitk'|'atjensen,hatapitk' - 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 108415] Query Wizard not working with Date fields in langpacks
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108415 --- Additional comments from ris...@openoffice.org Thu Feb 18 08:24:03 + 2010 --- Created an attachment (id=67894) Errormessage using Query Wizard with Date - 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 108415] Query Wizard not working with Date fields in langpacks
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108415 User ristoi changed the following: What|Old value |New value Priority|P5|P4 --- Additional comments from ris...@openoffice.org Thu Feb 18 08:21:36 + 2010 --- Also Spanish Base give this error. Because it is one of most important languages in OpenOffice.org the priority is now a bit upgraded. I try to attach a clip from display of error message. But I think that I can predict error from this table: [hd_id3153514]Number Format Codes [par_id1002200811563044]Locale If there is letter in column which is used in SQL Date format then there is error. - 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 108415] Query Wizard not working with Date fields in langpacks
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108415 User hatapitk changed the following: What|Old value |New value CC|''|'hatapitk' - 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 108415] Query Wizard not working with Date fields in langpacks
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108415 Issue #|108415 Summary|Query Wizard not working with Date fields in langpacks Component|Database access Version|OOO320m9 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P5 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ristoi --- Additional comments from ris...@openoffice.org Mon Jan 18 13:00:06 + 2010 --- Query Wizard handles wrongly Dates (or Timestamps) in langpacks. Conditions: Database with Date field. Some other language than english in use. Procedure: Create Query with Query Wizard using search condition with Date field. In my example field Pvm has format: Date[DATE]. Here is some results as SQL: English: SELECT "Table1"."ID" AS "ID", "Table1"."First" AS "First", "Table1"."Other" AS "Other", "Table1"."Pvm" AS "Pvm" FROM "Table1" "Table1" WHERE ( "Table1"."Pvm" <= {D '2010-01-02 00:00:00' } ) Obervation: there is no letters from date format code and query is working. Swedish: SELECT "Table1"."ID" AS "ID", "Table1"."Other" AS "Other", "Table1"."Pvm" AS "Pvm" FROM "Table1" "Table1" WHERE ( "Table1"."Pvm" <= {D '2010-01-02 HH:00:00' } ) Obervation: there is letters from date format code(?) only in the time part and query is working with date field. With Timestamps it is not working. German: SELECT "Table1"."ID" AS "ID", "Table1"."First" AS "First", "Table1"."Other" AS "Other", "Table1"."Pvm" AS "Pvm" FROM "Table1" "Table1" WHERE ( "Table1"."Pvm" <= {D '-01-DD 00:00:00' } ) Obervation: there is letters from date format code(?) only in the date part and query is not working with date field. Finnish: SELECT "Table1"."ID" AS "ID", "Table1"."First" AS "First", "Table1"."Other" AS "Other", "Table1"."Pvm" AS "Pvm" FROM "Table1" "Table1" WHERE ( "Table1"."Pvm" <= {D '-00-DD HH:00:00' } ) Obervation: there is letters from date format code(?) both in the date part and the time part and month is replaced with "00". Query is not working with date field. It is possible that this is problem with localizations. But at least is seem to be very easy to make national bugs here. So some help is needed for localizations? As far as I know original language of database make no difference. Paremman huomisen toivossa Risto Jääskeläinen - 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