Duplicate records are ingested into Azure delta tables when using BY DEFAULT parameter.
I have followed below steps.
1)Created table with identity column GENERATED BY DEFAULT
2)Inserted 2 records with id, 1 and 2
3)When inserted third row without id, it inserted id as 1 creating duplicates
A similar issue has been reported here