Test failed: dbType of column int_col does not match. type is integer, dbType is int

Hello!

I Have PHP 7.4.5 and MySQL 8.0.19 troubles in I have next trouble in tetst:

There was 1 failure:

  1. yiiunit\framework\db\mysql\SchemaTest::testColumnSchema
    dbType of column int_col does not match. type is integer, dbType is int.
    Failed asserting that two strings are identical.
    — Expected
    +++ Actual
    @@ @@
    -int(11)
    +int

/var/www/tests/framework/db/SchemaTest.php:521
/var/www/vendor/phpunit/phpunit/phpunit:52

On version mysql 5.7.29 there is no failure

It could be either that tests aren’t suitable for MySQL 8 or that there’s a real issue with code itself. Either way there’s an issue. Feel free to create a ticket for it at https://github.com/yiisoft/yii2/issues and, if you have some extra time, to help us with it. As far as I see:

  1. We need to run tests against MySQL 8. Currently we’re only doing it with 5.7.
  2. We need to find out if what’s failing is issue with tests or the code itself doesn’t work.
  3. We need to fix it.