Hi folks Using 1.3.153, created an embedded file-backed database.
Create a table 'devices' in the default (PUBLIC) schema. Ran "SHOW COLUMNS FROM devices" all works as expected. Decided to put table in a new schema (called MAIN). Now when I open a connection on that schema I can select from devices but the above SHOW COLUMNS call now returns zero rows. Noticed that command "SHOW COLUMNS FROM tablethatdoesnotexist" will also return zero rows. Also "SHOW COLUMNS FROM MAIN.DEVICES" returns syntax error. I had to work around this by doing a equivalent "SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS". Cheers Gary -- 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.
