numeric

6 numeric types: 3 a sibling also accepts, 1 of which it would misread, 4 that decompose into parts, 2 in Meridian's open data.

6 types

The 6 numeric types

Each type's first registry sample, against every sibling's rule

Type	Sample	Also accepted by
Integer Number integer_number · BIGINT	42	decimal_number → 42.0; decimal_number_comma → 42.0; percentage → 42.0
Decimal Number decimal_number · DOUBLE	3.14	percentage
Scientific Notation scientific_notation · DOUBLE	1.23e-4	decimal_number
Decimal Number (Comma Separator) decimal_number_comma · DOUBLE	1.234,56	—
Percentage percentage · DOUBLE	50%	—
SI-Prefix Number si_number · DOUBLE	12.2K	—

4 of 6 numeric types accept it, and read it 2 ways.

Type	Reads it as
Integer Number `integer_number`	42
Decimal Number `decimal_number`	42.0
Decimal Number (Comma Separator) `decimal_number_comma`	42.0
Percentage `percentage`	42.0

CLI · DuckDB

$ printf '%s\n' '42' '-17' > column.txt
$ finetype infer -f column.txt --mode column

SELECT ft_profile(v) FROM (VALUES ('42'), ('-17')) t(v);