[jira] [Created] (METAMODEL-1224) MetaModel-jdbc fails on newer versions of PostgreSQL

["Kasper Sørensen (Jira)" <ji...@apache.org>]

Kasper Sørensen created METAMODEL-1224:
------------------------------------------

             Summary: MetaModel-jdbc fails on newer versions of PostgreSQL
                 Key: METAMODEL-1224
                 URL: https://issues.apache.org/jira/browse/METAMODEL-1224
             Project: Apache MetaModel
          Issue Type: Bug
            Reporter: Kasper Sørensen
            Assignee: Kasper Sørensen


PostgreSQL queries on newer versions (I'm using 12) of the database are failing with a cryptic message

```
org.apache.metamodel.jdbc.RolledBackUpdateException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "."
  Position: 14
	at org.apache.metamodel.jdbc.JdbcDataContext.executeUpdate(JdbcDataContext.java:923)
	at org.apache.metamodel.jdbc.JdbcTestTemplates.simpleCreateInsertUpdateAndDrop(JdbcTestTemplates.java:580)
	at org.apache.metamodel.jdbc.integrationtests.PostgresqlTest.testCreateInsertAndUpdate(PostgresqlTest.java:84)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at junit.framework.TestCase.runTest(TestCase.java:176)
	at junit.framework.TestCase.runBare(TestCase.java:141)
	at junit.framework.TestResult$1.protect(TestResult.java:122)
	at junit.framework.TestResult.runProtected(TestResult.java:142)
	at junit.framework.TestResult.run(TestResult.java:125)
	at junit.framework.TestCase.run(TestCase.java:129)
	at junit.framework.TestSuite.runTest(TestSuite.java:252)
	at junit.framework.TestSuite.run(TestSuite.java:247)
	at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:541)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:763)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:463)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:209)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "."
  Position: 14
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:562)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
	at org.apache.metamodel.jdbc.JdbcCreateTableBuilder.execute(JdbcCreateTableBuilder.java:61)
	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:915)
	... 21 more

```

This bug reported on one of our downstream apps, DataCleaner: https://github.com/datacleaner/DataCleaner/issues/1849



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