[Geoserver-devel] [JIRA] (GEOS-7847) Invalid SQL "auto_increment" causes PostGisRoleServiceTest and PostGisUserDetailsServiceTest to fail

GeoServer GeoServer Developer
,
1

Ben Caradoc-Davies [Administrator] created an issue

GeoServer / BugGEOS-7847

Invalid SQL “auto_increment” causes PostGisRoleServiceTest and PostGisUserDetailsServiceTest to fail

Issue Type:

BugBug

Affects Versions:

2.9.3, 2.10.1, 2.11-beta

Assignee:

Alessio Fabiani

Components:

Security

Created:

12/Nov/16 2:18 AM

Environment:

Debian unstable amd64:
postgresql-9.6 9.6.1-2 amd64
postgresql-9.6-postgis-2.3 2.3.0+dfsg-3 amd64

Apache Maven 3.3.9 (bb52d8502b132ec0a5a3f4c09453c07478323dc5; 2015-11-11T05:41:47+13:00)
Maven home: /home/ben/java/maven
Java version: 1.8.0_111, vendor: Oracle Corporation
Java home: /usr/lib/jvm/java-8-openjdk-amd64/jre
Default locale: en_GB, platform encoding: UTF-8
OS name: “linux”, version: “4.8.0-1-amd64”, arch: “amd64”, family: “unix”

Priority:

MediumMedium

Reporter:

Ben Caradoc-Davies [Administrator]

Invalid SQL “auto_increment” causes PostGisRoleServiceTest and PostGisUserDetailsServiceTest to fail when online tests against PostGIS are configured by a valid ~/.geoserver/postgis.properties:

Results :

Tests in error: 
  testRoleDatabaseSetup(org.geoserver.security.jdbc.PostGisRoleServiceTest): org.postgresql.util.PSQLException: ERROR: syntax error at or near "auto_increment"(..)
  testIsModified(org.geoserver.security.jdbc.PostGisRoleServiceTest): org.postgresql.util.PSQLException: ERROR: syntax error at or near "auto_increment"(..)
  testInsert(org.geoserver.security.jdbc.PostGisRoleServiceTest): org.postgresql.util.PSQLException: ERROR: syntax error at or near "auto_increment"(..)
  testModify(org.geoserver.security.jdbc.PostGisRoleServiceTest): org.postgresql.util.PSQLException: ERROR: syntax error at or near "auto_increment"(..)
  testRemove(org.geoserver.security.jdbc.PostGisRoleServiceTest): org.postgresql.util.PSQLException: ERROR: syntax error at or near "auto_increment"(..)
  testConfiguration(org.geoserver.security.jdbc.PostGisUserDetailsServiceTest): org.postgresql.util.PSQLException: ERROR: syntax error at or near "auto_increment"(..)
  testRoleCalculation(org.geoserver.security.jdbc.PostGisUserDetailsServiceTest): org.postgresql.util.PSQLException: ERROR: syntax error at or near "auto_increment"(..)
  testPersonalizedRoles(org.geoserver.security.jdbc.PostGisUserDetailsServiceTest): org.postgresql.util.PSQLException: ERROR: syntax error at or near "auto_increment"(..)

Tests run: 114, Failures: 0, Errors: 8, Skipped: 64

I think PostgreSQL uses serial not auto_increment.

Add Comment

Add Comment

This message was sent by Atlassian JIRA (v1000.526.2#100018-sha1:d415428)

Atlassian logo