ORDER BY [] [placement>] [, [] [placement>] ...] ::= {ASC | DESC} placement> ::= NULLS {FIRST | LAST} Выражение секционирования. order_exp Выражение сортировки. direction Наравление сортировки. nulls placement Положение псевдозначения NULL в отсортированном наборе. aggregate function Агрегатная функция. данных 22001 String data, right truncation Строковые данные, усечены справа 22002 Null value, no indicator parameter Значение NULL, параметр не обозначен 22003 Numeric value out of range Числовое значение

character set and collation, scale, a pointer to the data itself and some flags, including the NULL indicator. This declaration only works if the external function is written using a handle.  When passing [ORDER BY [] [placement>] [, [] [placement>] ...] ::= {ASC | DESC} placement> ::= NULLS {FIRST | LAST} Chapter 10. Window (Data Exception) 22000 Data exception 22001 String data, right truncation 22002 Null value, no indicator parameter 22003 Numeric value out of range 22004 Null value not allowed 22005 Error in assignment

[ORDER BY [] [placement>] [, [] [placement>] ...] ::= {ASC | DESC} placement> ::= NULLS {FIRST | LAST} Tabelle 201. Argumente (Data Exception) 22000 Data exception 22001 String data, right truncation 22002 Null value, no indicator parameter 22003 Numeric value out of range 22004 Null value not allowed 22005 Error in assignment array target 2200F Zero-length character string 2200G Most specific type mismatch 22010 Invalid indicator parameter value 22011 Substring error 22012 Division by zero 22014 Invalid update value 22015

they come first in ascending sorts and last in descending sorts. You can override this default placement by adding a NULLS FIRST or NULLS LAST directive to the ORDER BY clause. In earlier versions, NULLs could force them to the top or bottom. To sum it all up: Table 6. NULLs placement in ordered columns Ordering NULLs placement Firebird 1 Firebird 1.5 Firebird 2 order by Field [asc] bottom bottom top same is true for NULLS LAST on any sort in Firebird 1.5.  • If you override the default NULLs placement, no index will be used for sorting. In Firebird 1.5, that is the case with NULLS FIRST. In 2.0

DEBUG, DESCRIBE, DISPLAY, ECHO, EDIT, EVENT, EXTERN, FOUND, GOTO, GROUP_COMMIT_, HELP, IMMEDIATE, INDICATOR, INIT, INPUT, ISQL, LC_MESSAGES, LC_TYPE, LEV, LOG_BUFFER_SIZE, MAX_SEGMENT, MAXIMUM, MESSAGE DESCRIBE DISPLAY ECHO EDIT EVENT EXTERN FOUND GOTO GROUP_COMMIT_ GROUP_COMMIT_WAIT HELP IMMEDIATE INDICATOR INIT INPUT ISQL LC_MESSAGES LC_TYPE LEV LOG_BUF_SIZE LOG_BUFFER_SIZE LOGFILE MAX_SEGMENT MAXIMUM параметров ::= базовый язык или переменная PSQL для возвращаемого значения ::= [INDICATOR]:host_lang_intvar • Выражения в параметрах не поддерживаются в статическом ESQL и в версиях Firebird

were always at the end. If you have client code or PSQL definitions that rely on the legacy NULLs placement, it will be necessary to use the NULLS LAST option in your ORDER BY clauses for ascending sorts

(Data Exception) 22000 Data exception 22001 String data, right truncation 22002 Null value, no indicator parameter 22003 Numeric value out of range 22004 Null value not allowed 22005 Error in assignment array target 2200F Zero-length character string 2200G Most specific type mismatch 22010 Invalid indicator parameter value 22011 Substring error 22012 Division by zero 22014 Invalid update value 22015 table 22012 Division by zero 22020 Invalid limit value 22021 Character not in repertoire 22022 Indicator overflow 22023 Invalid parameter value 22024 Character string not properly terminated 22025 Invalid

can see at address 0x0b4f10 on the page, that the byte there has the value of 0x01. This is an indicator that the page in ppg_page[0] — page 0xca — is full to capacity (bit 0 set) and does not have any