Re: Re: Blues Thursday 3-18-2010 or Hug a Bug day 1

2010.03.18. 20:47 keltezéssel, Drew Jensen írta:
> On 3/18/2010 2:56 PM, Reizinger Zoltán wrote:
>> 2010.03.18. 16:27 keltezéssel, Drew Jensen írta:
>>> Is there anyone on the list that could look at this issue:
>>>
>>> http://qa.openoffice.org/issues/show_bug.cgi?id=108415
>>>
>>> Specifically with OO.o 3.2 w/ De or Es language packs.
>>
>> I tried this on Hu version and En of OOo and my problem with SQL syntax
>> used in queries.
>> Queries works in same way, throw exception when try to use YYYY or DD as
>> wildcard in query conditions, as
>>
>> in this example: ..... WHERE ( "Table1"."Pvm"<= {D 'YYYY-01-DD 00:00:00'
>> } )
>>
>>
>> This method is not usable in queries, if I know well.
>> The issue seems to me is invalid.
>> Correct me if I wrong.
>
> Hello Zoltan,
>
> I believe the issue was that when the query wizard was used to 
> construct the SQL, that when certain language packs where used the 
> query was defective.
>
> so I have a table with fields ID, D1, dt (where dt is a TimeStamp field)
>
> When I entered data in the dt field I only entered dates, no times so 
> all the data is dd/mm/yy 00:00:00
>
> Using the query wizard I select the table, select all the fields and 
> on the wizard tab for adding the where clause I select the field dt 
> and add a condition again only entering a date. No time value.
>
> Using DEV300m_75 en I get this SQL statement from the wizard:
>
> SELECT "Table1"."id" AS "id", "Table1"."D1" AS "D1", "Table1"."dt" AS 
> "dt" FROM "Table1" "Table1" WHERE ( "Table1"."dt" > {D '2010-01-15 
> 00:00:00' } )
>
> If I understand the reporter(s) issue, using a De or Es one gets the 
> errant SQl, such as you describe.
>
> Does make sense?
>
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.

I have no idea whom to assign this, please do it.

Zoltan