2017-05-04T15:43:47.7350 (29644:00000000010FD9E8) PREPARE_STATEMENT

S-MARKET.FDB (ATT_2699872, SYS_EDO:NONE, NONE, TCPv4:10.1.60.241)

C:\_programs\1C\_Folders\000016\8.3.9.2170\bin\1cv8.exe:5168

(TRA_32198262, READ_COMMITTED | REC_VERSION | WAIT | READ_WRITE)



Statement 307016496:

-------------------------------------------------------------------------------

select cast ('' as varchar(7)) as table_cat,cast (tbl.rdb$owner_name as varchar(31)) as table_schem,cast (tbl.rdb$relation_name as varchar(31)) as table_name,cast (priv.rdb$grantor as varchar(31)) as grantor,cast (priv.rdb$user as varchar(31)) as grantee,cast (priv.rdb$privilege as varchar(11)) as privilege,cast ('YES' as varchar(3)) as isgrantable, priv.rdb$grant_option as GRANT_OPTION from rdb$relations tbl, rdb$user_privileges priv
where tbl.rdb$relation_name = priv.rdb$relation_name
and tbl.rdb$relation_name = 'RDB$ROLES'
order by tbl.rdb$relation_name, priv.rdb$privilege, priv.rdb$user

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN SORT (JOIN (PRIV INDEX (RDB$INDEX_29), TBL INDEX (RDB$INDEX_0)))

9 ms



2017-05-04T15:43:47.7510 (29644:00000000010FD9E8) EXECUTE_STATEMENT_START

S-MARKET.FDB (ATT_2699872, SYS_EDO:NONE, NONE, TCPv4:10.1.60.241)

C:\_programs\1C\_Folders\000016\8.3.9.2170\bin\1cv8.exe:5168

(TRA_32198262, READ_COMMITTED | REC_VERSION | WAIT | READ_WRITE)



Statement 307016496:

-------------------------------------------------------------------------------

select cast ('' as varchar(7)) as table_cat,cast (tbl.rdb$owner_name as varchar(31)) as table_schem,cast (tbl.rdb$relation_name as varchar(31)) as table_name,cast (priv.rdb$grantor as varchar(31)) as grantor,cast (priv.rdb$user as varchar(31)) as grantee,cast (priv.rdb$privilege as varchar(11)) as privilege,cast ('YES' as varchar(3)) as isgrantable, priv.rdb$grant_option as GRANT_OPTION from rdb$relations tbl, rdb$user_privileges priv
where tbl.rdb$relation_name = priv.rdb$relation_name
and tbl.rdb$relation_name = 'RDB$ROLES'
order by tbl.rdb$relation_name, priv.rdb$privilege, priv.rdb$user

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN SORT (JOIN (PRIV INDEX (RDB$INDEX_29), TBL INDEX (RDB$INDEX_0)))



2017-05-04T15:43:47.7510 (29644:00000000010FD9E8) CLOSE_CURSOR

S-MARKET.FDB (ATT_2699872, SYS_EDO:NONE, NONE, TCPv4:10.1.60.241)

C:\_programs\1C\_Folders\000016\8.3.9.2170\bin\1cv8.exe:5168



Statement 307016496:

-------------------------------------------------------------------------------

select cast ('' as varchar(7)) as table_cat,cast (tbl.rdb$owner_name as varchar(31)) as table_schem,cast (tbl.rdb$relation_name as varchar(31)) as table_name,cast (priv.rdb$grantor as varchar(31)) as grantor,cast (priv.rdb$user as varchar(31)) as grantee,cast (priv.rdb$privilege as varchar(11)) as privilege,cast ('YES' as varchar(3)) as isgrantable, priv.rdb$grant_option as GRANT_OPTION from rdb$relations tbl, rdb$user_privileges priv
where tbl.rdb$relation_name = priv.rdb$relation_name
and tbl.rdb$relation_name = 'RDB$ROLES'
order by tbl.rdb$relation_name, priv.rdb$privilege, priv.rdb$user

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN SORT (JOIN (PRIV INDEX (RDB$INDEX_29), TBL INDEX (RDB$INDEX_0)))



2017-05-04T15:43:47.7510 (29644:00000000010FD9E8) ERROR AT jrd8_free_statement

S-MARKET.FDB (ATT_2699872, SYS_EDO:NONE, NONE, TCPv4:10.1.60.241)

C:\_programs\1C\_Folders\000016\8.3.9.2170\bin\1cv8.exe:5168

335544569 : Dynamic SQL Error
335544436 : SQL error code = -501
335544577 : Attempt to reclose a closed cursor


2017-05-04T15:43:47.7510 (29644:00000000010FD9E8) FREE_STATEMENT

S-MARKET.FDB (ATT_2699872, SYS_EDO:NONE, NONE, TCPv4:10.1.60.241)

C:\_programs\1C\_Folders\000016\8.3.9.2170\bin\1cv8.exe:5168



Statement 307016496:

-------------------------------------------------------------------------------

select cast ('' as varchar(7)) as table_cat,cast (tbl.rdb$owner_name as varchar(31)) as table_schem,cast (tbl.rdb$relation_name as varchar(31)) as table_name,cast (priv.rdb$grantor as varchar(31)) as grantor,cast (priv.rdb$user as varchar(31)) as grantee,cast (priv.rdb$privilege as varchar(11)) as privilege,cast ('YES' as varchar(3)) as isgrantable, priv.rdb$grant_option as GRANT_OPTION from rdb$relations tbl, rdb$user_privileges priv
where tbl.rdb$relation_name = priv.rdb$relation_name
and tbl.rdb$relation_name = 'RDB$ROLES'
order by tbl.rdb$relation_name, priv.rdb$privilege, priv.rdb$user

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN SORT (JOIN (PRIV INDEX (RDB$INDEX_29), TBL INDEX (RDB$INDEX_0)))