[#MDEV-26297] [ERROR] mysqld: Incorrect information in file: './sys/sys_config.frm' after SELECT query and using small tmp-disk-table-size

CLI Based execution seems required. Also, using SET GLOBAL does not produce the same issue (i.e. direct mysqld option is required)

# mysqld options required for replay:  --tmp-disk-table-size=1024

SELECT * FROM information_schema.TRIGGERS ORDER BY trigger_name;

10.6.4 42b9daaea7ece6155558f7c3bf638e8e175a7ff7 (Optimized)
2021-08-03 17:42:47 0 [Note] /test/MD260721-mariadb-10.6.4-linux-x86_64-opt/bin/mysqld: ready for connections.
Version: '10.6.4-MariaDB' socket: '/test/MD260721-mariadb-10.6.4-linux-x86_64-opt/socket.sock' port: 34790 MariaDB Server
2021-08-03 17:42:47 0 [Note] InnoDB: Buffer pool(s) load completed at 210803 17:42:47
2021-08-03 17:43:29 4 [ERROR] mysqld: The table '(temporary)' is full
2021-08-03 17:43:29 4 [ERROR] mysqld: Incorrect information in file: './sys/sys_config.frm'
2021-08-03 17:43:29 0 [Note] /test/MD260721-mariadb-10.6.4-linux-x86_64-opt/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown

Bug confirmed present in:
MariaDB: 10.6.4 (dbg), 10.6.4 (opt), 10.7.0 (dbg), 10.7.0 (opt)

Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.2.39 (dbg), 10.2.39 (opt), 10.3.30 (dbg), 10.3.30 (opt), 10.4.20 (dbg), 10.4.20 (opt), 10.5.11 (dbg), 10.5.11 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.34 (dbg), 5.7.34 (opt), 8.0.24 (dbg), 8.0.24 (opt)

[MDEV-26297] [ERROR] mysqld: Incorrect information in file: './sys/sys_config.frm' after SELECT query and using small tmp-disk-table-size Created: 2021-08-03 Updated: 2023-03-03
Status:	Open
Project:	MariaDB Server
Component/s:	Data Definition - Temporary, Server
Affects Version/s:	10.6, 10.7
Fix Version/s:	10.6

[MDEV-26297] [ERROR] mysqld: Incorrect information in file: './sys/sys_config.frm' after SELECT query and using small tmp-disk-table-size Created: 2021-08-03 Updated: 2023-03-03