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
C:\MIX\firebird\fb25>bin\isql -n -c 2048 localhost/3050:C:\MIX\firebird\fb25\T1.FDB
Database: localhost/3050:C:\MIX\firebird\fb25\T1.FDB
SQL> show version;
ISQL Version: WI-V2.5.2.26482 Firebird 2.5
Server version:
Firebird/x86/Windows NT (access method), version "WI-V2.5.2.26482 Firebird 2.5"
Firebird/x86/Windows NT (remote server), version "WI-V2.5.2.26482 Firebird 2.5/tcp (csprog)/P12"
Firebird/x86/Windows NT (remote interface), version "WI-V2.5.2.26482 Firebird 2.5/tcp (csprog)/P12"
on disk structure version 11.2
SQL> select iif('sdf--asdf_sd.dsfsfh-.sdjskdjfh-_.' SIMILAR TO '(([[:ALNUM:]\_\-])+.?)+([[:ALNUM:]\_\-])+' escape '\', 1, 0) from rdb$database;
-- This query will run about 9 minutes.
Furthermore,
1) it can not be interrupted in another ('monitoring') windows if I issue there: DELETE FROM MON$ATTACHMENTS WHERE ...; COMMIT;
2) CPU is loaded about 100%
3) There is no ability to connect to any database on that machine untill this "strange query" will finish.
select 1 from rdb$database where
'
group by
MATCODE,
MATNAME,
NOTE,
GROUPCODE,
STATE,
MATPROD,
MATFULL,
KOLVO,
EDIZM,
MATGRPCOD,
CODE,
TEXTTOHIST,
INV_ROOMDOC,
INV_ROOM,
PARENTCODE,
INVIS
'
similar to
'%group[[:WHITESPACE:]]+by[[:WHITESPACE:]]+([[:ALNUM:]]|_)+([[:WHITESPACE:]]*,[[:WHITESPACE:]]*[[:ALNUM:]]+){12,}[[:WHITESPACE:]]*%'
;
NOTE on this part of pattern:
([[:ALNUM:]]|_)+
It is underscore character that is "reason" of very poor performance.
Yes, i understand that escape character should be placed leftside of "_"; but one may to forgot to do this and result will be very bad.
Submitted by: @pavel-zotov
Relate to CORE4810
C:\MIX\firebird\fb25>bin\isql -n -c 2048 localhost/3050:C:\MIX\firebird\fb25\T1.FDB
Database: localhost/3050:C:\MIX\firebird\fb25\T1.FDB
SQL> show version;
ISQL Version: WI-V2.5.2.26482 Firebird 2.5
Server version:
Firebird/x86/Windows NT (access method), version "WI-V2.5.2.26482 Firebird 2.5"
Firebird/x86/Windows NT (remote server), version "WI-V2.5.2.26482 Firebird 2.5/tcp (csprog)/P12"
Firebird/x86/Windows NT (remote interface), version "WI-V2.5.2.26482 Firebird 2.5/tcp (csprog)/P12"
on disk structure version 11.2
SQL> select iif('sdf--asdf_sd.dsfsfh-.sdjskdjfh-_.' SIMILAR TO '(([[:ALNUM:]\_\-])+.?)+([[:ALNUM:]\_\-])+' escape '\', 1, 0) from rdb$database;
-- This query will run about 9 minutes.
Furthermore,
1) it can not be interrupted in another ('monitoring') windows if I issue there: DELETE FROM MON$ATTACHMENTS WHERE ...; COMMIT;
2) CPU is loaded about 100%
3) There is no ability to connect to any database on that machine untill this "strange query" will finish.
Commits: 28e1874
The text was updated successfully, but these errors were encountered: