Very poor performance of SIMILAR TO on some arguments + unable to disconnect
via DELETE FROM MON$ATTACHMENTS
Key: CORE-3858
URL: http://tracker.firebirdsq
On 05/29/12 16:58, Dalton Calford wrote:
> On 29 May 2012 03:51, Alex Peshkoff wrote:
>> There is syntax problem with providing comments on privileges -
>> privileges do not have names.
>
> Is it not possible to extend the syntax of the comment on DDL? for example
>
> COMMENT ON [SELECT|UPDATE|IN
On 29 May 2012 03:56, Dimitry Sibiryakov wrote:
>
>Why not to keep all comments in a separate table? It should decrease
> fragmentation of
> main tables and speed up work with them.
>
>
This sounds reasonable
--
Live S
On 29 May 2012 03:51, Alex Peshkoff wrote:
>
> There is syntax problem with providing comments on privileges -
> privileges do not have names.
Is it not possible to extend the syntax of the comment on DDL? for example
COMMENT ON [SELECT|UPDATE|INSERT|DELETE|ALL] GRANT FOR [USER|ROLE] UPON
[TABL
On 29.05.2012 00:49, Michal Kubecek wrote:
> On Mon, May 28, 2012 at 07:34:28PM +0200, Michal Kubecek wrote:
>>
>> I did experiment a bit and it seems that locale (most likely LC_CTYPE,
>> unfortunately the one that needs to be set for libedit to work), affects
>> only output with "set list off", w
29.05.2012 9:51, Alex Peshkoff wrote:
> Adding new field to existing table(s) is not a problem in ODS12 (FB3).
Why not to keep all comments in a separate table? It should decrease
fragmentation of
main tables and speed up work with them.
--
WBR, SD.
-
On 05/29/12 00:43, Dalton Calford wrote:
> COMMENT ON ** IS {'*sometext*' | NULL}
> ** ::= DATABASE
>| ** *objectname*
>| COLUMN *relationname*.*fieldname*
>| PARAMETER *procname*.*paramname*
> ** ::= CHARACTER SET | COLLATION | D
