Yes, I know that is non-ANSI SQL. But it already exists, and it's clever and I think it can be published to a little bit increase social pressure to SQL vendors to support this syntax in other databases.
вс, 4 апр. 2021 г. в 19:19, Evgenij Ryazanov <[email protected]>: > Hello. > > Syntax of comments on columns in their definitions exists mostly for a > some limited compatibility with MySQL, but it was included into > documentation for some bad historic reason. Actually it shouldn't be > documented and should be accepted only in the related compatibility modes, > but what's done is done. > > Comments on database objects aren't a part of the SQL Standard, so they > are not portable across DBMS. Native support in H2 is provided by a > separate COMMENT ON command and there is no intention to add some random > alternative grammar for this purpose, unless some grammar will be > standardized or at least will be widely supported by multiple DBMS. > > Syntax that you found in the parser is internal only, it should never be > used by users of H2. It is intentionally not documented. > > -- > 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/z5kQDMUdA7w/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/3571faf4-584e-42f3-9f48-9d917688b51cn%40googlegroups.com > <https://groups.google.com/d/msgid/h2-database/3571faf4-584e-42f3-9f48-9d917688b51cn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAHMrwxQAF0t9kGuFK4tJg4ZRXXN48H_Gsx7ya%3DgzQ8AWvJc-OQ%40mail.gmail.com.
