Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21264

main.gis_notembedded fails when default charset is utf8

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.1.43
    • Fix Version/s: 10.1
    • Component/s: Tests
    • Labels:
      None

      Description

      MariaDB 10.1.42 enabled the main.gis_notembedded test. On my system, it fails with

      CURRENT_TEST: main.gis_notembedded
      safe_process[24538]: parent_pid: 20585
      safe_process[24538]: Started child 24539, terminated: 0
      --- /tmp/guix-build-mariadb-10.1.43.drv-0/mariadb-10.1.43/mysql-test/r/gis_notembedded.result   1970-01-01 00:00:00.000000000 +0000
      +++ /tmp/guix-build-mariadb-10.1.43.drv-0/mariadb-10.1.43/mysql-test/r/gis_notembedded.reject   2019-12-09 22:47:49.123631028 +0000
      @@ -4,14 +4,14 @@
          t_name varchar(64), geometry_column varchar(64), t_srid int)
           SQL SECURITY INVOKER
       begin
      -  set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,' GEOMETRY REF_SYSTEM_ID=', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end   latin1  latin1_swedish_ci       latin1_swedish_ci
      +  set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,' GEOMETRY REF_SYSTEM_ID=', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end   utf8    utf8_general_ci utf8_general_ci
       show create procedure mysql.DropGeometryColumn;
       Procedure      sql_mode        Create Procedure        character_set_client    collation_connection    Database Collation
       DropGeometryColumn             CREATE DEFINER=`root`@`localhost` PROCEDURE `DropGeometryColumn`(catalog varchar(64), t_schema varchar(64),
          t_name varchar(64), geometry_column varchar(64))
           SQL SECURITY INVOKER
       begin
      -  set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end     latin1  latin1_swedish_ci       latin1_swedish_ci
      +  set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end     utf8    utf8_general_ci utf8_general_ci
       create table t1 (a int, b int);
       call mysql.AddGeometryColumn('', 'test', 't1', 'c', 10);
       show create table t1;
       
      mysqltest: Result length mismatch
      

      I assume this is because the server is configured with -DDEFAULT_CHARSET=utf8 and -DDEFAULT_COLLATION=utf8_general_ci.

        Attachments

          Activity

            People

            Assignee:
            cvicentiu Vicențiu Ciorbaru
            Reporter:
            mbakke Marius Bakke
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: