neosync icon indicating copy to clipboard operation
neosync copied to clipboard

[NEOS-1234] Bulk Transformer Set Logic buggy for Mysql

Open nickzelei opened this issue 1 year ago • 1 comments

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:

image.png

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

nickzelei avatar Jul 16 '24 18:07 nickzelei

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.

nickzelei avatar Jul 16 '24 18:07 nickzelei