27.08.2018 9:54, Dmitry Yemanov пишет:
27.08.2018 09:30, Vlad Khorsun wrote:
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 re
On 27.08.2018 04:10, Adriano dos Santos Fernandes wrote:
Hi!
Sometimes the build fail with message "Object reference not set to an
instance of an object."
https://ci.appveyor.com/project/FirebirdSQL/firebird/build/1.0.106/job/453y3ialoydf4r4b
May be some problem in their environment (.net mess
In firebird4 we have improved hash() function in order to make it
support various kinds of hashes. But except hashes there are a lot of
other crypto-related tasks that may be useful to execute directly from
SP & triggers. Does it make sense to add functions (may be UDR?) for
signing something a
Hi,
will be really good to have it.Now we use udf or transfer data to application
layer. With encrypted conection itself this will be as a completed whole.
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: Alex Peshkoff via Firebird-devel
Data: 27.08.2018 11:15 (GMT+01:00)
On 27/08/2018 06:15, Alex Peshkoff via Firebird-devel wrote:
> In firebird4 we have improved hash() function in order to make it
> support various kinds of hashes. But except hashes there are a lot of
> other crypto-related tasks that may be useful to execute directly from
> SP & triggers. Does it
On 27/08/2018 03:30, Vlad Khorsun wrote:
>
>
> If it is not what you asked for - please, explain the question.
>
What if a PSQL request calls an UDF/UDR, then executes a SELECT/UPDATE
that triggers a retry, will the UDF/UDR (that is not in the
SELECT/UPDATE, but in previous PSQL logic) will be ex
Alex,
I think, you can add (using simple warping functions) most used OpenSSL
functions - they cover 80%-90% of all needs in most cases.
Just my 0.05 MDL :)
--
Best regards,
Sergeymailto:s...@dqteam.com
On Mon, Aug 27, 2018 at 12:15 PM, Alex Peshkoff via Firebir
On 27.08.2018 13:52, Adriano dos Santos Fernandes wrote:
But if a functionality is decided to be created in the engine, then it's
better to write as a system package using the internal engine (created
in time zones branch).
Definitely yes - I've just forgotten about new functionality.
-
On 27.08.2018 13:37, Sergey Mereutsa wrote:
Alex,
I think, you can add (using simple warping functions) most used
OpenSSL functions - they cover 80%-90% of all needs in most cases.
Just my 0.05 MDL :)
One detail - that's supposed to be not OpenSSL but tomcrypt. With
openssl we have some l
On 27/08/2018 09:10, Alex Peshkoff via Firebird-devel wrote:
> On 27.08.2018 13:37, Sergey Mereutsa wrote:
>> Alex,
>>
>> I think, you can add (using simple warping functions) most used
>> OpenSSL functions - they cover 80%-90% of all needs in most cases.
>>
>> Just my 0.05 MDL :)
>>
>
> One detail
27.08.2018 13:55, Adriano dos Santos Fernandes wrote:
On 27/08/2018 03:30, Vlad Khorsun wrote:
If it is not what you asked for - please, explain the question.
What if a PSQL request calls an UDF/UDR, then executes a SELECT/UPDATE
that triggers a retry, will the UDF/UDR (that is not in the
On 27/08/2018 12:16, Vlad Khorsun wrote:
>
> Whole execution tree, starting from top-level request, will be
> executed again
> within new snapshot. So, yes, that UDF\UDR will be also executed
> again, unless
> control flow changed its path because of new data visible within new
> snapshot.
>
Then
27.08.2018 18:49, Adriano dos Santos Fernandes wrote:
On 27/08/2018 12:16, Vlad Khorsun wrote:
Whole execution tree, starting from top-level request, will be
executed again
within new snapshot. So, yes, that UDF\UDR will be also executed
again, unless
control flow changed its path because of
On 27/08/2018 12:59, Vlad Khorsun wrote:
> How it is related with consistency ? Also, we already have such
> behaviour
> even within single statement.
>
Show me it, please.
Adriano
--
Check out the vibrant tech comm
On 27/08/2018 12:59, Vlad Khorsun wrote:
>
>
>> Statement consistency should be about individual SQL (SELECT / UPDATE /
>> INSERT / MERGE / UPDATE OR INSERT) statements, not requests.
>
> This is not consistency. This is spaghetty.
>
We should live with it, as we don't have power to go back to t
27.08.2018 19:05, Adriano dos Santos Fernandes wrote:
On 27/08/2018 12:59, Vlad Khorsun wrote:
How it is related with consistency ? Also, we already have such
behaviour
even within single statement.
Show me it, please.
select any_function() ... from ... order by 1
For example, gen_id
27.08.2018 19:21, Adriano dos Santos Fernandes пишет:
On 27/08/2018 12:59, Vlad Khorsun wrote:
Statement consistency should be about individual SQL (SELECT / UPDATE /
INSERT / MERGE / UPDATE OR INSERT) statements, not requests.
This is not consistency. This is spaghetty.
We should liv
All,
Please. If nobody else sees the magnitude of this problem, I'll shut up.
What we talk here is something that is being said to fix read committed,
but completely destroys it.
Vlad want to make that code:
create procedure proc2
as
declare file_handle integer;
begin
file_handle = some_ud
27.08.2018 20:10, Adriano dos Santos Fernandes wrote:
All,
Please. If nobody else sees the magnitude of this problem, I'll shut up.
What we talk here is something that is being said to fix read committed,
but completely destroys it.
Wrong statement which mixed *read consistency* and *side e
Adriano dos Santos Fernandes wrote Mon, 27 Aug 2018
20:10:49 +0300:
And when the user executes that EXECUTE BLOCK, all the whole thing may
execute repeated times.
So we cannot use any external routines with side effects anymore in
Firebird. Not even internal functions with side effects.
P
Report name and fact/max length of name of database objects when length
exceeding
-
Key: CORE-5903
URL: http://tracker.firebirdsql.org/browse/CORE-5903
Project: Firebird
27.08.2018 20:10, Adriano dos Santos Fernandes wrote:
the whole thing may execute repeated times
Imagine selectable SP/UDR joined to a table. Depending on the plan,
SP/UDR may be executed once or multiple times. You have virtually no
control over this. If that SP/UDR has "side effects", you'
22 matches
Mail list logo
