Hi, I can't reproduce it either.
Regards, Thomas On Monday, February 27, 2017, Steve McLeod <[email protected]> wrote: > 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 [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at https://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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.
