Getting an error when inserting the civil field with utcOffset value to the mysql datastore

[kalaiyarasiganeshalingam]

Description:
Return the following error when inserting the civil field with utcOffset value.

error: Unsupported value: {"utcOffset":{"hours":5,"minutes":30}, "year":2022,"month":10,"day":10,"hour":1,"minute":2,"second":3} for Civil

Steps to reproduce:
Run the following code with this entity to reproduce this error.

Entity:

type MedicalNeed record {|
    readonly int needId;
    int itemId;
    int beneficiaryId;
    time:Civil period;
    string urgency;
    int quantity;
|};

import ballerina/io;
import foo/medical_center.entities;

public function main() returns error? {
    entities:Client mcClient = check new ();
    entities:MedicalNeed mnItem2 = {
        needId: 2,
        itemId: 2,
        beneficiaryId: 2,
        period: {year: 2021, month: 10, day: 10, hour: 1, minute: 2, second: 3, utcOffset: {hours: 5, minutes: 30}},
        urgency: "NOT URGENT",
        quantity: 5
    };
    int[] needIds = check mcClient->/medicalneeds.post([mnItem2]);
    io:println("Created need id: ", needIds[0]);
    check mcClient.close();
}

[daneshk]

what is the problem with the civil record with an offset value?

[kalaiyarasiganeshalingam]

The problem is that MySQL does not support TIMESTAMP_WITH_TIMEZONE type[1]. The following is a root error message.

java.sql.SQLFeatureNotSupportedException: Unsupported SQL type: TIMESTAMP_WITH_TIMEZONE

[1] https://dev.mysql.com/doc/refman/8.0/en/date-and-time-types.html

[github-actions]

This issue is NOT closed with a proper Reason/ label. Make sure to add proper reason label before closing. Please add or leave a comment with the proper reason label now.

      - Reason/EngineeringMistake - The issue occurred due to a mistake made in the past.
      - Reason/Regression - The issue has introduced a regression.
      - Reason/MultipleComponentInteraction - Issue occured due to interactions in multiple components.
      - Reason/Complex - Issue occurred due to complex scenario.
      - Reason/Invalid - Issue is invalid.
      - Reason/Other - None of the above cases.