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
              Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                9/Jul/18