On Friday, April 13, 2012 3:36:28 PM UTC+8, Noel Grandin wrote: > So, no, we don't calculate the data when doing an "alter table add column".
In my case, as mentioned in my post, the table already contains millions of rows. So when I add the computed column to the existing table with those rows, you are saying the new calculated values are NOT calculated for the existing rows during ADD COLUMN. So calculation is deferred? Since the ADD COLUMN is fast, and the calculated values are reliably present upon SELECT, the implementation is ideal. Is it possible to get this behaviour with INSERT? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/wUgiglR1USgJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
