rdagumampan / yuniql

Free and open source schema versioning and database migration made natively with .NET/6. NEW THIS MAY 2022! v1.3.15 released!
https://yuniql.io
Apache License 2.0
417 stars 63 forks source link

Yuniql fails on a MariaDB script that contains session variables #310

Open svegasoft opened 10 months ago

svegasoft commented 10 months ago

Yuniql fails on this script:

BEGIN NOT ATOMIC
   select now() into @date;
   select @date;
END

This script runs normally in MariaDB. Replacing session variable with a local one fixes the issue.
It is necessary for Yuniql to support session variables because session variables are the only way to execute dynamic sql.