Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug in SIMILAR TO when adding numeric quantifier as bound for repetetion of expression leads to empty resultset [CORE5957] #6211

Closed
firebird-issue-importer opened this issue Oct 31, 2018 · 4 comments

Comments

@firebird-issue-importer

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}';

CONSTANT

============
1

Records affected: 1
SQL> quit;

PS.

No errors in 2.5 when instead of "{1}" we add * or + ( asterisk or 'plus' sign)

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 10, 2019

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 6, 2019

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Beta 2 [ 10888 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 8, 2019

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 8, 2019

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants