[Firebird-devel] [FB-Tracker] Created: (CORE-5814) excessive sorting of expressions

Reporter: kdv Grouping and sorting on expression produces additional SORT in plan. Example. When we group and sort on non-indexed field select first_name, max(first_name) from employee group by 1 order by 1 we see PLAN SORT (EMPLOYEE NATURAL) i.e only one sort used for grouping

Re: [Firebird-devel] Start transaction from base transaction

Hello! 18.04.2017, 22:22, "Dimitry Sibiryakov" : I want to push data to another database as fast as possible, I want to have 5 connections walk the list of tables and read the rows and push them to the target DB.   With current Firebird architecture you won't get better

[Firebird-devel] [FB-Tracker] Created: (CORE-4169) A.

A. -- Key: CORE-4169 URL: http://tracker.firebirdsql.org/browse/CORE-4169 Project: Firebird Core Issue Type: New Feature Reporter: kdv -- This message is automatically generated by JIRA. - If you think it was sent

[Firebird-devel] [FB-Tracker] Created: (CORE-4170) Allow (add) ability to specify database cache in kb/mb/gb

Components: Engine Affects Versions: 3.0 Alpha 1 Reporter: kdv I ask in addition to existing DefaultDbCachePages add new firebird.conf/database.conf parameter DefaultDBCacheSize which can be specified in kilobytes, megabytes or gigabytes of memory directly. For example

[Firebird-devel] [FB-Tracker] Created: (CORE-4080) Disable ability to create database without path

, 2.1.5, 2.0.7, 2.5.1, 2.1.4, 2.5.0, 2.0.6, 2.1.3, 2.1.2, 2.0.5, 2.1.1, 2.1.0 Reporter: kdv Currently ability to create database without path is near to security breach. Because it allows user to create database somewhere (and then user can fill it with data and consume free space

[Firebird-devel] [FB-Tracker] Created: (CORE-3957) gbak does not have option to turn off no_reserve

Reporter: kdv Priority: Minor Interesting, but gbak have only option -use_all_space for restore, but does not have reverse option, to turn database flag no_reserve off. gfix, instead, have -use full/reserve. Thus, if I have backup, I can't turn no_reserve off. I need

[Firebird-devel] [FB-Tracker] Created: (CORE-3820) RDB$TYPES contain duplicated character sets

Affects Versions: 2.5.1 Reporter: kdv Priority: Minor table RDB$TYPES have duplicate records for some rdb$character_set_name. Duplicates can be found by query select rdb$field_name, rdb$type_name, count(rdb$type_name) from rdb$types group by rdb$field_name, rdb$type_name

[Firebird-devel] [FB-Tracker] Created: (CORE-3514) extentions of GSTAT output in 3.0

Alpha 1, 3.0 Beta 1, 3.0.0 Reporter: kdv I ask to extend GSTAT output with the information, already provided by InterBase XE gstat. These options are: for tables: now Average record length: 67.06, total records: 31 nice to implement Average record length: 67.06, total records