subratadeypappu

MySQL r2dbc has support for the following data types. ## Data Type Mapping The default built-in `Codec`s reference table shows the type mapping between [MySQL][m] and Java data types: |...

Going through the RFC written by Nidhi about two months ago in order to verify whether this can be a good starting point or not. ### Reference RFC https://github.com/appsmithorg/appsmith/pull/14726

Should the `undefined` value be treated as null? Wrote a [document](https://www.notion.so/appsmith/Should-the-empty-value-be-treated-as-NULL-4bba61c4e4cd4c889e041bc4179367f0) in Notion addressing this.

For MySQL Date and Timestamp/Datetime data types the following supported formats are introduced in the respective `MySQLDateType` and `MySQLDatetimeType` Appsmith data types. ### MySQL Date ``` select cast('20220822' as date)...

### Mapping of data types among JS type (client-side data type), Java type, and the respective plugin type. ## MySQL | JS Type | Java Type | Plugin Type |...

In order to consume the above payload the model `ExecuteActionDTO` needs to be changed like below: ``` public class ExecuteActionDTO { String actionId; List params; PaginationField paginationField; Boolean viewMode =...

After this change has been implemented both on the client and the server-side do we expect the paramProperties will always exist in the payload even if it's an empty array?...

We have decided to go with this structure instead as it helps the server to do less effort with respect to deserialization. ``` ------WebKitFormBoundaryj9bhZXa3DECRp83J Content-Disposition: form-data; name="executeActionDTO" {"actionId":"627a09673b06f26463e16ba8","viewMode":false, "paramProperties": {"k1":...

### Test Plan The regression test suffices as this is a compatibility change.

A demonstration of this delivery is documented [here](https://www.notion.so/appsmith/Datatype-handling-v1-4733524f73cc4e84a0ad2dd5bbd90a5f?p=70da189544134d959ff0dc2b3d74b887&pm=s).