[Task]: Update on conflict clause BBE after fixing #38991

[rdulmina]

Description

Due to ballerina-platform/ballerina-lang#38991 usage of frame variables inside on conflict clause has been removed from the on conflict clause BBE. Need to update it with the below sample after fixing ballerina-platform/ballerina-lang#38991.

import ballerina/io;

type Student record {|
    readonly int id;
    string name;
    int score;
|};

public function main() {
    table<Student> students = table [
            {id: 1, name: "John", score: 100},
            {id: 2, name: "Jane", score: 150},
            {id: 1, name: "John", score: 200}
        ];

    // Result of the following will be an error since key `John` is duplicated
    // and `isSafeReplace()` function returns error for the name `John`
    map<int>|error studentScores = map from var {name, score} in students
        select [name, score]
        on conflict isSafeReplace(name);

    io:println(studentScores);

    // Result of the following will be an error since key `1` is duplicated
    // and `isSafeReplace()` function returns error for the name `John`
    table<Student> key(id)|error studentScoresTable = table key(id) from var student in students
        select student
        on conflict isSafeReplace(student.name);

    io:println(studentScoresTable);

    table<Student> students2 = table [
            {id: 1, name: "John", score: 100},
            {id: 2, name: "Mike", score: 150},
            {id: 2, name: "Mike", score: 200}
        ];

    // Value `100` of the key `Mike` will be replaced by the second occurrence value `200`
    // since `isSafeReplace()` function returns nill for the name 'Mike`
    map<int>|error lastRoundScore = map from var student in students2
        select [student.name, student.score]
        on conflict isSafeReplace(student.name);

    io:println(lastRoundScore);

    // Return value will be just the construct type if the `on conflict` clause
    // always returns `()`
    map<int> lastRoundScore2 = map from var student in students2
        select [student.name, student.score]
        on conflict ();

    io:println(lastRoundScore2);

}

function isSafeReplace(string name) returns error? {
    if name == "John" {
        return error("Key Conflict", message = "record with same key exists.");
    }
}

Describe your task(s)

No response

Related area

-> Website

Related issue(s) (optional)

No response

Suggested label(s) (optional)

No response

Suggested assignee(s) (optional)

No response