Hello, I have a problem. When I run the SQL command "comment on column...", where the column is within view, it is ignored. It only does not work, when I run it from command line. When I run it from GUI (SQuirreL SQL), it works fine. The test case is:
--this is C:/temp/temp/test.sql set schema PUBLIC; create table T1 (ID int); comment on table T1 is 'comment on table t1'; comment on column T1.ID is 'comment on column id'; create view V1 (ID) as select ID from T1; comment on table V1 is 'comment on view v1'; comment on column V1.ID is 'comment on column id'; --select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, REMARKS from INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA = 'PUBLIC'; --comment for V1.ID is not shown --this is shell command in Windows OS java -cp "./h2-1.4.196.jar" org.h2.tools.Shell -url "jdbc:h2:file:C:/temp/temp/test;ALIAS_COLUMN_NAME=true" -user "" -password "" -sql "runscript from 'C:/temp/temp/test.sql';" May I ask You to verify, if it is the bug in H2 or is in my fault (misuse) of this command? Regards, Stepan -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
