Re: [Firebird-devel] Confusing message when security3 is not found

On 01/06/2014 12:49 AM, Ann Harrison wrote: On Sun, Jan 5, 2014 at 3:39 AM, Alex > wrote: O > > I thought we would allow PASS as a shortcut for PASSWORD. Can you provide a sample where shortcuts are present in SQL? It's trivial to add PASS shortcut,

Re: [Firebird-devel] Confusing message when security3 is not found

On 06/01/2014 10:46, Alex wrote: > > Yes - and probably thats due to I've forgottem about full forms of > this keywords. > Therefore I see the only one problem with adding shortcut: should it > be PAS or PASS? > I suppose the original question was raised due to ogten use of -pass > as a key in comm

Re: [Firebird-devel] Confusing message when security3 is not found

On 01/06/2014 04:51 PM, Adriano dos Santos Fernandes wrote: > On 06/01/2014 10:46, Alex wrote: >> Yes - and probably thats due to I've forgottem about full forms of >> this keywords. >> Therefore I see the only one problem with adding shortcut: should it >> be PAS or PASS? >> I suppose the original

Re: [Firebird-devel] Some aspects of the optimizer hints

On 01/06/2014 12:41 AM, Ann Harrison wrote: Alex, > Furthermore, despite the everyone's instinct, it's a good deal faster in > the general case to read a table in an optimal order and sort the data > in memory that to read the data in index order - random order relative

Re: [Firebird-devel] Some aspects of the optimizer hints

Ann, > Right. And if you want to give the optimizer a hint that it should choose > the second plan, change the query like this: > > select first 100 * from MOVIES where COMMENTS like '%yacht% order > by NAME; > > If you think your client may want more than a million rows, increase > that num

[Firebird-devel] FB 3: grants on Sequences

Hi all, is a privilege “G” in RDB$USER_PRIVILEGES actually a granted “Usage”? Is that the only available privilege for sequences? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase

Re: [Firebird-devel] FB 3: grants on Sequences

Martijn, > is a privilege “G” in RDB$USER_PRIVILEGES actually a granted “Usage”? Yes, it stands for "usaGe" :-) for the lack of better one-letter representation. Per standard, it also applies to exceptions, domains, charsets, collations. However, the engine validates it only for sequences and

Re: [Firebird-devel] FB 3: grants on Sequences

Hello Dmitry, >> is a privilege “G” in RDB$USER_PRIVILEGES actually a granted “Usage”? > >Yes, it stands for "usaGe" :-) for the lack of better one-letter >representation. Ah, right. Somehow, I expected "Select". But hey, this is as good as any. >Per standard, it also applies to exceptions, doma

Re: [Firebird-devel] Some aspects of the optimizer hints

Dmitry, > > Right. And if you want to give the optimizer a hint that it should choose > > the second plan, change the query like this: > > > > select first 100 * from MOVIES where COMMENTS like '%yacht% order > > by NAME; > > > > If you think your client may want more than a million rows, i

[Firebird-devel] A PostgreSQL foreign data wrapper (FDW) for Firebird

This is an experimental foreign data wrapper (FDW) to connect PostgreSQL to Firebird. http://sql-info.de/postgresql/notes/firebird-foreign-data-wrapper-fdw.html -- Rapidly troubleshoot problems before they affect your bus