ballerina-platform/ballerina-library

Bulk insert failed when passing null values records along with the other records

Opened this issue · 0 comments

Description:
When we pass multiple records like the below to the persist SQL post-request function,
Note: one record should contain nil values and one record should not contain any record value

DoctorInsert doctor1 = {
  id: 1,
  name: "Doctor Mouse",
  specialty: "Physician",
  phoneNumber: "077100100",
  salary: 20000
};

DoctorInsert doctor2 = {
  id: 1,
  name: "Doctor Mouse",
  specialty: (),
  phoneNumber: (),
  salary: 20000
};

Falied giving following issue,
Batch Execute cannot contain different SQL commands. These have to be executed in different function calls