Implicit objects should have their own number in rdb$system_flag
Key: CORE-4411
URL: http://tracker.firebirdsql.org/browse/CORE-4411
Project: Firebird Core
Issue Type: Improvem
Conflicting ordering clauses
Key: CORE-4412
URL: http://tracker.firebirdsql.org/browse/CORE-4412
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 2, 3.0 Alpha 1,
Gpre produces invalid DDL for FB3
-
Key: CORE-4413
URL: http://tracker.firebirdsql.org/browse/CORE-4413
Project: Firebird Core
Issue Type: Bug
Components: GPRE
Affects Versions: 3.0 Alpha 2, 3.0
> > If you look at SQL Server, there jobs themselves are not defined for a
> > specific database (although they may depend on one or more databases).
> > AFAIK they are stored in the master database. Execution requires an
> > Agent service to be running.
>
> We neither have a master database, no
> On 04/28/14 17:35, Damyan Ivanov wrote:
> > (Context: this is a reply to a thread from November 2013 about porting
> > Firebird to 64-bit ARM)
> >
> > -=| Alex Peshkoff, 29.11.2013 15:34:02 +0400 |=-
> >> I will apply a patch commented in opder to avoid conflicts with class
> >> IDs.
> > Alex,
Add the ability to specify a default role for deals CREATE / ALTER USER
---
Key: CORE-4414
URL: http://tracker.firebirdsql.org/browse/CORE-4414
Project: Firebird Core
Issue
Useless extraction of generic DDL trigger
-
Key: CORE-4415
URL: http://tracker.firebirdsql.org/browse/CORE-4415
Project: Firebird Core
Issue Type: Bug
Components: ISQL
Affects Versions: 3
> TRIGGER : NEW/OLD values accessible by column name, and column number
> (PSQL)
> - e.g.: NEW['id'], NEW[0]
> - gain : code reduction, dynamic code (don't have to alter the trigger ICO
> the table structure altered)
1- What advantage does NEW['id'] have over the current syntax "new.id"??
On 1-5-2014 21:24, Leyne, Sean wrote:
>> Optimization I.
>> - VOLATILE (default) / DETERMINISTIC flag for UDF and FUNCTION (maybe
>> lifecycle for deterministic : statement, transaction, connection)
>> - gain : preformance (can cache DETERMINISTIC UDF/FUNCTION results)
>
> Actually, I thi
On 30-4-2014 11:50, Molnár Attila wrote:
> *TRIGGER : NEW/OLD values accessible by column name, and column number
> (PSQL)*
> - e.g.: NEW['id'], NEW[0]
Just an aside: in SQL indexes are 1-based, not 0-based.
Mark
--
Mark Rotteveel
---
> On 1-5-2014 21:24, Leyne, Sean wrote:
> >> Optimization I.
> >> - VOLATILE (default) / DETERMINISTIC flag for UDF and FUNCTION
> >> (maybe lifecycle for deterministic : statement, transaction, connection)
> >> - gain : preformance (can cache DETERMINISTIC UDF/FUNCTION
> >> results)
>
01.05.2014 23:24, Leyne, Sean wrote:
>
>> Optimization I.
>> - VOLATILE (default) / DETERMINISTIC flag for UDF and FUNCTION (maybe
>> lifecycle for deterministic : statement, transaction, connection)
>> - gain : preformance (can cache DETERMINISTIC UDF/FUNCTION results)
>
> Actually, I th
30.04.2014 13:50, Molnár Attila wrote:
>
> *SIZE OF , SCALE OF domain or variable name>*
> - SIZE OF : returns max CHAR/VARCHAR length or NUMERIC precision,
> SCALE OF : return scale of NUMERIC
> - gain : by defining a variable with DOMAIN or TYPE OF (or DOMAIN
> OF) the declaration is d
13 matches
Mail list logo
