[jira] [Created] (METAMODEL-1230) JdbcDataContext.getDefaultSchema() does not work for postgres > 9

["William Edmisten (Jira)" <ji...@apache.org>]

William Edmisten created METAMODEL-1230:
-------------------------------------------

             Summary: JdbcDataContext.getDefaultSchema() does not work for postgres > 9
                 Key: METAMODEL-1230
                 URL: https://issues.apache.org/jira/browse/METAMODEL-1230
             Project: Apache MetaModel
          Issue Type: Bug
    Affects Versions: 4.5.3
            Reporter: William Edmisten


When connected to a postgres version > 9, getDefaultSchema() returns a schema with an empty name. It also does NOT throw an exception, which it probably should in this scenario. This results in an error when trying to execute a query on this database:

 
{code:java}
Caused by: org.apache.metamodel.MetaModelException: Could not execute create table statement: CREATE TABLE .UserObjects (objectType VARCHAR, id VARCHAR, contents VARCHAR, labels VARCHAR, userId VARCHAR, shared BOOLEAN, editable BOOLEAN, created TIMESTAMP, modified TIMESTAMP, expires TIMESTAMP, classification VARCHAR, visibility VARCHAR, groups VARCHAR, name VARCHAR, comments VARCHAR, PRIMARY KEY(objectType,id)): ERROR: syntax error at or near "."
  Position: 14
	at org.apache.metamodel.jdbc.JdbcUtils.wrapException(JdbcUtils.java:70)
	at org.apache.metamodel.jdbc.JdbcCreateTableBuilder.execute(JdbcCreateTableBuilder.java:62)
	at org.apache.metamodel.create.CreateTable.run(CreateTable.java:65)
	at org.apache.metamodel.create.CreateTableColumnBuilder.run(CreateTableColumnBuilder.java:39)
	at org.apache.metamodel.jdbc.JdbcDataContext.executeUpdate(JdbcDataContext.java:837)

{code}
Tested on postgres 10, 11, and 12. Via [postgres docker image| [https://hub.docker.com/_/postgres]]

Also see: https://metamodel.apache.org/apidocs/4.5.2/org/apache/metamodel/AbstractDataContext.html#getDefaultSchema--



--
This message was sent by Atlassian Jira
(v8.3.4#803005)