[Firebird-devel] [FB-Tracker] Created: (CORE-4470) gbak fails to restore database containing dependency between views and packaged functions

Project: Firebird Core Issue Type: Bug Components: GBAK Affects Versions: 3.0 Alpha 2 Reporter: Frank Schlottmann-Goedde The following isql script creates a database that can't be restored by gbak: SET SQL DIALECT 3; /* CREATE DATABASE 'localhost:C:

[Firebird-devel] [FB-Tracker] Created: (CORE-4006) using a result from a procedure in a substring expression leads to server crash

Issue Type: Bug Components: Engine Affects Versions: 3.0 Alpha 1 Environment: all Reporter: Frank Schlottmann-Goedde Priority: Blocker The following script demonstrates the issue

[Firebird-devel] [FB-Tracker] Created: (CORE-4005) wrong error message with recursive CTE

: 2.5.2 Environment: all Reporter: Frank Schlottmann-Goedde with recursive CTE_CNT1 as (select 0 as I from RDB$DATABASE union all select I + 1 from CTE_CNT1 where I < 9), CTE_CNT2 as (select I, 0 as J from CTE_CNT1 union all select J * 10 + c1.I, c

[Firebird-devel] [FB-Tracker] Created: (CORE-3968) Creating a stored procedure with one or more "update or insert" statement fails

ebird Core Issue Type: Bug Affects Versions: 3.0 Initial Environment: probably all (tested with Windows 7 and Ubuntu 12.04) Reporter: Frank Schlottmann-Goedde Using the following script in isql against the employee database demonstrates the error /* Creatin

[Firebird-devel] [FB-Tracker] Created: (CORE-3967) subselect with reference to outer select fails

Environment: probably all (tested with Windows 7 and Ubuntu 12.04) Reporter: Frank Schlottmann-Goedde Using the following script in isql against the employee database demonstrates the error /* subselect with reference to outer select fails with: Statement failed, SQLSTATE = 42S22

[Firebird-devel] [FB-Tracker] Created: (CORE-3966) Creating a stored procedure with an "update or insert" statement with returning value fails

/CORE-3966 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Initial Environment: probably all (tested with Windows 7 and Ubuntu 12.04) Reporter: Frank Schlottmann-Goedde Priority: Critical Using the following script in isql against th

[Firebird-devel] [FB-Tracker] Created: (CORE-3965) Creating a procedure containing "case when" expression leads to a server crash:

ebird Core Issue Type: Bug Affects Versions: 3.0 Initial Environment: probably all (tested on Windows 7 and Ubuntu 12.04) Reporter: Frank Schlottmann-Goedde Priority: Blocker Using the following script in isql against the employee database demonst

[Firebird-devel] [FB-Tracker] Created: (CORE-3964) It is not possible to create a ddl-trigger with "any DDL statement" clause

ebird Core Issue Type: Bug Affects Versions: 3.0 Initial Environment: probably all platforms (tested on Windows 7.0 and Ubuntu 12.04) Reporter: Frank Schlottmann-Goedde Using the following script in isql against the employee database demonstrates the error /* It is no

[Firebird-devel] [FB-Tracker] Created: (CORE-3963) isql doesn't know the difference between UDF's and psql-functions

Issue Type: Improvement Components: ISQL Affects Versions: 3.0 Initial Environment: probably all Reporter: Frank Schlottmann-Goedde Priority: Minor Using the following script in isql against the employee database shows the issue: /* isql doesn&

Re: [Firebird-devel] isql history broken with libedit 3.0

On 29.05.2012 00:49, Michal Kubecek wrote: > On Mon, May 28, 2012 at 07:34:28PM +0200, Michal Kubecek wrote: >> >> I did experiment a bit and it seems that locale (most likely LC_CTYPE, >> unfortunately the one that needs to be set for libedit to work), affects >> only output with "set list off", w

[Firebird-devel] [FB-Tracker] Created: (CORE-3651) using a Freepascal 64bit UDF causes the engine to exit on client disconnect

Issue Type: Bug Components: Engine Affects Versions: 2.5.2 Environment: Linux x86_64 (tested on Ubuntu 11.10) Firebird 2.5.2 64bit Reporter: Frank Schlottmann-Goedde create a simple freepascal udf: library test64; uses strings; procedure str_same(instring

[Firebird-devel] [FB-Tracker] Created: (CORE-3474) Regression in joins on procedures

Environment: any Reporter: Frank Schlottmann-Goedde Priority: Critical The following statement that used to work in fb2.5 throws an error in 2.5.1: Here are the results for both versions: First FB 2.5.0: SQL> show version; ISQL Version: LI-P2.5.0.26091 Firebird 2.5

Re: [Firebird-devel] GEN_UUID() performance?

On 04.04.2011 12:45, Thomas Steinmaurer wrote: > Vlad, >> >> First, try to insert 1mln *random* INTs, i.e. not in sequential order. >> Else you compare apples (sequential numbers) with oranges (random numbers) :) > > Good one. This makes a difference. Will put that in a list for a > possible