Thanks Andrei. I wasn't aware the "[*]" had that significance. I posted a suggestion in the H2 website git repo to consider indicating the applicable H2 version on the top of the ref pages.
On Wed, 5 Jan 2022 at 03:35, Andrei Tokar <[email protected]> wrote: > Hi Vladimir, > > Please take a look at your error message again: > ... amr ARRAY*[*]*, creation_ts ... > Marker [*] shows where parser had choked, and something of sort "IDENTITY, > BIGSERIAL, SERIAL, data type" is expected instead. > At this point, it should be pretty clear that ARRAY has to be typed, and > that is indeed a new requirement in 2.x, in line with SQL standard. > You can consult documentation for exact syntax: > https://h2database.com/html/datatypes.html#array_type > And yes, syntax diagrams are supposed to be up to date. > > -- > You received this message because you are subscribed to a topic in the > Google Groups "H2 Database" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/h2-database/KOE7A1de1p0/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/h2-database/fbc0af26-5d0b-41f2-9681-5df89ba0e514n%40googlegroups.com > <https://groups.google.com/d/msgid/h2-database/fbc0af26-5d0b-41f2-9681-5df89ba0e514n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Vladimir Dzhuvinov :: [email protected] -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/CA%2BdqsRKE2gtobfKJXggZqc1y1ZVunEBh82pMuwA1TCc2Y0Xx7w%40mail.gmail.com.
