-- Env

# System Summary Report ######################################
        Date | 2025-04-23 11:38:50 UTC (local TZ: CEST +0200)
    Hostname | bug117943
      Uptime | 1 day,  4:02,  5 users,  load average: 0.07, 0.04, 0.01
    Platform | Linux
     Release | Red Hat Enterprise Linux release 9.5 (Plow)
      Kernel | 5.15.0-306.177.4.1.el9uek.x86_64
Architecture | CPU = 64-bit, OS = 64-bit
   Threading | NPTL 2.34
    Compiler | GNU CC version 11.5.0 20240719 (Red Hat 11.5.0-5.0.1).
     SELinux | Disabled
 Virtualized | No virtualization detected
# Processor ##################################################
  Processors | physical = 1, cores = 8, virtual = 16, hyperthreading = yes
      Speeds | 16x2245.780
      Models | 16xAMD EPYC 7742 64-Core Processor
      Caches | 16x512 KB
# Memory #####################################################
       Total | 125.3G
        Free | 108.3G
        Used | physical = 4.6G, swap allocated = 4.0G, swap used = 0.0, virtual = 4.6G
      Shared | 48.8M
     Buffers | 13.6G
      Caches | 120.6G
       Dirty | 268 kB
     UsedRSS | 3.7G
  Swappiness | 60
 DirtyPolicy | 20, 10
 DirtyStatus | 0, 0

-- file system in use

[umshastr@bug117943:/bv/ushastry/mysql-9.3.0]$ df -Th .
Filesystem     Type  Size  Used Avail Use% Mounted on
/dev/sdb1      xfs   500G   42G  459G   9% /bv/ushastry




-- build (Linux - Generic (glibc 2.28) (x86, 64-bit), TAR -  https://dev.mysql.com/get/Downloads/MySQL-9.3/mysql-9.3.0-linux-glibc2.28-x86_64.tar)

[umshastr@bug117943:/bv/ushastry/mysql-9.3.0]$ cat docs/INFO_SRC
commit: b899b56aff00009abcd57baed8c2241fe4b4599b
date: 2025-03-31 09:42:56 +0200
build-date: 2025-03-31 08:02:20 +0000
short: b899b56aff00
branch: mysql-9.3.0-release

MySQL source 9.3.0
MySQL release maturity INNOVATION

-- Start up

BugNumber=118020
rm -rf $BugNumber/
bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/$BugNumber --log-error-verbosity=3
bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=$PWD/$BugNumber --core-file --socket=/tmp/mysql.sock  --port=3306 --log-error=$PWD/$BugNumber/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3  --secure-file-priv="" --local-infile=1  2>&1 &


[umshastr@bug117943:/bv/ushastry/mysql-9.3.0]$ bin/mysql t -S/tmp/mysql.sock --local-infile
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 9.3.0 MySQL Community Server - GPL

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use information_schema;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SELECT * FROM TABLES CROSS JOIN VIEWS ON TRUE EXCEPT SELECT * FROM TABLES CROSS JOIN VIEWS ON NOT FALSE;
Empty set (3.190 sec)

mysql> SELECT * FROM TABLES CROSS JOIN VIEWS ON TRUE EXCEPT SELECT * FROM TABLES CROSS JOIN VIEWS ON NOT FALSE;
Empty set (2.854 sec)

mysql> SELECT * FROM TABLES CROSS JOIN VIEWS ON TRUE EXCEPT SELECT * FROM TABLES CROSS JOIN VIEWS ON NOT FALSE;
Empty set (2.862 sec)

mysql>


-- build ((mysql-9.2.0-linux-glibc2.17-x86_64.tar)

bin/mysql -uroot -S/tmp/mysql.sock --local-infile
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 9.2.0 MySQL Community Server - GPL

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use information_schema;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed


mysql> pager rows
PAGER set to 'rows'
mysql> SELECT * FROM TABLES CROSS JOIN VIEWS ON TRUE EXCEPT SELECT * FROM TABLES CROSS JOIN VIEWS ON NOT FALSE;
Empty set (3.34 sec)

mysql> SELECT * FROM TABLES CROSS JOIN VIEWS ON TRUE EXCEPT SELECT * FROM TABLES CROSS JOIN VIEWS ON NOT FALSE;
Empty set (3.30 sec)

mysql> SELECT * FROM TABLES CROSS JOIN VIEWS ON TRUE EXCEPT SELECT * FROM TABLES CROSS JOIN VIEWS ON NOT FALSE;
Empty set (3.32 sec)

mysql>