[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 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 --- 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 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 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 --- 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 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 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 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 --- 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
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
[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
