==
-Original message/Oorspronkelijk bericht-
From: Dmitry Yemanov
Sent: Wednesday, March 18, 2015 8:53 PM
To: For discussion among Firebird Developers
Subject: Re: [Firebird-devel] Retrieving plan using new mon$explained_plan
field (FB
2015 15:38, Robbert-Jan wrote:
>
> I’m trying to retrieve the explain plan of the last prepared query,
> using the mon$explained_plan field, introduced in FB3 beta.
> I used:
> SELECT mon$explained_plan FROM mon$statements WHERE mon$transaction_id =
> CURRENT_TRANSACTION
Wro
Hi,
I’m trying to retrieve the explain plan of the last prepared query, using the
mon$explained_plan field, introduced in FB3 beta.
I used:
SELECT mon$explained_plan FROM mon$statements WHERE mon$transaction_id =
CURRENT_TRANSACTION
This seems to give me however the plan of the first prepared s
Hi,
I’ve tested the “unofficial” FB 3.0 beta-1 release (after installing it with
the “unofficial” installer) for a couple of weeks now.
I am now at a point, that I start missing the release notes, just to get a
better understanding of the new features and for designing my test cases
efficiently
)
Sent: Monday, October 27, 2014 5:19 PM
To: For discussion among Firebird Developers
Subject: Re: [Firebird-devel] Beta 1: recreating package
failswith"signaturemismatch" error
Hello Robbert-Jan,
Private functions not exposed to the outside is one of the things you can
do with packa
Hi Martijn,
Maybe it is too obvious, but it looks like your body has four routines and your
header only three (CHECK_INVOICE_EXISTS is missing), hence the signutare
mismatch.
Kind regards,
Robert
From: Martijn Tonies (Upscene Productions)
Sent: Monday, October 27, 2014 12:54 PM
To: firebird-dev
opers
Subject: Re: [Firebird-devel] Firebird 3.0 beta database recover problem:
object has non-SQL security class defined
Am 27.10.2014 um 10:45 schrieb Dmitry Yemanov:
> 27.10.2014 12:30, Robbert-Jan wrote:
>
>> While restoring a database with FB 3.0 beta 1 (backed-up with FB3 alpha
L security class defined
27.10.2014 12:30, Robbert-Jan wrote:
> While restoring a database with FB 3.0 beta 1 (backed-up with FB3 alpha
> 2), I get this error:
> action cancelled by trigger (3) to preserve data integrity
> object has non-SQL security class defined
Can you provi
Hi,
While restoring a database with FB 3.0 beta 1 (backed-up with FB3 alpha 2), I
get this error:
action cancelled by trigger (3) to preserve data integrity
object has non-SQL security class defined
Exiting before completion due to errors
SQL state: 27000
SQL code: -901
FB version: WI-T3.0.0.31
Now I've deleted all of firebird_3_0 directory and installed beta-1 again.
Installation of beta-1 is finishing without problems now!
Thanks, Robert
-Original mail -
On 10/22/14 17:07, Robbert-Jan wrote:
> Hi,
> I’m trying to install Firebird 3 Beta-1 on Windows X
Hi,
I’m trying to install Firebird 3 Beta-1 on Windows XP
(Firebird-3.0.0.31369_0_Win32.exe).
I get the following error from gsec.exe during installation:
An error occurred while attempting to add the user.
Incompatible data type
I *guess* this occurs when the installation process tries to
Already reported by DOC-92.
-Oorspronkelijk bericht-
From: Mark Rotteveel
Sent: Tuesday, October 21, 2014 10:14 PM
To: firebird-devel@lists.sourceforge.net
Subject: [Firebird-devel] Bug release notes 3.0 Alpha 2
Helen,
In the release notes for 3.0 Alpha 2 I noticed the following "bug" (
Probably no beta release this week with all those drunken developers...
From: Martijn Tonies (Upscene Productions)
Sent: Monday, October 20, 2014 7:24 PM
To: For discussion among Firebird Developers
Subject: Re: [Firebird-devel] Prague
Raising the bar, Mark?
--
Martijn
---
Hi,
People who want to hide the source code can write an external
procedure/function (engine udr) and only distribute the dll file.
Kind regards,
Robert
-Oorspronkelijk bericht-
From: Carlos H. Cantu
Sent: Thursday, August 28, 2014 10:30 PM
To: For discussion among Firebird Developers
S
Hi,
I understand the dilemma. I think it is inherent in having separate
statements for defining header (interface) and body (implementation). This
was probably done to be compatible with other sql databases??
But anyway, it is too late now to change this concept;)
If a new field with the old pac
Hi,
It is not the round function, but the calculation (25*75/197). Since all
arguments are integers, the result will also an integer (SQL convention).
Try: 25.0*75.0/197.0
Kind regards,
Robert
-Oorspronkelijk bericht-
From: Hugues Van Landeghem (JIRA)
Sent: Tuesday, July 29, 2014 1:50
sion among Firebird Developers
Subject: Re: [Firebird-devel] FB3.0 How to get UDRs working?
On 30/06/2014 08:35, Robbert-Jan wrote:
>
> (4) I’ve made a directory C:\Program
> Files\Firebird\Firebird_3_0\plugins\udr with the file
> UdrCppExample.cpp (from the latest snapshot).
>
You
With WI-T3.0.0.30809 Firebird 3.0 Alpha 2, I try to test UDRs using the example
(UdrCppExample) from the latest snapshot.
But I do not understand how to configure it, because I get error while creating
an external function. I’ve followed this steps:
(1) installed WI-T3.0.0.30809 Firebird 3.0 A
Hi,
Already reported by DOC-92 (http://tracker.firebirdsql.org/browse/DOC-92)
for alpha1.
I guess changing the documentation is the easiest way around, otherwise
don't forget to change rdb$types too.
Kind regards,
Robert.
-Oorspronkelijk bericht-
From: Thomas Kellerer
Sent: Saturday,
>On 16/12/2013 05:08, Alex Peshkoff wrote:
>> I prefer to:
>>
>> alter user x password 'y' set a = 'a', b = 'b';
>>
>>
>Me too.
>Adriano
And me too.
Will the new name-value pairs also be retrievable from sec$users? And if
yes, how ? Text blob with all pairs?
Kind regards,
Robert
- NL
---
Hi,
Domain defaults seem not to be applied for SP ending parameters, see case
below.
Is this as designed, or a bug, or a request? I just want to be sure before I
issue a Jira tracker.
CREATE DOMAIN MyDomain1 AS INTEGER DEFAULT 1
CREATE PROCEDURE MyProcedure1 (Var1 MyDomain1) RETURNS (Var2 INT
Hi,
I see that the COMMENT ON syntax has been changed in FB 3.0
In stead of only
COMMENT ON PARAMETER .
now also
COMMENT ON PROCEDURE PARAMETER .
COMMENT ON FUNCTION PARAMETER .
is allowed.
I think this was introduced because of ambiguous situations in case a procedure
and function exist
To: firebird-devel@lists.sourceforge.net
Subject: Use of system tables for identity columns
Regarding the new identity column feature in Firebird 3 alpha:
The new fields rdb$generator_name and rdb$identity_type are now defined in
rdb$relation_fields.
I think it would be more consistent if the
Hi,
I think current behaviour of ALTER DOMAIN regarding CHARACTER SET is
correct.
CHARACTER SET is part of the datatype clause. So omitting CHARACTER SET
means the default character set has te bo taken.
If you want to keep the current (non-default) character set, you have to
repeat it in the AL
Hi,
I like your opinion on the following sql improvement before I submit a JIRA
request:
For domains it is possible to alter multiple changes in one statement.
For example:
CREATE DOMAIN MyDomain INTEGER DEFAULT 0 NOT NULL
ALTER DOMAIN MyDomain TO MyDomain2 TYPE BIGINT SET DEFAULT 1 NULL /* cha
Thanks Adriano, Sean and Mark,
You are right. I do not no what I was thinking but specifying BY DEFAULT for
computed columns makes indeed no sense.
Kind regard,
Robert
On 30/08/2013 11:28, Robbert-Jan wrote:
> Hi,
>
> I like to propose a more consistent syntax for computed co
Hi,
I like to propose a more consistent syntax for computed columns and identity
columns:
Computed columns are now defined in DDL as
[] GENERATED ALWAYS AS ()
while identity columns (as of FB 3.0 CORE-1385) are defined as:
{|} GENERATED {ALWAYS|BY DEFAULT} AS
IDENITITY
Note the difference
27 matches
Mail list logo
