Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

2018-08-15 Thread Leyne, Sean
> > I do not see this feature as providing any benefit, which can't be > accomplished by more secure/appropriate mechanisms. > > > What mechanisms? > > > PS. I know that having tablespaces & partitioning is much better solution but > this requires big changes in engine, improvement to EXECUTE

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

2018-08-15 Thread Dimitry Sibiryakov
15.08.2018 17:28, Alex Peshkoff via Firebird-devel wrote: For single request no boost, but when we talk about server under high load serving multiple requests performance boost will be present. What could cause it given that I/O is already parallelized by storage system? "Very big

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

2018-08-15 Thread Alex Peshkoff via Firebird-devel
On 15.08.2018 18:08, Dimitry Sibiryakov wrote: 15.08.2018 16:43, Alex Peshkoff via Firebird-devel wrote: Taking into an account that this is suggested for FB4 (not 2.5) I do not see problems with security.   Imagine server configured with DatabaseAccess = none and/or database configured with

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

2018-08-15 Thread Dimitry Sibiryakov
15.08.2018 16:43, Alex Peshkoff via Firebird-devel wrote: Taking into an account that this is suggested for FB4 (not 2.5) I do not see problems with security. Imagine server configured with DatabaseAccess = none and/or database configured with SecurityDatabase = other.db. What will happen

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

2018-08-15 Thread Leyne, Sean
> I want to suggest simple improvement to execute statement - make it > possible to run in it CREATE DATABASE statements. It will not accept > parameters and ignore clauses ON EXTERNAL DATA SOURCE, WITH ... > TRANSACTION and WITH CALLER PRIVILEGES. Unlike ISQL which switches to > the context of

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

2018-08-15 Thread Alex Peshkoff via Firebird-devel
On 15.08.2018 17:19, Leyne, Sean wrote: I want to suggest simple improvement to execute statement - make it possible to run in it CREATE DATABASE statements. It will not accept parameters and ignore clauses ON EXTERNAL DATA SOURCE, WITH ... TRANSACTION and WITH CALLER PRIVILEGES. Unlike ISQL

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

2018-08-15 Thread Alex Peshkoff via Firebird-devel
On 15.08.2018 17:19, Dimitry Sibiryakov wrote: 15.08.2018 16:13, Alex Peshkoff via Firebird-devel wrote: In the simplest form (create database on current server) that will look like this: execute statement 'create database ''/tmp/t1''';   What about security and other settings? Will newly

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

2018-08-15 Thread Dimitry Sibiryakov
15.08.2018 16:13, Alex Peshkoff via Firebird-devel wrote: In the simplest form (create database on current server) that will look like this: execute statement 'create database ''/tmp/t1'''; What about security and other settings? Will newly created database use default ones or somehow

Re: [Firebird-devel] Changes in JRD_start/JRD_start_and_send in "read consistency" patch

2018-08-15 Thread Adriano dos Santos Fernandes
? On 05/08/2018 22:44, Adriano dos Santos Fernandes wrote: > Hi! > > In "read consistency" README's patch, it says about statement level > consistency. > > JRD_start/JRD_start_and_send was been changed (retry logic). > > Can this retry be leaked from "SQL statements" (SELECT / UPDATE / > DELETE)

[Firebird-devel] Improvement for EXECUTE STATEMENT

2018-08-15 Thread Alex Peshkoff via Firebird-devel
I want to suggest simple improvement to execute statement - make it possible to run in it CREATE DATABASE statements. It will not accept parameters and ignore clauses ON EXTERNAL DATA SOURCE, WITH ... TRANSACTION and WITH CALLER PRIVILEGES. Unlike ISQL which switches to the context of newly

[Firebird-devel] [FB-Tracker] Created: (CORE-5893) gbak may crash database when mixing alias with full database name

2018-08-15 Thread Alexander Peshkov (JIRA)
gbak may crash database when mixing alias with full database name - Key: CORE-5893 URL: http://tracker.firebirdsql.org/browse/CORE-5893 Project: Firebird Core Issue Type: Bug