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

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?

Thanks

Drew

(only a few more issues off the unconfirmed list and a new selection of 
music.... *smile*)