Skip to content

MSSQL unit test failure #904

@matthewhilton

Description

@matthewhilton

On Moodle 4.5 branch https://github.com/catalyst/moodle-auth_saml2/tree/MOODLE_405_STABLE

Message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Expression type bigint is invalid for COLLATE clause.<br>

SELECT u.id
                      FROM phpu_user u 
                     WHERE u.deleted <> 1
                       AND u.mnethostid = '1'  AND u.id COLLATE SQL_Latin1_General_CP1_CS_AS = '3'
[array (
  0 => '1',
  1 => '3',
)])

/var/www/site/lib/dml/moodle_database.php:497
/var/www/site/lib/dml/sqlsrv_native_moodle_database.php:331
/var/www/site/lib/dml/sqlsrv_native_moodle_database.php:438
/var/www/site/lib/dml/sqlsrv_native_moodle_database.php:909
/var/www/site/lib/dml/sqlsrv_native_moodle_database.php:985
/var/www/site/auth/saml2/classes/user_extractor.php:86
/var/www/site/auth/saml2/tests/user_extractor_test.php:68
/var/www/site/lib/phpunit/classes/advanced_testcase.php:76

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions