Firebird 4.0 Language Reference Dmitry Filippov, Alexander Karpeykin, Alexey Kovyazin, Dmitry Kuzmenko, Denis Simonov, Paul Vinkenoog, Dmitry Yemanov, Mark Rotteveel Version 2.10, 15 December 2023 The source of much copied reference material: Paul Vinkenoog Copyright © 2017-2023 Firebird Project and all contributing authors, under the Public Documentation License Version 1.0. Please refer to with the necessary changes. Preface 1 Table of Contents 1. About the Firebird 4.0 Language Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Firebird 2.5 Language Reference Dmitry Filippov, Alexander Karpeykin, Alexey Kovyazin, Dmitry Kuzmenko, Denis Simonov, Paul Vinkenoog, Dmitry Yemanov Version 1.16, 15 December 2023 The source of much much copied reference material: Paul Vinkenoog Copyright © 2017-2023 Firebird Project and all contributing authors, under the Public Documentation License Version 1.0. Please refer to the License Notice Russian-speaking community of Firebird developers and users. In 2014, it culminated in a language reference manual, in Russian. At the instigation of Alexey Kovyazin, a campaign was launched amongst Firebird

org документ доступен по адресу https://www.firebirdsql.org/ file/documentation/reference_manuals/firebird-language-reference-30-rus.pdf Кроме того, данный документ выложен в различных форматах на сайте Значение NULL не допустимо 22005 Error in assignment Ошибка присваивания 22006 Null value in field reference Значение NULL в поле ссылки 22007 Invalid datetime format Неверный формат даты/времени 22008 Datetime time zone displacement value Неверная временная зона, неверное значение 2200A Null value in reference target Значение NULL в целевой ссылке 2200B Escape character conflict Конфликт символа управления

Running the test case . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 489 12 Reference 491 ix 12.1 Database Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Normal Queries • main statement SELECT SELECT select_expr [, select_expr ...] FROM table_reference [, table_reference ...] [WHERE predicates] [GROUP BY {col_name | position} [ASC | DESC], ...] [ORDER BY [AS] [alias] | COUNT(* | COLUMN_NAME | alias) [AS] [alias] • table_reference tbl_name [AS] alias] [index_hint_list] | table_reference ([INNER] | {LEFT|RIGHT} [OUTER]) JOIN table_factor [JOIN ON conditional_expr

Running the test case . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 518 12 Reference 520 12.1 Database Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Normal Queries • main statement SELECT SELECT select_expr [, select_expr ...] FROM table_reference [, table_reference ...] [WHERE predicates] [GROUP BY {col_name | position} [ASC | DESC], ...] [ORDER BY [AS] [alias] | COUNT(* | COLUMN_NAME | alias) [AS] [alias] • table_reference tbl_name [AS] alias] [index_hint_list] | table_reference ([INNER] | {LEFT|RIGHT} [OUTER]) JOIN table_factor [JOIN ON conditional_expr

and Memstore. The ConcurrentSkipListSet in Memstore does not directly store the Cell data, but reference to cells, which are encoded in multiple Chunks in MSLAB, this is easier to manage the offheap ByteBuff even if writer thread finished the flushing because some other rpc may still not finish and reference to the ByteBuff; On the other hand we MUST free the ByteBuff once writer thread finished the flushing following advantages: 1. Thread safe , high concurrency and memory utilization. 2. Support reference count to track memory life cycle and detector to debug memory leak; 3. Cache coherence, which

VMware Greenplum v6.18 Documentation VMware, Inc. 54 Mapping Tables to XML 920 XML Function Reference 923 XML Predicates 928 Using Full Text Search 930 Using Full Text Search 0 About Full Text Search Gathering Information for VMware Customer Support 1045 Greenplum Database Reference Guide 1046 Greenplum Database Reference Guide 0 SQL Commands 1046 SQL Commands 0 SQL Syntax Summary 1051 SQL Syntax Considerations 1881 Client and Loader Utility Reference 1882 VMware Greenplum v6.18 Documentation VMware, Inc. 133 Client and Loader Utility Reference 0 createdb 1882 createdb 0 Synopsis 1882 Description

19 Documentation VMware, Inc. 55 Processing XML 928 Mapping Tables to XML 929 XML Function Reference 932 XML Predicates 937 Using Full Text Search 939 Using Full Text Search 0 About Full Text Search Gathering Information for VMware Customer Support 1054 Greenplum Database Reference Guide 1055 Greenplum Database Reference Guide 0 SQL Commands 1055 SQL Commands 0 SQL Syntax Summary 1060 SQL Syntax Documentation References 1894 Windows Considerations 1894 Client and Loader Utility Reference 1895 Client and Loader Utility Reference 0 createdb 1895 createdb 0 Synopsis 1895 Description 1895 Options 1896

VMware Greenplum v6.17 Documentation VMware, Inc. 50 Mapping Tables to XML 852 XML Function Reference 855 XML Predicates 860 Using Full Text Search 862 Using Full Text Search 0 About Full Text Search Gathering Information for VMware Customer Support 980 Greenplum Database Reference Guide 982 Greenplum Database Reference Guide 0 SQL Commands 982 SQL Commands 0 SQL Syntax Summary 987 SQL Syntax Documentation References 1815 Windows Considerations 1815 Client and Loader Utility Reference 1816 Client and Loader Utility Reference 0 createdb 1816 createdb 0 Synopsis 1816 Description 1816 Options 1817

......................................................................................665 VI. Reference................................................................................................ ..................................................................................1358 G.5.1. Reference Pages ......................................................................................... the server. Topics are, for instance, user-defined data types and functions. • Part VI contains reference information about SQL commands, client and server programs. This part supports the other parts with