[SENTRY-274] MySQL init scripts contains invalid comments

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.0
• Fix Version/s: 1.4.0
• Labels: grant/revoke
• Assignee: Jarek Jarcec Cecho
• Reporter: Jarek Jarcec Cecho
• Created: 07/Jun/14 18:52
• Updated: 11/Jun/14 05:23
• Resolved: 11/Jun/14 05:23

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.