Dmitry Yemanov
Dmitry Yemanov
As requested in #3750. Also supported by MS SQL, PostgreSQL, SQLite, MongoDB. Brief description can be found in [Wikipedia](https://en.wikipedia.org/wiki/Partial_index).
Initially published in firebird-devel. Test case: ```sql create table t_scale (col1 numeric(5, 2), col2 numeric(5, 2)); create index t_scale_i1 on t_scale(col1); create index t_scale_i2 on t_scale(col2); commit; insert into t_scale...
Example: ``` sql SELECT * FROM T1 LEFT JOIN T2 ON T1.ID = T2.ID WHERE T2.FIELD1 = 0 ``` In this case the condition `T2.FIELD1 = 0` effectively removes all...
It's been suggested to improve the way replication is configured. Currently, replication can be enabled at the database level and at the configuration level (both are required), but these settings...
We have announced 'cursor stability' for most types of queries in v3, but this improvement does not affect FOR EXECUTE STATEMENT cursors. Consider the following example: ``` create table t...
This addresses ticket #1130. After compression improvements the storage overhead this is no longer an issue. I think we should still preserve some safety limit, e.g. 1MB. This change suggests...
Implement a built-in function working the opposite way to the existing aggregate function `LIST` - i.e. parse the delimited string and return a record set containing the parsed values. It...
The initial implementation was developed by customer request, later it was slightly improved and committed into a separate branch for testing. Some issues were found that prevented it from inclusion...
I'm not sure it should be applied to v6 as it supports databases in ODS 13.0 / 13.1 which may be multi-file and the engine will not be able to...
Soluation for #7769. Skip NULLs keys at the evaluation time and do not put appropriate records into the hash table (for hash joins) or into external sort blocks (for merge...