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)

Reply via email to