FirebirdSQL / firebird-documentation

Firebird documentation
https://firebirdsql.org/en/documentation/
35 stars 15 forks source link

Wrong alias in MERGE example (Release notes) #187

Closed MartinKoeditz closed 1 year ago

MartinKoeditz commented 1 year ago

I think there is an error in the example of section Support for WHEN NOT MATCHED BY SOURCE in the MERGE statement

MERGE
    INTO customers c
    USING new_customers nc
    ON (c.id = nc.id)
    WHEN MATCHED THEN
        UPDATE SET  name = cd.name
    WHEN NOT MATCHED BY SOURCE THEN
        DELETE

The alias in UPDATE SET name = cd.name is wrong, isn't it?

Ref: FB 5.0 Relase Notes

mrotteveel commented 1 year ago

Yes, looks like a typo. I'll fix it. Thanks.