Fractional seconds on mariadb

[rbrigot]

With mysql sqitch uses fractional seconds for versions 5.06.04 or higher.
But with mariadb sqitch does not use fractional seconds and deployments are very slow.

=>

sqitch/lib/App/Sqitch/Engine/mysql.pm

Line 220 in a63cc35

has _fractional_seconds => (

has _fractional_seconds => (
    is      => 'ro',
    isa     => Bool,
    lazy    => 1,
    default => sub {
        my $dbh = shift->dbh;
        return $dbh->{mysql_serverinfo} !~ **/mariadb/i**
            && $dbh->{mysql_serverversion} >= 50604;
    },
);

Is it possible to add it for mariadb or force fractional seconds use ?

[rbrigot]

I would like to make a pull request but I don't know how to build the project, I don't have the Build.PL file

[theory]

Yeah it's a slight PITA to bootstrap it, but the easiest thing to do is to run

cpanm --cpanfile dist/cpanfile --installdeps .

You should then have the dependencies to run, e.g.,

export SQITCH_TEST_MYSQL_URI=db:mysql://root:password@localhost:3306/information_schema
prove -lv t/mysql.t

[rbrigot]

Thanks a lot for your help !

I did this pull request : #658

[theory]

Awesome, thanks! Merged via #660.

[rbrigot]

Thanks ! Do you know when the next release will be created ?

[theory]

Sometime in the next few weeks, I expect.