[jira] [Created] (SENTRY-274) MySQL init scripts contains invalid comments

["Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>]

Jarek Jarcec Cecho created SENTRY-274:
-----------------------------------------

             Summary: MySQL init scripts contains invalid comments
                 Key: SENTRY-274
                 URL: https://issues.apache.org/jira/browse/SENTRY-274
             Project: Sentry
          Issue Type: Bug
    Affects Versions: 1.4.0
            Reporter: Jarek Jarcec Cecho
            Assignee: Jarek Jarcec Cecho
             Fix For: 1.4.0
         Attachments: SENTRY-274.patch

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

{code}
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
{code}

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



--
This message was sent by Atlassian JIRA
(v6.2#6252)