2018. 05. 07. 14:46 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] írta:
> 07.05.2018 13:57, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
>> So I see what you say. But result of
>>
>> SELECT CAST(''='' AS CHAR(5)) SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM
>>
Ach now it is clear.
All work ok. You got false for char(5) because it work the same way as it is
working for LIKE with char.
TrySelect cast('ABCD' as char(5)) like 'ABCD' from rdb$database
Regards,Karol Bieniaszewski
null
2018. 05. 07. 14:31 keltezéssel, liviuslivius
liviusliv...@poczta.onet.pl [firebird-support] írta:
> Hi,
>
> It is false for me
> But i put '=' in single quote with double it does not work. I use
> FB3.0.4.32954 dialect 3
Nothing double quote. ''='' is a boolean expression, empty string equal
07.05.2018 13:57, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
> So I see what you say. But result of
>
> SELECT CAST(''='' AS CHAR(5)) SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM
> RDB$DATABASE;
>
> is
>
> ===
>
Perhaps, it must be CHAR(4) or VARCHAR. I'm not sure in type of
Hi,
It is false for meBut i put '=' in single quote with double it does not work. I
use FB3.0.4.32954 dialect 3
Regards,Karol Bieniaszewski
null
2018. 05. 07. 12:26 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] írta:
> 07.05.2018 12:19, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
>> A simple example: SELECT ''='' SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM
>> RDB$DATABASE
>>
>> Why is the result true?
>
>
07.05.2018 12:19, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
> A simple example: SELECT ''='' SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM
> RDB$DATABASE
>
> Why is the result true?
Your expression is actually calculated as "CAST(''='' as CHAR(5)) SIMILAR TO
Hi All,
I accidentally (copy/paste :-) ) make a wrong SELECT which give back
strange (true) result for me.
A simple example: SELECT ''='' SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM
RDB$DATABASE
Why is the result true? I use 3.0.3.
Gabor
