[Firebird-devel] [FB-Tracker] Created: (CORE-4411) Implicit objects should have their own number in rdb$system_flag

2014-05-01 Thread Claudio Valderrama C. (JIRA)
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:

[Firebird-devel] [FB-Tracker] Created: (CORE-4412) Conflicting ordering clauses

2014-05-01 Thread Claudio Valderrama C. (JIRA)
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

[Firebird-devel] [FB-Tracker] Created: (CORE-4413) Gpre produces invalid DDL for FB3

2014-05-01 Thread Claudio Valderrama C. (JIRA)
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

Re: [Firebird-devel] Planning the post v3 development

2014-05-01 Thread Leyne, Sean
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, nor an

Re: [Firebird-devel] Fwd: ARM64 port

2014-05-01 Thread Leyne, Sean
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, thanks for

[Firebird-devel] [FB-Tracker] Created: (CORE-4414) Add the ability to specify a default role for deals CREATE / ALTER USER

2014-05-01 Thread Simonov Denis (JIRA)
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

[Firebird-devel] [FB-Tracker] Created: (CORE-4415) Useless extraction of generic DDL trigger

2014-05-01 Thread Claudio Valderrama C. (JIRA)
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:

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-01 Thread Leyne, Sean
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??? 2-

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-01 Thread 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) Actually, I think that

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-01 Thread Mark Rotteveel
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

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-01 Thread Leyne, Sean
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

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-01 Thread Dmitry Yemanov
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 think that