FirebirdSQL/firebird issues and pull requests

#8234 - Sometimes "shutdown in progress" after gbak restore since 3.0.11 (Classic)

Issue - State: open - Opened by mielverh 6 months ago - 1 comment

#8232 - Provide ability to declare variables directly in .sql scripts (to be interpreted by ISQL and substituted in appropriate places)

Issue - State: open - Opened by pavel-zotov 6 months ago - 24 comments
Labels: type: improvement, type: new feature

#8230 - Ability to obtain PID of server process for current connection without querying mon$ tables

Issue - State: closed - Opened by pavel-zotov 6 months ago
Labels: component: engine, qa: done successfully, type: improvement, affect-version: 6.0 Initial

#8216 - ARM64 version of Firebird for Windows

Issue - State: open - Opened by MagicAndre1981 6 months ago - 6 comments

#8214 - Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI.

Issue - State: closed - Opened by sim1984 6 months ago - 2 comments
Labels: component: engine, type: bug, qa: done successfully, fix-version: 6.0 Alpha 1, affect-version: 5.0.0, fix-version: 5.0.2, affect-version: 5.0.1

#8214 - Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI.

Issue - State: closed - Opened by sim1984 6 months ago - 2 comments
Labels: component: engine, type: bug, qa: done successfully, fix-version: 6.0 Alpha 1, affect-version: 5.0.0, fix-version: 5.0.2, affect-version: 5.0.1

#8213 - WHEN NOT MATCHED BY SOURCE - does not work with a direct table as source

Issue - State: closed - Opened by nLeonardt95 6 months ago - 9 comments
Labels: qa: done successfully, affect-version: 6.0 Initial, fix-version: 6.0 Alpha 1, fix-version: 5.0.2, affect-version: 5.0.1

#8201 - Try to make cmake work again

Pull Request - State: open - Opened by raedrizqie 7 months ago - 4 comments

#8201 - Try to make cmake work again

Pull Request - State: open - Opened by raedrizqie 7 months ago - 4 comments

#8191 - Fix #8185 - SIGSEGV with WHERE CURRENT OF statement with statement cache turned on

Pull Request - State: closed - Opened by asfernandes 7 months ago - 2 comments

#8185 - SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor

Issue - State: closed - Opened by FabianoBiagini 7 months ago - 28 comments
Labels: component: engine, type: bug, qa: done successfully, affect-version: 6.0 Initial, fix-version: 6.0 Alpha 1, fix-version: 5.0.1, affect-version: 5.0.0

#8185 - SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor

Issue - State: closed - Opened by FabianoBiagini 7 months ago - 28 comments
Labels: component: engine, type: bug, qa: done successfully, affect-version: 6.0 Initial, fix-version: 6.0 Alpha 1, fix-version: 5.0.1, affect-version: 5.0.0

#8170 - Fix #7269: Restore deferred primary key indexes

Pull Request - State: closed - Opened by GeF0rs 8 months ago - 9 comments

#8157 - in operator bug in fb5

Issue - State: closed - Opened by ibexpertHK 8 months ago - 2 comments

#8157 - in operator bug in fb5

Issue - State: closed - Opened by ibexpertHK 8 months ago - 2 comments

#8145 - Fix for #8082 by making engine to use user buffers directly

Pull Request - State: open - Opened by aafemt 9 months ago - 10 comments

#8113 - UNION ALL optimization with constant false condition

Issue - State: closed - Opened by EPluribusUnum 9 months ago - 4 comments
Labels: component: engine, qa: done successfully, type: improvement, fix-version: 6.0 Alpha 1

#8113 - UNION ALL optimization with constant false condition

Issue - State: closed - Opened by EPluribusUnum 9 months ago - 4 comments
Labels: component: engine, qa: done successfully, type: improvement, fix-version: 6.0 Alpha 1

#8109 - Plan/Performance regression when using special construct for IN in FB5.x compared to FB3.x

Issue - State: closed - Opened by dpankov 10 months ago - 7 comments
Labels: component: engine, type: bug, qa: done successfully, affect-version: 6.0 Initial, fix-version: 6.0 Alpha 1, affect-version: 5.0.0, fix-version: 5.0.2, affect-version: 5.0.1

#8091 - Ability to create an inactive index

Pull Request - State: closed - Opened by aafemt 10 months ago - 6 comments
Labels: qa: done successfully, fix-version: 6.0 Alpha 1

#8091 - Ability to create an inactive index

Pull Request - State: closed - Opened by aafemt 10 months ago - 6 comments
Labels: qa: done successfully, fix-version: 6.0 Alpha 1

#8090 - Extracting of inactive index

Issue - State: closed - Opened by aafemt 10 months ago - 1 comment
Labels: component: isql, qa: covered by another tests, type: improvement, fix-version: 6.0 Alpha 1

#8090 - Extracting of inactive index

Issue - State: closed - Opened by aafemt 10 months ago - 1 comment
Labels: component: isql, qa: covered by another tests, type: improvement, fix-version: 6.0 Alpha 1

#8076 - Non-enforced constraints

Pull Request - State: open - Opened by aafemt 11 months ago - 24 comments

#8076 - Non-enforced constraints

Pull Request - State: open - Opened by aafemt 11 months ago - 24 comments

#8069 - Add missing synchronization to cached vectors of known pages

Pull Request - State: closed - Opened by dyemanov 11 months ago
Labels: type: bug, qa: cannot be tested, fix-version: 6.0 Alpha 1, fix-version: 5.0.2, fix-version: 4.0.6

#8061 - Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm

Pull Request - State: open - Opened by dyemanov 11 months ago - 1 comment
Labels: component: engine, type: improvement, fix-version: 5.0.1

#8061 - Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm

Pull Request - State: open - Opened by dyemanov 11 months ago - 1 comment
Labels: component: engine, type: improvement, fix-version: 5.0.1

#8060 - GBAK doesn't handle escaped path (and most likely filenames) on WIndows

Issue - State: open - Opened by TommiPrami 11 months ago - 4 comments

#8058 - DDL-Changes in replication does not set the correct grantor

Issue - State: closed - Opened by realcolaflasche 11 months ago - 9 comments
Labels: type: bug, qa: done successfully, component: replication, affect-version: 6.0 Initial, fix-version: 6.0 Alpha 1, affect-version: 4.0.4, fix-version: 4.0.5, fix-version: 5.0.1, affect-version: 5.0.0

#8057 - Let optimizer automatically update empty index statistics for relatively small system tables

Pull Request - State: closed - Opened by hvlad 11 months ago
Labels: qa: done successfully

#8047 - Wipe out multi-file database support

Pull Request - State: closed - Opened by dyemanov 11 months ago - 6 comments
Labels: component: engine, qa: cannot be tested, type: cleanup, fix-version: 6.0 Alpha 1

#8038 - Provide the github commit GUID that was last at the moment when snapshot creation process did start (QA-related)

Issue - State: closed - Opened by pavel-zotov 12 months ago - 14 comments
Labels: component: build issues / porting, qa: covered by another tests, type: task, fix-version: 6.0 Alpha 1, fix-version: 4.0.5, fix-version: 5.0.1

#8038 - Provide the github commit GUID that was last at the moment when snapshot creation process did start (QA-related)

Issue - State: closed - Opened by pavel-zotov 12 months ago - 14 comments
Labels: component: build issues / porting, qa: covered by another tests, type: task, fix-version: 6.0 Alpha 1, fix-version: 4.0.5, fix-version: 5.0.1

#8015 - Add multi-character TRIM function

Pull Request - State: closed - Opened by MrTeeett 12 months ago
Labels: component: engine, qa: done successfully, type: improvement, fix-version: 6.0 Alpha 1, red-soft

#8015 - Add multi-character TRIM function

Pull Request - State: closed - Opened by MrTeeett 12 months ago
Labels: component: engine, qa: done successfully, type: improvement, fix-version: 6.0 Alpha 1, red-soft

#8005 - UNLIST table-value function

Issue - State: open - Opened by dyemanov about 1 year ago - 49 comments
Labels: component: engine, type: improvement, red-soft

#8005 - UNLIST table-value function

Issue - State: open - Opened by dyemanov about 1 year ago - 51 comments
Labels: component: engine, type: improvement, rdb

#7980 - Option for GEN_UUID to generate v7 UUID

Issue - State: closed - Opened by r1gm about 1 year ago - 7 comments
Labels: component: engine, qa: done successfully, type: improvement, fix-version: 6.0 Alpha 1

#7941 - [Explained Plan]Transformation of outer join into inner

Issue - State: closed - Opened by livius2 about 1 year ago - 5 comments

#7888 - The ability to retrieve the total number of pages in the database, the

Pull Request - State: closed - Opened by Danuul3 about 1 year ago
Labels: component: engine, qa: done successfully, type: improvement, fix-version: 6.0 Alpha 1

#7885 - Unstable error messages in services due to races related with service status vector

Issue - State: closed - Opened by pavel-zotov about 1 year ago - 8 comments
Labels: type: bug, qa: covered by another tests, affect-version: 3.0.11, affect-version: 6.0 Initial, fix-version: 6.0 Alpha 1, affect-version: 5.0 RC 1, fix-version: 5.0 RC 2, affect-version: 4.0.4, fix-version: 4.0.5

#7853 - Do not consider non-deterministic expressions as invariants in pre-filters

Pull Request - State: closed - Opened by dyemanov over 1 year ago - 3 comments
Labels: component: engine, type: bug, qa: done successfully, affect-version: 5.0 Beta 1, fix-version: 6.0 Alpha 1, affect-version: 5.0 RC 1, fix-version: 5.0 RC 2

#7853 - Do not consider non-deterministic expressions as invariants in pre-filters

Pull Request - State: closed - Opened by dyemanov over 1 year ago - 3 comments
Labels: component: engine, type: bug, qa: done successfully, affect-version: 5.0 Beta 1, fix-version: 6.0 Alpha 1, affect-version: 5.0 RC 1, fix-version: 5.0 RC 2

#7826 - Firebird 3.0, 4.0 and 5.0 Windows installers do not set the SYSDBA password if it was previously installed (even if not currently installed)

Issue - State: open - Opened by mrotteveel over 1 year ago - 20 comments
Labels: type: bug, component: installation

#7826 - Firebird 3.0, 4.0 and 5.0 Windows installers do not set the SYSDBA password if it was previously installed (even if not currently installed)

Issue - State: open - Opened by mrotteveel over 1 year ago - 20 comments
Labels: type: bug, component: installation

#7808 - Natural retrieval is actually sorted by RDB$DB_KEY

Issue - State: open - Opened by aafemt over 1 year ago - 8 comments
Labels: component: engine, type: improvement

#7808 - Natural retrieval is actually sorted by RDB$DB_KEY

Issue - State: open - Opened by aafemt over 1 year ago - 8 comments
Labels: component: engine, type: improvement

#7807 - Added the ability to change sql security option without specifying the entire body of the function/procedure/package

Pull Request - State: closed - Opened by Zhdanov0 over 1 year ago - 7 comments
Labels: component: engine, qa: covered by another tests, type: improvement, fix-version: 6.0 Alpha 1, red-soft

#7807 - Added the ability to change sql security option without specifying the entire body of the function/procedure/package

Pull Request - State: closed - Opened by Zhdanov0 over 1 year ago - 7 comments
Labels: component: engine, qa: covered by another tests, type: improvement, fix-version: 6.0 Alpha 1, red-soft

#7789 - System Windows protects this PC

Issue - State: closed - Opened by tomaszdubiel18 over 1 year ago - 6 comments

#7758 - Added the ability to change deterministic option

Pull Request - State: closed - Opened by Zhdanov0 over 1 year ago - 6 comments
Labels: component: engine, type: improvement, fix-version: 6.0 Alpha 1, red-soft

#7758 - Added the ability to change deterministic option

Pull Request - State: closed - Opened by Zhdanov0 over 1 year ago - 6 comments
Labels: component: engine, type: improvement, fix-version: 6.0 Alpha 1, red-soft

#7748 - Allow collation to be a part of data type

Pull Request - State: closed - Opened by aafemt over 1 year ago - 13 comments
Labels: qa: done successfully, fix-version: 6.0 Alpha 1

#7739 - Implement new "datatype" for blob handling

Issue - State: open - Opened by livius2 over 1 year ago - 34 comments

#7739 - Implement new "datatype" for blob handling

Issue - State: open - Opened by livius2 over 1 year ago - 34 comments

#7629 - Add FORMAT clause to convert datetime types to string and vice versa #2388

Pull Request - State: closed - Opened by TreeHunter9 over 1 year ago - 24 comments
Labels: component: engine, type: new feature, fix-version: 6.0 Alpha 1, red-soft

#7629 - Add FORMAT clause to convert datetime types to string and vice versa #2388

Pull Request - State: closed - Opened by TreeHunter9 over 1 year ago - 24 comments
Labels: component: engine, type: new feature, fix-version: 6.0 Alpha 1, red-soft

#7596 - nbackup -D ON causes problem when operates with some type of drives

Issue - State: closed - Opened by pavel-zotov over 1 year ago - 2 comments
Labels: qa: cannot be tested

#7398 - Worst plan sort created to execute an indexed tables

Issue - State: closed - Opened by n3rv0u5 about 2 years ago - 4 comments
Labels: component: engine, type: bug, qa: done with caveats, fix-version: 4.0.3, affect-version: 4.0.2

#7304 - Events in system attachments (like garbage collector) are not traced

Issue - State: closed - Opened by AlexPeshkoff over 2 years ago
Labels: type: bug, qa: done successfully, fix-version: 5.0 Beta 1, affect-version: 5.0 Initial, affect-version: 4.0.2

#7304 - Events in system attachments (like garbage collector) are not traced

Issue - State: closed - Opened by AlexPeshkoff over 2 years ago
Labels: type: bug, qa: done successfully, fix-version: 5.0 Beta 1, affect-version: 5.0 Initial, affect-version: 4.0.2

#7299 - gfix hangs on disconnect when transactions trace active

Issue - State: closed - Opened by AlexPeshkoff over 2 years ago - 3 comments
Labels: type: bug, qa: not enough information, affect-version: 3.0.10, fix-version: 3.0.11

#7299 - gfix hangs on disconnect when transactions trace active

Issue - State: closed - Opened by AlexPeshkoff over 2 years ago - 3 comments
Labels: type: bug, qa: not enough information, affect-version: 3.0.10, fix-version: 3.0.11

#7269 - [FR] Database restore must make every effort on activating deferred indexes

Issue - State: closed - Opened by basid-irk over 2 years ago - 15 comments
Labels: qa: done successfully, type: improvement, fix-version: 6.0 Alpha 1, fix-version: 5.0.2

#7269 - [FR] Database restore must make every effort on activating deferred indexes

Issue - State: closed - Opened by basid-irk over 2 years ago - 15 comments
Labels: qa: done successfully, type: improvement, fix-version: 6.0 Alpha 1, fix-version: 5.0.2

#7260 - Partial Foreign Keys

Issue - State: open - Opened by livius2 over 2 years ago - 17 comments

#7260 - Partial Foreign Keys

Issue - State: open - Opened by livius2 over 2 years ago - 17 comments

#7255 - READ COMMITTED READ CONSISTENCY mode is broken in Classic / SuperClassic on Linux (the newly created users are not visible to execute statement)

Issue - State: closed - Opened by dmitry-starodubov over 2 years ago - 5 comments
Labels: type: bug, qa: done with caveats, fix-version: 5.0 Beta 1, affect-version: 5.0 Initial, fix-version: 4.0.3, affect-version: 4.0.2

#6915 - Allow attribute DISABLE-COMPRESSIONS in UNICODE collations

Issue - State: closed - Opened by asfernandes over 3 years ago - 7 comments
Labels: type: improvement, qa: done with caveats, affect-version: 3.0.7, affect-version: 4.0.0, fix-version: 4.0.1, fix-version: 5.0 Beta 1, affect-version: 5.0 Initial

#6763 - The Large SQL crashes Firebird Server [CORE6536]

Issue - State: open - Opened by firebird-automations almost 4 years ago - 7 comments
Labels: priority: major, type: bug, qa: covered by another tests, affect-version: 3.0.1, affect-version: 3.0.7

#6467 - FB crashes when evaluating too long expression [CORE6223]

Issue - State: open - Opened by firebird-automations about 5 years ago - 13 comments
Labels: priority: major, component: engine, type: bug, qa: covered by another tests, affect-version: 3.0.4, affect-version: 4.0 Beta 1

#6380 - make optimizer understand SELECT .... ORDER BY ? * EXPRESSION special case [CORE6131]

Issue - State: closed - Opened by firebird-automations over 5 years ago - 8 comments
Labels: priority: major, type: improvement

#6380 - make optimizer understand SELECT .... ORDER BY ? * EXPRESSION special case [CORE6131]

Issue - State: closed - Opened by firebird-automations over 5 years ago - 8 comments
Labels: priority: major, type: improvement

#6329 - "LIKE" queries should use expression index if expression uses system functions e.g. UPPER [CORE6079]

Issue - State: closed - Opened by firebird-automations over 5 years ago - 6 comments
Labels: component: engine, priority: minor, type: improvement

#6329 - "LIKE" queries should use expression index if expression uses system functions e.g. UPPER [CORE6079]

Issue - State: closed - Opened by firebird-automations over 5 years ago - 6 comments
Labels: component: engine, priority: minor, type: improvement

#6279 - Provide cardinality calculation results in Explained Plan [CORE6029]

Issue - State: open - Opened by firebird-automations almost 6 years ago - 4 comments
Labels: priority: major, component: engine, type: improvement

#6279 - Provide cardinality calculation results in Explained Plan [CORE6029]

Issue - State: open - Opened by firebird-automations almost 6 years ago - 4 comments
Labels: priority: major, component: engine, type: improvement

#6233 - create index idx [as active | inactive] on ... [CORE5981]

Issue - State: closed - Opened by firebird-automations about 6 years ago - 1 comment
Labels: component: engine, qa: covered by another tests, priority: minor, type: improvement, fix-version: 6.0 Alpha 1

#6233 - create index idx [as active | inactive] on ... [CORE5981]

Issue - State: closed - Opened by firebird-automations about 6 years ago - 1 comment
Labels: component: engine, qa: covered by another tests, priority: minor, type: improvement, fix-version: 6.0 Alpha 1

#5935 - Allow to create BIGINT fields in the dialect 1 [CORE5669]

Issue - State: closed - Opened by firebird-automations about 7 years ago - 2 comments
Labels: priority: major, component: engine, type: improvement, affect-version: 3.0.3, affect-version: 4.0 Beta 1

#5935 - Allow to create BIGINT fields in the dialect 1 [CORE5669]

Issue - State: closed - Opened by firebird-automations about 7 years ago - 2 comments
Labels: priority: major, component: engine, type: improvement, affect-version: 3.0.3, affect-version: 4.0 Beta 1

#5783 - Create a legacy configuration property to map COUNT as INTEGER instead of BIGINT [CORE5514]

Issue - State: closed - Opened by firebird-automations almost 8 years ago - 12 comments
Labels: priority: major, component: engine, type: improvement, affect-version: 3.0.2

#5783 - Create a legacy configuration property to map COUNT as INTEGER instead of BIGINT [CORE5514]

Issue - State: closed - Opened by firebird-automations almost 8 years ago - 12 comments
Labels: priority: major, component: engine, type: improvement, affect-version: 3.0.2

#5537 - Non US-ASCII field names treated as unicode, although charset non-unicode, lowering max field length [CORE5258]

Issue - State: closed - Opened by firebird-automations over 8 years ago - 3 comments
Labels: priority: major, type: bug, qa: done successfully, affect-version: 3.0.0

#5537 - Non US-ASCII field names treated as unicode, although charset non-unicode, lowering max field length [CORE5258]

Issue - State: closed - Opened by firebird-automations over 8 years ago - 3 comments
Labels: priority: major, type: bug, qa: done successfully, affect-version: 3.0.0

#5431 - Support native JSON datatype for columns as MySQL / PostgreeSql [CORE5148]

Issue - State: open - Opened by firebird-automations almost 9 years ago - 5 comments
Labels: priority: major, type: new feature, red-soft

#5412 - Allow to specify a prefix protocol for embedded [CORE5128]

Issue - State: open - Opened by firebird-automations almost 9 years ago - 17 comments
Labels: priority: minor, type: improvement

#5412 - Allow to specify a prefix protocol for embedded [CORE5128]

Issue - State: open - Opened by firebird-automations almost 9 years ago - 17 comments
Labels: priority: minor, type: improvement

#5009 - Index and blob garbage collection doesn't take into accout data in undo log [CORE4701]

Issue - State: closed - Opened by firebird-automations almost 10 years ago - 7 comments
Labels: priority: major, component: engine, type: bug, qa: done successfully, affect-version: 2.5.1, affect-version: 2.5.0, fix-version: 4.0 Alpha 1, affect-version: 3.0 Alpha 1, affect-version: 2.5.2, affect-version: 2.5.2 Update 1, affect-version: 2.1.5 Update 1, affect-version: 3.0 Alpha 2, affect-version: 2.5.4, affect-version: 2.5.3 Update 1, affect-version: 2.5.3, affect-version: 3.0 Beta 1, affect-version: 3.0 Beta 2, affect-version: 2.1.7, affect-version: 2.1.6

#5009 - Index and blob garbage collection doesn't take into accout data in undo log [CORE4701]

Issue - State: closed - Opened by firebird-automations almost 10 years ago - 7 comments
Labels: priority: major, component: engine, type: bug, qa: done successfully, affect-version: 2.5.1, affect-version: 2.5.0, fix-version: 4.0 Alpha 1, affect-version: 3.0 Alpha 1, affect-version: 2.5.2, affect-version: 2.5.2 Update 1, affect-version: 2.1.5 Update 1, affect-version: 3.0 Alpha 2, affect-version: 2.5.4, affect-version: 2.5.3 Update 1, affect-version: 2.5.3, affect-version: 3.0 Beta 1, affect-version: 3.0 Beta 2, affect-version: 2.1.7, affect-version: 2.1.6

GitHub / FirebirdSQL/firebird issues and pull requests