Uploaded image for project: 'Sentry'
  1. Sentry
  2. SENTRY-274

MySQL init scripts contains invalid comments

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.0
    • Fix Version/s: 1.4.0
    • Component/s: None
    • Labels:

      Description

      When trying to load the MySQL init script directly (without using schematool), I'm hitting following error:

      jarcec@garfield sentry % mysql < sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.4.0.sql 
      ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--Licensed to the Apache Software Foundation (ASF) under one or more
      --contribut' at line 1
      

      This is due to the fact that MySQL comments starts with "-- " - e.g. two dashes AND space.

        Attachments

        1. SENTRY-274.patch
          2 kB
          Jarek Jarcec Cecho

          Activity

            People

            • Assignee:
              jarcec Jarek Jarcec Cecho
              Reporter:
              jarcec Jarek Jarcec Cecho
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: