Hi, > When creating views you combine tables together and sometimes want to set > the value of a column to null.
OK. In this case I suggest to use this syntax: CREATE TABLE TEST(ID IDENTITY, NAME VARCHAR) AS SELECT X, NULL; > That's why I sent it as a bug report. > So you can append it in your list of bugs. Yes, sure. I do think the right solution would be to allow CAST(NULL AS VARCHAR), however I need to understand if the workaround is feasible, so that I can give it the "right" priority. > but the worst part is about SQL portability. I agree. > A working and syntactically correct SQL on H2, MySql, PgSql, DB2, etc. has > a different result only in H2 ! Yes, that's unfortunate. I invite you to send patches to fix it :-) Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. 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.
