| Subject | Re: [firebird-support] Strange SIMILAR TO result |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2018-05-07T10:26:15Z |
07.05.2018 12:19, Gabor Boros mlnglsts@... [firebird-support] wrote:
'[A-Z]{2}[0-9A-Z]{2,13}'".
(''='') is true and string representation of true is 'TRUE ' that matches your patters.
--
WBR, SD.
> A simple example: SELECT ''='' SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROMYour expression is actually calculated as "CAST(''='' as CHAR(5)) SIMILAR TO
> RDB$DATABASE
>
> Why is the result true?
'[A-Z]{2}[0-9A-Z]{2,13}'".
(''='') is true and string representation of true is 'TRUE ' that matches your patters.
--
WBR, SD.