Uploaded image for project: 'GeoServer'
  1. GeoServer
  2. GEOS-7847

Invalid SQL "auto_increment" causes PostGisRoleServiceTest and PostGisUserDetailsServiceTest to fail

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 2.9.3, 2.10.1, 2.11-beta
    • Fix Version/s: 2.9.3, 2.10.1, 2.11-beta
    • Component/s: Security
    • Labels:
      None
    • Environment:

      Description

      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, which is specific to MySQL.

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                afabiani Alessio Fabiani
                Reporter:
                bencaradocdavies Ben Caradoc-Davies [Administrator]
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: