Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-59596

Unit test failure with MariaDB/MySQL8

    XMLWordPrintable

Details

    • MOODLE_34_STABLE, MOODLE_35_STABLE
    • MOODLE_33_STABLE, MOODLE_34_STABLE, MOODLE_35_STABLE
    • m35_MDL-59596_DDL_Issues_With_MariaDB_10p2_SQLMode
    • Hide
      1. Testing performed via Unit Tests, at least DDL, targetting each one of the 5 supported DB: vendor/bin/phpunit core_ddl_testcase lib/ddl/tests/ddl_test.php
      2. (Regressions) The same tests above should be run on both MariaDB versions crossing theĀ SQL_MODE breaking change i.e. selecting one version among 10.2.3- e.g. 10.1.26 and one among 10.2.4+ e.g. 10.2.8
      Show
      Testing performed via Unit Tests, at least DDL, targetting each one of the 5 supported DB: vendor/bin/phpunit core_ddl_testcase lib/ddl/tests/ddl_test.php (Regressions) The same tests above should be run on both MariaDB versions crossing theĀ  SQL_MODE breaking change i.e. selecting one version among 10.2.3- e.g. 10.1.26 and one among 10.2.4+ e.g. 10.2.8

    Description

       
      Time: 17.92 minutes, Memory: 318.00MB
       
      There was 1 error:
       
      1) core_ddl_testcase::test_change_field_type
      ddl_change_structure_exception: DDL sql execution error (Truncated incorrect INTEGER value: '4.0000000000'
      ALTER TABLE t_test_table_cust0 MODIFY COLUMN anothernumber BIGINT(10) NOT NULL DEFAULT 10)
       
      /var/www/html/lib/dml/moodle_database.php:492
      /var/www/html/lib/dml/mysqli_native_moodle_database.php:1000
      /var/www/html/lib/ddl/database_manager.php:77
      /var/www/html/lib/ddl/database_manager.php:595
      /var/www/html/lib/ddl/tests/ddl_test.php:1101
      /var/www/html/lib/phpunit/classes/database_driver_testcase.php:143
       
      To re-run:
       vendor/bin/phpunit --verbose core_ddl_testcase lib/ddl/tests/ddl_test.php
      

      Attachments

        Issue Links

          Activity

            People

              matteo Matteo Scaramuccia
              dobedobedoh Andrew Lyons
              Adrian Greeve Adrian Greeve
              David Monllaó David Monllaó
              Shamim Rezaie Shamim Rezaie
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                9/Jul/18