You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
--This simple query take more than 16 secs of execution:
select iif ('abc.abc' similar to '[[:ALPHA:].]{1,60}.ab' ,1,0) is_similar from rdb$database
--Then add one more symbol to text, and execution take more then 2 MINUTES!!!
select iif ('abcd.abc' similar to '[[:ALPHA:].]{1,60}.ab' ,1,0) is_similar from rdb$database
If the test string is even longer than 4 symbols, then the server hangs forever!
The text was updated successfully, but these errors were encountered:
The same geometric growth of time execution can be obtained by increasing the maximum number of symbols in regexp: {1,60}, {1,80}, {1,100}, etc.
So, this query take more then 2 minutes:
select iif ('abc.abc' similar to '[[:ALPHA:].]{1,80}.ab' ,1,0) is_similar from rdb$database
Submitted by: Sergey Borisov (bsv)
Duplicates CORE5664
--This simple query take more than 16 secs of execution:
select iif ('abc.abc' similar to '[[:ALPHA:].]{1,60}.ab' ,1,0) is_similar from rdb$database
--Then add one more symbol to text, and execution take more then 2 MINUTES!!!
select iif ('abcd.abc' similar to '[[:ALPHA:].]{1,60}.ab' ,1,0) is_similar from rdb$database
If the test string is even longer than 4 symbols, then the server hangs forever!
The text was updated successfully, but these errors were encountered: