Hi Ivo, This problem caught my eye, because I'm fascinated by code problems that occur with obscure causes.
However I've been unable to reproduce the problem. I've tried in the H2 web console and I've tried using Java code. Can you please post a self-contained source code example that I reproduces the problem? (I'm using macOS, Java 1.8.0_111, and a slighter newer build of H2). On Sunday, 26 February 2017 18:33:33 UTC+1, Ivo Panáček wrote: > > Hi, > > I have a problem. I am using recent H2 (via maven): > > <dependency> > > <groupId>com.h2database</groupId> > > <artifactId>h2</artifactId> > > <version>1.4.193</version> > > </dependency> > > > Following simple command did work as expected: > > CREATE TABLE "search_tree" ( >> >> "code" BIGINT NOT NULL >> >> ) >> > > now it creates table and the column is not visible ... tested also from > embedded web console. > > Similar command work normally: > > CREATE TABLE "searchtree" ( >> >> "code" BIGINT NOT NULL >> >> ) >> > > There is the only one difference, now I create the database with* Czech > collation*, > so after creating database, before creating tables I run command: > > SET COLLATION CZECH STRENGTH SECONDARY >> > > Without it everything works as before. > > *BUT* following command works normally even *with* Czech collation: > > CREATE TABLE "key_entries" ( >> >> "code" BIGINT NOT NULL >> >> ) >> > > *so it depends on the table name !* > > Nevertheless columns seem to exist: > > command: > >> SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'PUBLIC' > > > gives: > SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'PUBLIC'; > TABLE_CATALOG ▼ > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > TABLE_SCHEMA > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > TABLE_NAME > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > COLUMN_NAME > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > ORDINAL_POSITION > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > COLUMN_DEFAULT > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > IS_NULLABLE > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > DATA_TYPE > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > CHARACTER_MAXIMUM_LENGTH > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > CHARACTER_OCTET_LENGTH > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > NUMERIC_PRECISION > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > NUMERIC_PRECISION_RADIX > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > NUMERIC_SCALE > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > CHARACTER_SET_NAME > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > COLLATION_NAME > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > TYPE_NAME > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > NULLABLE > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > IS_COMPUTED > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > SELECTIVITY > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > CHECK_CONSTRAINT > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > SEQUENCE_NAME > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > REMARKS > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > SOURCE_DATA_TYPE > <http://10.0.10.46:8082/query.do?jsessionid=4145260ed5b3443e4d605a1d813c076a#> > IDC PUBLIC key_entries code 1 *null* NO -5 19 19 19 10 0 Unicode CZECH > BIGINT 0 FALSE 50 *null* *null* > IDC PUBLIC search_tree code 1 *null* NO -5 19 19 19 10 0 Unicode CZECH > BIGINT 0 FALSE 50 *null* *null* > > > Just they are not shown in web console. > > My real problem is, that my java code cannot read table columns. > Following call: > > ResultSet r = m.getColumns(null, null, table, null); >> > > returns proper result set with normal metadata, but the result set *is > empty.* > So my code cannot parse schema and create proper sql commands. > I guess that the same reason causes that columns are not visible in > embedded web console. > > Java is: > > java version "1.8.0_121" >> >> Java(TM) SE Runtime Environment (build 1.8.0_121-b13) >> >> Java HotSpot(TM) 64-Bit Server VM (build 25.121-b13, mixed mode) >> > > on recent macOS, tomorrow I'll test it on Ubuntu. > > Sincerely, > Ivo Panacek > -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
