E
E
entermix2018-07-29 17:28:14
MySQL
entermix, 2018-07-29 17:28:14

Why are variable names lost in triggers?

There is MariaDB 10.3. In the database triggers like:

BEGIN
    DECLARE _statusName VARCHAR(32);
...

In phpMyAdmin it looks like this:
BEGIN
    DECLARE  VARCHAR(32);
...

Ok, phpMyAdmin is buggy? I try dbForge Studio for MySQL - the same thing is there and highlights errors, I do a dump:
mysqldump -u... -p... --routines --no-create-info --no-data --no-create-db --skip-opt dbname > triggers.sql

Everything is ok, everything works fine. Such a problem with all variable names. I try to declare names without underscores - everything is ok. What's the magic? How to treat?
PS Previously, MariaDB 5.5 was installed, everything was fine.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question