#108741SQL auto-generation based on TCA does not respect the columns default value given in TCA
Description
The DefaultTcaSchema class only respects the TCA default value for TCA type check, in all other cases it just hard-coded uses the according “empty” value of the target SQL type. So empty string for string-style columns, 0 for integer-style columns and 0.0 for float-style columns, or null for nullable columns.
I expected that an explicit TCA default value is also considered by the SQL schema auto-creation.
Is there any specific reason why an explicitly configured default value is ignored? And what is so special about type check (the only where it is explicitly respected)? This actually lead to some confusion in one of our projects already, because we saw that check fields use the default and somehow also expected the other fields to behave the same.
Afaics this missing behaviour and the checkbox exception are both also not documented in TCA documentation,
neither in https://docs.typo3.org/m/typo3/reference-tca/13.4/en-us/ColumnsConfig/Type/Check/Index.html (or any other TCA type)
nor in https://docs.typo3.org/m/typo3/reference-coreapi/13.4/en-us/ExtensionArchitecture/FileStructure/ExtTablesSql.html#auto-generated-db-structure
Reported for v13 but afaics this is still valid on v14.