Bug with duplicate column names via JDBC MetaData (ORDINAL_POSITION)
От | j.random.programmer |
---|---|
Тема | Bug with duplicate column names via JDBC MetaData (ORDINAL_POSITION) |
Дата | |
Msg-id | 171323.40102.qm@web31106.mail.mud.yahoo.com обсуждение исходный текст |
Ответы |
Re: Bug with duplicate column names via JDBC MetaData
(ORDINAL_POSITION)
|
Список | pgsql-jdbc |
While using JDBC MetaData for my O/R tool, I've come across this bug recently; ---------------- Background ------------------- Postgres version: 8.3.3 JDBC driver version: 8.3-604 JDBC 3 test=# \d pg_ts_dict; Table "pg_catalog.pg_ts_dict" Column | Type | Modifiers ----------------+------+----------- dictname | name | not null dictnamespace | oid | not null dictowner | oid | not null dicttemplate | oid | not null dictinitoption | text | Indexes: "pg_ts_dict_dictname_index" UNIQUE, btree (dictname, dictnamespace) "pg_ts_dict_oid_index" UNIQUE, btree (oid) ---------------------JDBC MetaData bug ------------------- When getting JDBC Meta data, the column numbers for the following 2 columns, via ('ORDINAL_POSITION') of the 2 columns are IDENTICAL: [1] colname=dictname, colnum=1, sqltype=12, typename=name, colsize=2147483647, nullable=false, isAutoIncrement=false, remarks=null,hasRemarks=false, isPK=false, fkdata=null] --and-- [2] colname=dict_name, colnum=1, sqltype=12, typename=text, colsize=2147483647, nullable=false, isAutoIncrement=false, remarks=null,hasRemarks=false, isPK=false, fkdata=null] ------------------------------------------------------------- Note, "dict_name" does not show up via the \d pg_ts_dict output above but this, possibly extraneous column, does show up in the JDBC MetaData. Of course, it's possible that JDBC is not supposed to work with pg_* tables (system space?) but as of now, this is severely breaking my O/R tool. --j
В списке pgsql-jdbc по дате отправления: