[MDEV-27873] Test main.mysqlcheck fails with view-protocol Created: 2022-02-17  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8
Fix Version/s: 10.11

Type: Bug Priority: Major
Reporter: Lena Startseva Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: view-protocol

Attachments: File 2.test    
Issue Links:
PartOf
is part of MDEV-27691 make working view-protocol Open

 Description   

Test 2.test is a part of main.mysqlcheck. It fails with error:

CURRENT_TEST: main.2
 
mysqltest: At line 31: query 'SELECT * FROM INFORMATION_SCHEMA.TRIGGERS
 
WHERE TRIGGER_SCHEMA="#mysql50#a@b" ORDER BY trigger_name' failed: 1146: Table '#mysql50#a@b.mysqltest_tmp_v' doesn't exist

After fix this bu view-protocol should be enable in test main.mysqlcheck, main.log_tables

 Comments   
Comment by Lena Startseva [ 2022-02-18 ]

The same problem in next test (main.log_tables):

--source include/have_csv.inc
 
 
 
use mysql;
 
 
 
truncate table mysql.general_log;
 
set names binary;
 
select _koi8r'����' as test;
 
--replace_column 1 TIMESTAMP 2 USER_HOST 3 THREAD_ID
 
select * from mysql.general_log;
 
set names utf8;

It looks like a problem in engine 'csv'

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