We're updating the issue view to help you get more done. 

Invalid SQL "auto_increment" causes PostGisRoleServiceTest and PostGisUserDetailsServiceTest to fail

Description

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

1 2 3 4 5 6 7 8 9 10 11 12 13 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, which is specific to MySQL.

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"

Status

Assignee

Alessio Fabiani

Reporter

Ben Caradoc-Davies

Triage

None

Fix versions

Affects versions

2.10.1
2.9.3
2.11-beta

Components

Priority

Medium