Bug in SIMILAR TO when adding numeric quantifier as bound for repetetion of
expression leads to empty resultset
---------------------------------------------------------------------------------------------------------------
Key: CORE-5957
URL: http://tracker.firebirdsql.org/browse/CORE-5957
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.8
Reporter: Pavel Zotov
Only 2.5.x is affected. No error in 3.0.x and 4.x.
C:\MIX\firebird\fb30>C:\MIX\firebird\fb25\bin\isql /:e25 -z
ISQL Version: WI-V2.5.9.27119 Firebird 2.5
Server version:
WI-V2.5.9.27119 Firebird 2.5
WI-V2.5.9.27119 Firebird 2.5/tcp (csprog)/P12
WI-V2.5.9.27119 Firebird 2.5/tcp (csprog)/P12
Database: /:e25
SQL> set count on;
SQL> select 1 from rdb$database where 'SLEEP' similar to
'(DELAY|SLEEP|PAUSE){1}';
Records affected: 0
SQL>
=== vs ===
C:\MIX\firebird\fb30>C:\MIX\firebird\fb30\isql /:e30 -z
ISQL Version: WI-V3.0.5.33075 Firebird 3.0
Server version:
WI-V3.0.5.33075 Firebird 3.0
WI-V3.0.5.33075 Firebird 3.0/tcp (csprog)/P15
WI-V3.0.5.33075 Firebird 3.0/tcp (csprog)/P15
Database: /:e30, User: SYSDBA
SQL> set count on;
SQL> select 1 from rdb$database where 'SLEEP' similar to
'(DELAY|SLEEP|PAUSE){1}';
CONSTANT
============
1
Records affected: 1
SQL> quit;
PS.
No errors in 2.5 when instead of "{1}" we add * or + ( asterisk or 'plus' sign)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
