SQL> create database 'tmp201501081945.fdb'; commit;
SQL>  set autoddl off; 
SQL> commit;
SQL> -- set transaction NO wait; -- на результат не повлияет
SQL> create domain dm_01 as int;
SQL> show domain;
-- ЗДЕСЬ ПРИДЁТСЯ ЖДАТЬ 10 СЕК, НЕЗАВИСИМО ОТ SET TRAN NO WAIT :(
Statement failed, SQLSTATE = 40001
deadlock
-read conflicts with concurrent update
-concurrent transaction number is 5
Command error: show collation

2015-01-08T19:53:41.0150 (2516:01BE5068) EXECUTE_STATEMENT_FINISH
        C:\1INSTALL\FIREBIRD\FB30SNAP\TMP201501081950.FDB (ATT_1, SYSDBA:NONE, NONE, <internal>)
                (TRA_ 10 , CONCURRENCY | NOWAIT | READ_WRITE)

-------------------------------------------------------------------------------
create domain dm_01 as int
0 records fetched
      0 ms


2015-01-08T19:53:48.9680 (2516:01BE5068) START_TRANSACTION
        C:\1INSTALL\FIREBIRD\FB30SNAP\TMP201501081950.FDB (ATT_1, SYSDBA:NONE, NONE, <internal>)
                (TRA_ 11 , READ_COMMITTED | NO_REC_VERSION | WAIT | READ_WRITE)

2015-01-08T19:53:58.9680 (2516:01BE5068) ERROR AT JRequest::start
        C:\1INSTALL\FIREBIRD\FB30SNAP\TMP201501081950.FDB (ATT_1, SYSDBA:NONE, NONE, <internal>)
335544336 : deadlock
335545096 : read conflicts with concurrent update
335544878 : concurrent transaction number is 10

2015-01-08T19:53:58.9680 (2516:01BE5068) COMMIT_TRANSACTION
        C:\1INSTALL\FIREBIRD\FB30SNAP\TMP201501081950.FDB (ATT_1, SYSDBA:NONE, NONE, <internal>)
                (TRA_11, READ_COMMITTED | NO_REC_VERSION | WAIT | READ_WRITE)
      0 ms, 1 read(s), 2 write(s), 1 fetch(es), 1 mark(s)