Migration1676274910ChangeColumnTaxRateAllowThreeDecimal example

$sqlUpdateToTaxRuleTable = <<<SQL ALTER TABLE tax_rule MODIFY COLUMN `tax_rate` DOUBLE(10,2); SQL;

        $this->connection->executeStatement($sqlUpdateToTaxRuleTable);
    }

    public function testChangeColumnTaxRateOnTaxTable(): void
    {
        $migration = new Migration1676274910ChangeColumnTaxRateAllowThreeDecimal();

        $migration->update($this->connection);

        $sql = <<<SQL SELECT NUMERIC_PRECISION, NUMERIC_SCALE, COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'tax' AND COLUMN_NAME = 'tax_rate' AND TABLE_SCHEMA = :dbName; SQL;