DOMAIN dm_nums AS varchar(20) CHARACTER SET UTF8 COLLATE nums_coll; -- original (manufacturer) numbers CREATE TABLE wares(id int primary key, articul dm_nums ...); См. также: DROP Accepted = 1 UNION ALL SELECT number, name FROM SuspendedMembers WHERE Vindicated = 1 INSERT INTO numbers(num) WITH RECURSIVE r(n) AS ( SELECT 1 FROM rdb$database UNION ALL SELECT n+1 FROM r where рекурсивным CTE MERGE INTO numbers USING ( WITH RECURSIVE r(n) AS ( SELECT 1 FROM rdb$database UNION ALL SELECT n+1 FROM r WHERE n < 200 ) SELECT n FROM r ) t ON numbers.num = t.n WHEN NOT MATCHED

которого мы заслуживаем Тесты производительности: анализ запросов Запрос: SELECT count() FROM system.numbers WHERE NOT ignore( materialize('xxxxxxxxxxxxxxxxxx') AS s, concat(s, s, s, s, s, s, s, s, s, s) анализ запросов :) SELECT count() FROM numbers(5000000) WHERE NOT ignore ... Elapsed: 4.123 sec, processed 40.00 MB (1.21 million rows/s.) :) SELECT count() FROM numbers(5000000) WHERE NOT ignore ... Elapsed: million rows/s.) :) SELECT count() FROM numbers(5000000) WHERE NOT ignore ... Elapsed: 2.648 sec, processed 40.00 MB (1.89 million rows/s.) :) SELECT count() FROM numbers(5000000) WHERE NOT ignore ... Elapsed:

используются. Пример: CREATE TABLE NUMBERS ( BIGNUM NUMERIC(18), SMALLNUM NUMERIC(9)) EXECUTE BLOCK ( DIVIDEND TYPE OF COLUMN NUMBERS.BIGNUM = ?, DIVISOR TYPE OF COLUMN NUMBERS.SMALLNUM = ?) RETURNS ( QUOTIENT QUOTIENT TYPE OF COLUMN NUMBERS.BIGNUM, REMAINDER TYPE OF COLUMN NUMBERS.SMALLNUM) AS BEGIN QUOTIENT = :DIVIDEND / :DIVISOR; REMAINDER = MOD (:DIVIDEND, :DIVISOR); SUSPEND; 114 Руководство по языку RETURNS( AA INTEGER, BB INTEGER, SM INTEGER, DF INTEGER) AS BEGIN FOR SELECT DISTINCT A, B FROM NUMBERS ORDER BY A, B INTO :AA, :BB DO BEGIN SM = :AA + :BB; DF = :AA - :BB; SUSPEND; END END CREATE

"Boolean": [true, false, true] Справочное руководство по языку PlantUML (1.2021.2) 190 / 387 11.5 JSON numbers 11 DISPLAY JSON DATA } @endjson 11.4.2 Minimal array or table 11.4.3 Number array @startjson "2b", "3c"] @endjson 11.4.5 Boolean array @startjson [true, false, true] @endjson 11.5 JSON numbers @startjson { "DecimalNumber": [-1, 0, 1], "DecimalNumber . Digits": [-1.1, 0.1, 1.1], "DecimalNumber can use numbered and bulleted lists in node text, notes, etc. TODO: FIXME ￿ You cannot quite mix numbers and bullets in a list and its sublist. @startuml object demo { * Bullet list * Second item } note

"Boolean": [true, false, true] Справочное руководство по языку PlantUML (1.2021.1) 188 / 382 11.5 JSON numbers 11 DISPLAY JSON DATA } @endjson 11.4.2 Minimal array or table 11.4.3 Number array @startjson "2b", "3c"] @endjson 11.4.5 Boolean array @startjson [true, false, true] @endjson 11.5 JSON numbers @startjson { "DecimalNumber": [-1, 0, 1], "DecimalNumber . Digits": [-1.1, 0.1, 1.1], "DecimalNumber can use numbered and bulleted lists in node text, notes, etc. TODO: FIXME ￿ You cannot quite mix numbers and bullets in a list and its sublist. @startuml object demo { * Bullet list * Second item } note

"Boolean": [true, false, true] Справочное руководство по языку PlantUML (1.2021.2) 201 / 405 11.5 JSON numbers 11 DISPLAY JSON DATA } @endjson 11.4.2 Minimal array or table 11.4.3 Number array @startjson "2b", "3c"] @endjson 11.4.5 Boolean array @startjson [true, false, true] @endjson 11.5 JSON numbers @startjson { "DecimalNumber": [-1, 0, 1], "DecimalNumber . Digits": [-1.1, 0.1, 1.1], "DecimalNumber can use numbered and bulleted lists in node text, notes, etc. TODO: FIXME ￿ You cannot quite mix numbers and bullets in a list and its sublist. @startuml object demo { * Bullet list * Second item } note

"Boolean": [true, false, true] Справочное руководство по языку PlantUML (1.2023.11) 270 / 553 11.6 JSON numbers 11 DISPLAY JSON DATA } @endjson 11.5.2 Minimal array or table 11.5.3 Number array @startjson "2b", "3c"] @endjson 11.5.5 Boolean array @startjson [true, false, true] @endjson 11.6 JSON numbers @startjson { "DecimalNumber": [-1, 0, 1], "DecimalNumber . Digits": [-1.1, 0.1, 1.1], "DecimalNumber can use numbered and bulleted lists in node text, notes, etc. TODO: FIXME ￿ You cannot quite mix numbers and bullets in a list and its sublist. @startuml object demo { * Bullet list * Second item } note

@endjson Справочное руководство по языку PlantUML (1.2020.23) 185 / 305 13.5 JSON numbers 13 DISPLAY JSON DATA 13.5 JSON numbers @startjson { "DecimalNumber": [-1, 0, 1], "DecimalNumber . Digits": [-1.1, 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185 13.5 JSON numbers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 186 13.6

@endjson Справочное руководство по языку PlantUML (1.2020.22) 173 / 293 13.5 JSON numbers 13 DISPLAY JSON DATA 13.5 JSON numbers @startjson { "DecimalNumber": [-1, 0, 1], "DecimalNumber . Digits": [-1.1, 0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173 13.5 JSON numbers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174 13.6

Pupils where not (PhoneNumber is null) /* делает то же самое, что и предыдущий пример */ • update Numbers set Total = A + B + C where A + B + C is not null Можно сказать, что в то время как равенство «=»