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

[Ben Caradoc-Davies [Administrator] (JIRA)]

Title: Message Title

Ben Caradoc-Davies [Administrator] created an issue   GeoServer / GEOS-7847 Invalid SQL "auto_increment" causes PostGisRoleServiceTest and PostGisUserDetailsServiceTest to fail Issue Type: Bug 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: Medium 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   This message was sent by Atlassian JIRA (v1000.526.2#100018-sha1:d415428)

------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel