Issue with entrypoint with DELIMITER?

[nicon89]

I have an issue with SQL entrypoint, which runs without any issues when imported manually.

Error:

database    | 2021-03-08 16:07:08+00:00 [Note] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/0.sql
database    | 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 'DELIMITER $$
database    | /*!50003 DROP TRIGGER*//*!50032 IF EXISTS */ /*!50003 `test` */$$' at line 3

Example SQL file:

/* Trigger structure for table `test` */

DELIMITER $$

/*!50003 DROP TRIGGER*//*!50032 IF EXISTS */ /*!50003 `test` */$$

Image:
REPOSITORY          TAG                 IMAGE ID            CREATED             SIZE
mysql               5.7                 d54bd1054823        9 days ago          449MB

Docker version:
19.03.8

Can someone help me with this, please?

[yosifkit]

The entrypoint script just passes the .sql file contents to the mysql client, so seems it could be related to this old bug: https://bugs.mysql.com/bug.php?id=11523.

mysql/template/docker-entrypoint.sh

Line 72 in d9fecf6

*.sql) mysql_note "$0: running $f"; docker_process_sql < "$f"; echo ;;

mysql/template/docker-entrypoint.sh

Line 217 in d9fecf6

mysql --defaults-extra-file=<( _mysql_passfile "${passfileArgs[@]}") --protocol=socket -uroot -hlocalhost --socket="${SOCKET}" --comments "$@"

\d works though.

root@f7fd9a6e9667:/# mysql -uroot -p12345 -hlocalhost --comments <<'EOF'
/* Trigger structure for table `test` */

\d $$

SELECT * FROM mysql.user $$
EOF
mysql: [Warning] Using a password on the command line interface can be insecure.
... [mysql.user table]

[tombriggsallego]

I'm having the same issue. It works fine up until 8.0.21 but is broken with 8.0.22 and 8.0.23. Just given the dates of the commits involved I think maybe the issue is the addition of the "--comments" option here but I don't know how to test that theory.

[tombriggsallego]

I can confirm that this is due to the --comments flag. Since the comment stripping feature of the mysql client is deprecated we probably need to get used to making things work with --comments enabled though, unfortunately. To do that I used a bit of Perl from here to remove all multi-line comments from our .sql files before pushing them into the docker container; after that everything works fine.

[tianon]

@ltangvald 🙈 ❤️ 🙏

Following up on #718 and #728, it sounds like the deprecation of --comments is probably the reason I was looking for in #718 (comment) for why we shouldn't enable it 😅

So, I guess we're looking for alternate ways to fix #718 so we can revert #728 again? 😬