neosync
neosync copied to clipboard
[NEOS-1234] Bulk Transformer Set Logic buggy for Mysql
I have a database where I fully added everything to the job mappings.
This includes foreign keyed columns.
I would expect something like we see with postgres where you pretty much only get Passthrough Generate Javascript and Transform javascript
Instead I see Passthrough, Use Column Default, and Transform Javascript:
Where is Generate? Also alarming that column default shows up for all columns when in fact most of them do not have a default value.
From SyncLinear.com | NEOS-1234
After some initial debugging, the information_schema.columns.column_default is not really sufficient here, and that is what we are using. We need to update this to return the proper default, if there is one.