Very poor performance of SIMILAR TO on some arguments + unable to disconnect
via DELETE FROM MON$ATTACHMENTS
------------------------------------------------------------------------------------------------------------
Key: CORE-3858
URL: http://tracker.firebirdsql.org/browse/CORE-3858
Project: Firebird Core
Issue Type: Bug
Reporter: Pavel Zotov
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.
--
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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
