Simonov Denis
Simonov Denis
``` set names UTF8; connect 'inet4://localhost:3053/test' user SYSDBA password 'masterkey'; Database: 'inet4://localhost:3053/test', User: SYSDBA CREATE OR ALTER VIEW VW_TB3( RENT) AS select 'ab '||' ab '||' abcd' from $RDB$DATABASE; show...
Need to add support for ordered-set and hypothetical-set aggregate functions, as well as implementations of the instances defined in SQL:2008 (percentile_cont(), percentile_disc(), rank(), dense_rank(), percent_rank(), cume_dist()). It is good to...
Firebird 6.0 added the ability to call stored procedures using a CALL statement. However, the EXECUTE STATEMENT preparser is not aware of the CALL statement and therefore cannot work with...
Currently, the return result of deterministic functions is considered invariant only if the function contains no arguments. The implementation with a results cache storing pairs is quite complex. However, we...
Windows 10. Firebird 3.0, 4.0, 5.0. The following command works successfully. ``` gstat localhost/3055:horses -u SYSDBA -p masterkey -h ``` However, if you replace the connection string with a URL,...
```sql SELECT * FROM RDB$RELATIONS WHERE RDB$RELATION_NAME IS NULL ``` Explain plan ``` Select Expression -> Filter -> Table "RDB$RELATIONS" Access By ID -> Bitmap -> Index "RDB$INDEX_0" Unique Scan...
Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI. Firebird 5.0.1 Windows 10 x64 ``` SET NAMES...
Firebird 5.0.3.1622 The optimizer selects the wrong join order when using CROSS JOIN LATERAL with complex table expressions. ```sql SELECT T.NAME FROM RDB$RELATIONS R CROSS JOIN LATERAL ( SELECT R.RDB$RELATION_NAME...
This document contains the following content: ``` ### Schema-less objects These objects exist outside schemas and function as before: - Users - Roles - Blob filters - Schemas ``` There...
The EXECUTE STATEMENT statement currently has the following syntax: ``` ::= EXECUTE STATEMENT [ ...] [INTO ] ::= | () | () () ::= | ::= [EXCESS] paramname := [,...