My list is as follows. optimizer 1. Enable use MERGE / HASH JOIN for OUTER JOINs 2. Performing EXISTS / IN SEMI JOIN as including using MERGE / HASH, and NESTED LOOP using index 3. HASH aggregation Add to an existing method using sorting 4. Conditional INDEX ONLY SCAN as in Postgresql (dimitr said that it is possible to ODS 12)
PSQL and SQL 1. Add the ability to specify offer framing for window functions http://tracker.firebirdsql.org/browse/CORE-3647 2. Add JAVA, .NET PROCEDURE and FUNCTION (not just C++) 3. ROW VALUE CONSTRUCTOR http://tracker.firebirdsql.org/browse/CORE-3880 4. PACKAGEs Add to constants and variables http://tracker.firebirdsql.org/browse/CORE-670 5. Add the ability to write your own aggregate functions http://tracker.firebirdsql.org/browse/CORE-1326 Common Features 1. Bidirectional indices (one index for ASC and DESC) 2. Standby can be based on nbackup http://tracker.firebirdsql.org/browse/CORE-2990 3. Built as a plug -row replication . The standard delivery enable replication between servers firebird. For other servers, you can write your own plugin. Meaning plug-in capability to intercept changes from any table and write them in a log ( with options for filtering tables) , and then transmits a service already changed in another database. Create a bunch of triggers to support replication is not the nicest way. http://tracker.firebirdsql.org/browse/CORE-2021 ------------------------------------------------------------------------------ "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel