Details
Description
Hi,
In addition of MariaDB being impacted by Bug#115526 : Invalid multi-line "use" in slow query log file with multi-line schema, the "Schema" part of the file is wrong. How to reproduce below.
I only tested with MariaDB 11.4.2, but I guess many other versions are affected.
A suggestion for fixing this is in the upstream bug report.
Many thanks for looking into this,
Jean-François Gagné
v=mariadb_11.4.2
|
dbdeployer deploy single $v -c slow_query_log_file=slow.log -c slow_query_log=ON
|
cd ~/sandboxes/msb_${v//./_}
|
db_name='test
|
jfg'
|
./use <<< "create database \`$db_name\`; create table \`$db_name\`.t(id int); insert into \`$db_name\`.t values (1);"
|
./use "$db_name" <<< "set session long_query_time=0.5; select sleep(1), t.* from t;" > /dev/null
|
|
tail -n 10 data/slow.log
|
# Time: 240705 19:12:03
|
# User@Host: msandbox[msandbox] @ localhost []
|
# Thread_id: 5 Schema: test
|
jfg QC_hit: No
|
# Query_time: 1.000310 Lock_time: 0.000058 Rows_sent: 1 Rows_examined: 1
|
# Rows_affected: 0 Bytes_sent: 108
|
use test
|
jfg;
|
SET timestamp=1720206723;
|
select sleep(1), t.* from t;
|
Attachments
Issue Links
- causes
-
MDEV-34952 main.log_slow test failure on opensuse builder
- Closed