Re: A generated column cannot be part of a partition key

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.

Diego H. S.

On Tue, Jul 23, 2024, 10:58 Francisco Olarte <folarte(at)peoplecall(dot)com> wrote:

> Diego:
>
> On Tue, 23 Jul 2024 at 14:01, Diego Stammerjohann
> <diegostammer(at)gmail(dot)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.
>
> Francisco Olarte.
>