[MDEV-21264] main.gis_notembedded fails when default charset is utf8 Created: 2019-12-10  Updated: 2023-12-20  Resolved: 2023-12-20

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.1.43
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Marius Bakke Assignee: Vicențiu Ciorbaru
Resolution: Won't Fix Votes: 0
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.



 Comments   
Comment by Elena Stepanova [ 2019-12-10 ]

Is it the only test that fails when you build the server with a different charset? I would expect there to be many.

Comment by Marius Bakke [ 2019-12-10 ]

I have not seen charset related test failures earlier in MariaDB 10.1, despite the slightly odd default.

Comment by Marius Bakke [ 2022-09-08 ]

This issue does not affect MariaDB 10.9.2 and can probably be closed.

Generated at Thu Feb 08 09:05:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.