So, for me, it would be good to have in some place the information that an IDENTITY column is not a GENERATED column. That's what caused confusion to me.
On Tue, 23 Jul 2024 at 14:01, Diego Stammerjohann <diegostammer@gmail.com> wrote: > OK, that sounds good to me. Due to top posting I am unable to discern what part sounds good.
> So, the documentation should be update to something like this: > "An expression based generated column cannot be part of a partition key." > Sounds fair?
Sounds good, but if you analyze it there is no such thing as "An expression based generated column" defined. There are generated columns and identity columns. Unfortunately both use the keyword GENERATED in their definition / creation, probably due to some standard committee shenanigans.
