Simonov Denis

This ticket has a fairly low priority since MERGE joins are generally less efficient, but it would still be useful for testing purposes. Script for filling tables: ```sql RECREATE TABLE...

Let's create the following stored procedure in a Firebird 5.0 database. ```sql SET TERM ^; CREATE OR ALTER PROCEDURE SOME_PROC ( PRIVATE_FLAG SMALLINT) RETURNS ( PACKAGE_NAME VARCHAR(63), TEXT BLOB SUB_TYPE...

PERCENTILE_CONT and PERCENTILE_DISC functions

1

# PERCENTILE_DISC and PERCENTILE_CONT functions The `PERCENTILE_CONT` and `PERCENTILE_DISC` functions are known as inverse distribution functions. These functions operate on an ordered set. Both functions can be used as aggregate...

MySQL allows you to leave comments in place for table fields, as well as procedure and function parameters. For example, for a table, it looks like this: ```sql CREATE TABLE...

Firebird 5.0.3 ```sql CREATE TABLE TEST ( ID BIGINT GENERATED BY DEFAULT AS IDENTITY, A INT, CONSTRAINT PK_TEST_ID PRIMARY KEY(ID) ); CREATE INDEX TEST_A_IDX ON TEST(A); SET TERM^; EXECUTE BLOCK...

Support for SEARCH clause for recursive CTEs

1

I don't have the opportunity to look at the SQL standard, so I'll just point out where it is described. The search clause is defined in ISO/IEC 9075-2:2023 §7.18 as...

We have the following query: ```sql SELECT COUNT(*) FROM HORSE CROSS JOIN LATERAL ( SELECT R.CODE_FARM FROM REGISTRATION R WHERE R.CODE_REGTYPE = 6 AND R.CODE_HORSE = HORSE.CODE_HORSE ORDER BY R.BYDATE...