Bug in SIMILAR TO when adding numeric quantifier as bound for repetetion of expression leads to empty resultset [CORE5957] #6211
Assignees
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Beta 2 [ 10888 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Done successfully |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: @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}';
============
1
Records affected: 1
SQL> quit;
PS.
No errors in 2.5 when instead of "{1}" we add * or + ( asterisk or 'plus' sign)
The text was updated successfully, but these errors were encountered: