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

2014-01-08 Thread Alex
On 01/07/2014 01:35 PM, Dmitry Yemanov wrote: 07.01.2014 12:46, Dmitry Yemanov wrote: It *is* related as soon as you need to alter from the default FIRST ROWS to custom FIRST ROWS in some particular query. Read: custom ALL ROWS, sorry. True. I.e. historical form of giving 'FIRST' - only hint

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

2014-01-08 Thread Kjell Rilbe
Den 2014-01-08 08:22 skrev Dmitry Yemanov såhär: 08.01.2014 10:30, liviusliv...@poczta.onet.pl wrote: Why plan can not by extended for hint purposes? It can, the question is whether it should. This is natural placefor FB users to tell optimizer the better way of query execution.

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

2014-01-08 Thread Dmitry Yemanov
08.01.2014 12:15, Kjell Rilbe wrote: That said, I'd vote against plan for/hint if the plan clause in its current use is or is soon going to be deprecated. So, what are the plans for the plan clause? Explicit planning is still used by some customers, so it cannot be deprecated. But it's not

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

2014-01-08 Thread Kjell Rilbe
Den 2014-01-08 09:32 skrev Dmitry Yemanov såhär: 08.01.2014 12:15, Kjell Rilbe wrote: That said, I'd vote against plan for/hint if the plan clause in its current use is or is soon going to be deprecated. So, what are the plans for the plan clause? Explicit planning is still used by some

[Firebird-devel] [FB-Tracker] Created: (CORE-4314) COLLATION UNICODE_CI_AI for CHARACTER SET UTF8 is not installed

2014-01-08 Thread Kaf (JIRA)
COLLATION UNICODE_CI_AI for CHARACTER SET UTF8 is not installed --- Key: CORE-4314 URL: http://tracker.firebirdsql.org/browse/CORE-4314 Project: Firebird Core Issue Type: Bug

Re: [Firebird-devel] Firebird Interbase Database engine hacks or rtfm

2014-01-08 Thread Alex
On 01/07/2014 01:11 PM, marius adrian popa wrote: Notes on database security assesment http://www.slideshare.net/qqlan/firebird-interbase-database-engine-hacks-or-rtfm I see 2 kinds of samples - mixed DDL/DML statements and use of UDF. It's well known and documented (can't provide a link but

Re: [Firebird-devel] Firebird Interbase Database engine hacks or rtfm

2014-01-08 Thread Mark Rotteveel
On Wed, 08 Jan 2014 19:13:02 +0400, Alex peshk...@mail.ru wrote: On 01/07/2014 01:11 PM, marius adrian popa wrote: Notes on database security assesment http://www.slideshare.net/qqlan/firebird-interbase-database-engine-hacks-or-rtfm I see 2 kinds of samples - mixed DDL/DML statements and

Re: [Firebird-devel] Firebird Interbase Database engine hacks or rtfm

2014-01-08 Thread Alex
On 01/08/2014 07:22 PM, Sergey Mereutsa wrote: Hello Alex, ... skipped ... A I.e. on my mind the presentation is about nothing. The presentation is about If you have armed gun - you can shut your leg :) I think, the main message idea from Marius is about default security - i.e. by

Re: [Firebird-devel] Firebird Interbase Database engine hacks or rtfm

2014-01-08 Thread Alex
On 01/08/2014 07:34 PM, Mark Rotteveel wrote: On Wed, 08 Jan 2014 19:13:02 +0400, Alex peshk...@mail.ru wrote: On 01/07/2014 01:11 PM, marius adrian popa wrote: Notes on database security assesment http://www.slideshare.net/qqlan/firebird-interbase-database-engine-hacks-or-rtfm I see 2 kinds

Re: [Firebird-devel] Firebird Interbase Database engine hacks or rtfm

2014-01-08 Thread Mark Rotteveel
On Wed, 08 Jan 2014 19:41:16 +0400, Alex peshk...@mail.ru wrote: On 01/08/2014 07:22 PM, Sergey Mereutsa wrote: Hello Alex, ... skipped ... A I.e. on my mind the presentation is about nothing. The presentation is about If you have armed gun - you can shut your leg :) I think, the main

Re: [Firebird-devel] Firebird Interbase Database engine hacks or rtfm

2014-01-08 Thread Dimitry Sibiryakov
08.01.2014 16:44, Mark Rotteveel wrote: He simply demonstrates that once you 'own' a Firebird server, you can use that to further exploit/hack into a server. Perhaps, it is time to change default for DatabaseAccess parameter... -- WBR, SD.