Firebird Null Guide NULL behaviour and pitfalls in Firebird SQL Paul Vinkenoog Version 1.2, 30 June 2020 Table of Contents 1. What is NULL? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 2. NULL support in Firebird SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 4. Internal functions and directives. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.1. Internal functions. . . . . . . .

2. SQL Language Structure. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 2.1. Background to Firebird’s SQL Language . . . 19 2.1.1. SQL Flavours . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 2.1.2. SQL Dialects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56 3.9.1. SQL_NULL Data Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

License Notice in the Appendix This volume represents a compilation of topics concerning Firebird’s SQL language written by members of the Russian-speaking community of Firebird developers and users. In auspices of the Firebird Documentation Project. Preface 1 Table of Contents 1. About the Firebird SQL Language Reference: for Firebird 2.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2. SQL Language Structure. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 2.1. Background to Firebird’s SQL Language

Firebird Interactive SQL Utility Kamala Vadlamani, Paul Vinkenoog, Norman Dunbar, Mark Rotteveel Version 1.0, 24 December 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . ISC_PASSWORD Environment Variables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 11. SQL Dialects. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50 18.18. SET SQL DIALECT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Руководство по языку SQL СУБД Firebird 3.0 Firebird 3.0.4 8 августа 2018 — v.0051-1 Спонсоры документации: Platinum Sponsor Gold Sponsor Руководство по языку SQL СУБД Firebird 3.0: Firebird 3.0.4 ................... 22 Подмножества SQL ........................................................................................................ 22 Диалекты SQL ..................................... ................................................................................... 47 Тип данных SQL_NULL .............................................................................................

stream -84 335544554 nonsql_security_rel Table/procedure has non-SQL security class defined -84 335544555 nonsql_security_fld Column has non-SQL security class defined -84 335544668 dsql_procedure_use_err -104 335544764 transitional_date DATE must be changed to TIMESTAMP -104 335544796 sql_dialect_datatype_unsupport Client SQL dialect does not support reference to datatype -104 335544798 Nested aggregate functions are not allowed -104 336003075 dsql_transitional_numeric Precision 10 to 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3 -104 336003077

gfix_opt_SQL_dialect -sql_dialect set database dialect n -84 335544554 nonsql_security_rel Table/procedure has non-SQL security class defined -84 335544555 nonsql_security_fld Column has non-SQL security 10 to 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3 -104 336003077 sql_db_dialect_dtype_unsupport Database SQL dialect %d does not support reference to -104 335544764 transitional_date DATE must be changed to TIMESTAMP -104 335544796 sql_dialect_datatype_unsupport Client SQL dialect %d does not support reference to %s datatype -104 335544798 depend_on_uncommitted_rel

335741039 gfix_opt_SQL_dialect -sql_dialect set database dialect n 0 335544875 bad_debug_format Bad debug info format -84 335544554 nonsql_security_rel Table/procedure has non-SQL security class defined defined -84 335544555 nonsql_security_fld Column has non-SQL security class defined -84 335544668 dsql_procedure_use_err Procedure @1 does not return any values -85 335544747 usrname_too_long The username 10 to 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3 -104 336003077 sql_db_dialect_dtype_unsupport Database SQL dialect @1 does not support reference to @2

file name /dev/tty will also result in a prompt for the password.  Firebird 2.5 onwards. -role <SQL role name> Allows the specification of the role to be used by the connecting user. -database -fetch_password -role SQL role name> -trusted (use trusted authentication) -database -z Since Firebird 2.1, Windows domain administrators have had full access to the user management functions. This meant that when an admin user connected to the server and then used gsec, they had the ability

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 2. SQL Sprachstruktur . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 2.1. Hintergrund zu Firebirds SQL-Sprache . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 2.1.1. SQL Bestandteile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 2.1.2. SQL-Dialekte. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .