Alpha

These pages are built from main, turborel 0.0.0. Anything may change from one build to the next: SQL, API, protocol and files alike.

Appendix E: Implementation-Defined Choices

The standards leave some things to each implementation. turborel's choices:

By clause of the standard

What Turborel
The character set; its order Unicode, SQL_TEXT; strings ordered by Unicode scalar value, unless a collation says otherwise
LIKE under a collation by each character's folding; under UNICODE and the collations of languages, each run of the pattern's characters matches a part of the value equal to it
The end of a line \n or \r\n
NUMERIC and DECIMAL of no precision 18 digits
DECIMAL; INTEGER; SMALLINT; BIGINT as written; NUMERIC(10, 0); NUMERIC(5, 0); NUMERIC(18, 0)
FLOAT, REAL, DOUBLE PRECISION 24 binary digits for FLOAT(p) of p up to 24, else 53; REAL 24; DOUBLE PRECISION and FLOAT 53
DECFLOAT of no precision; the greatest precision 34 digits; 34
The range of DECFLOAT an exponent of its leading digit from -6143 to 6144
Rounding to DECFLOAT half to even
An arithmetic result with a DECFLOAT operand DECFLOAT(34)
A DECFLOAT value as text plain, unless it has more than 34 digits before the point or 6 zeros after it, then in E notation
The precision of COUNT and SUM; the scale of AVG 18; the argument's and 2 more; of DECFLOAT, DECFLOAT(34)
A quotient of exact numbers 18 digits, at the largest scale that fits, truncated
A number stored in an exact type of a smaller scale an exact one or a DECFLOAT truncated; an approximate one rounded
Where nulls sort after every value: last ascending, first descending
The national character set SQL_TEXT: NATIONAL CHARACTER is CHARACTER
The longest fraction of a second 6 digits, microseconds
An interval's leading field at most 9 digits
The difference of two datetimes truncated, toward 0, to its least field
A session's time zone the setting SESSION.TIME_ZONE, +00:00 unless set
The least and greatest time zone displacements -12:59 and +14:00
CURRENT_USER, SESSION_USER, SYSTEM_USER CURRENT_USER the session's authorization identifier, or null in a trigger or routine of a schema a role owns; SESSION_USER and SYSTEM_USER the session's user
Who may create a role the database's owner, and each user it allows by ALTER USER ... CREATE ROLE
The default schema the session's authorization identifier, until SET SCHEMA
The catalog's name the setting CATALOG.NAME, TURBOREL unless set
What a CREATE SCHEMA needs a session's own schema, its AUTHORIZATION its own identifier or the role it has set
Whether a session may SET SESSION AUTHORIZATION a session begun by the database's owner, to any; any other, only to its own
The isolation levels SERIALIZABLE as itself; REPEATABLE READ as snapshot isolation; READ COMMITTED and READ UNCOMMITTED with a snapshot of each statement
A session's end with a transaction open COMMIT, or ROLLBACK, as the setting SESSION.COMMIT_AT_END says
The most savepoints of a transaction 1,024
ROLLBACK TO SAVEPOINT: cursors, prepared statements, diagnostics every open cursor closed, one opened before the savepoint too; no prepared statement deallocated; the diagnostics area tells of the ROLLBACK as of any statement
The diagnostics area one condition, of the last statement; MORE is N
An SQL-server's name an address, 'host:port' or a socket's path
A view not materialized: its query is read into each query that reads it
A constraint not named named for its table, its kind and a number: T_PRIMARY1
The null treatment of a UNIQUE constraint or predicate that writes none NULLS DISTINCT
Two rows all null, under NULLS NOT DISTINCT the same: a key refuses the second, and UNIQUE is false of them
A sequence generator of no type; its bounds unwritten NUMERIC(18); ascending, 1 to the type's greatest value, descending, its least to -1
The values a crash skips of a sequence generator at most 1024, those reserved and not given out
A recursive query with no fixpoint refused after EXECUTOR.MAX_ITERATIONS iterations, a million unless the session sets another, 0 for no limit
How a recursive query is evaluated over every row each iteration, as the standard says, or over only the rows the last iteration added where that gives the same rows
The order of a recursive query's rows as they are found, unless ORDER BY orders them
An array type's maximum cardinality written without one; the greatest 65,535; 65,535
The names of a row's fields made of values, as by ROW(...) F1, F2 and so on, by place, described as UNNAMED
UNNEST's ordinality column INTEGER
A distinct type's source of an exact or an approximate type NUMERIC of its precision and scale; FLOAT of its precision
The SQL-path, where a function's name not qualified is found the schema of the statement's names, the session's default schema or a schema statement's own
A session's transform group of a distinct type the one its definition makes, so a value goes to and from the host as its source's
The order of ARRAY_AGG's elements without ORDER BY as the rows are read
Which identifiers are users any, of a program's own session; of a server's client, the users the database keeps
JSON_VALUE and JSON_QUERY of no RETURNING CHARACTER VARYING(32767)
A PASSING argument of an interval cast to CHARACTER VARYING(32767)
The JSON text of a context item or a FORMAT JSON argument parsed WITHOUT UNIQUE KEYS before the path is evaluated, so text that is not JSON is SQLSTATE 22032 whether the path reads it or not
Members of one key in JSON text all kept, in the order written; a member accessor takes the first, .* and keyvalue() give all, and none raises an exception
A subscript that is not a whole number truncated toward zero
The type of number() a number's own; of a string, that of the numeric literal it is
The type of string() CHARACTER VARYING(32767)
keyvalue()'s id the object's place in the sequence keyvalue() is applied to, from 0
A comparison, like_regex or starts with of one item in error and one that succeeds True in lax mode, Unknown in strict mode
Which error datetime() raises of several items in error the first item's
A path whose evaluation must raise an exception, as strict $[last+1] accepted, the exception raised as it is evaluated
An SQL/JSON item as JSON text no white space between tokens; members in the order kept; only ", \ and control characters escaped; a DECFLOAT without an exponent
JSON_OBJECT, JSON_ARRAY, JSON_OBJECTAGG and JSON_ARRAYAGG of no RETURNING CHARACTER VARYING(32767)
A constructor's input of a type it does not keep, as a date cast to CHARACTER VARYING(32767)
An element FORMAT JSON of JSON_ARRAY or JSON_ARRAYAGG parsed WITHOUT UNIQUE KEYS
The order of JSON_ARRAYAGG's elements without ORDER BY as the rows are read

CONFORMANCE.md lists each choice with the rule it is of.