Subject Re: [firebird-support] Re: 1=1 in where gets a bad performance
Author Helen Borrie
At 10:06 PM 15/11/2008, you wrote:




>>
>> See Set's comments - fix up your wizard so that it doesn't inject
>spurious search arguments.
>
>The problem is that I do not have the wizard source, it is a purchased
>component. I thought that FB optimizer cleans these type of things,
>the solution will be that I do a pre-filter to remove these spurious
>arguments.
>
>
>
>>
>> I'm just curious to know how your date literal format managed to get
>through without an exception...
>
>
>I am sorry, I am not sure what you mean. DO you mean why I use
>yyyy/mm/dd format in dates? because it is clear for everybody,
>mm/dd/yy is confusing for many countries that use dd/mm/yy

No, I don't mean *why* do you use them. I mean, how do you manage to use them and avoid getting validation errors. I mean that 'mm/dd/yyyy' is the only valid date literal format that uses the slash separator. So I was (and am still) curious as to how you avoid the exceptions.

Valid string literal masks for ISO date format include 'yyyymmdd' and 'yyyy-mm-dd'. There are a few others...

./heLen