My understanding is that the value of a computed column is set before the actual insertion.
This will explain the observed behavior. On Aug 29, 2013 6:30 PM, "Laird Nelson" <[email protected]> wrote: > I have a column defined like this: > > rowid int as convert(_rowid_, int) > > The idea is that I am trying to effectively alias the _rowid_ column that > H2 already adds to every table, so that I can emulate an Informix database > (which adds "rowid" to every table). > > When I select rowid, the value is always 0, even after inserts. > > The _rowid_, on the other hand, increases monotonically as I would expect. > > It is as though the computation (the convert() function) runs too early. > > Is this a bug, or am I doing something wrong? > > Best, > Laird > > -- > 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 post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
