nucleuscloud / neosync

Open source data anonymization and synthetic data orchestration for developers. Create high fidelity synthetic data and sync it across your environments.
https://www.neosync.dev
MIT License
2.93k stars 102 forks source link

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

Open nickzelei opened 1 month ago

nickzelei commented 1 month ago

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 commented 1 month ago

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.