Bug #112297 Wrong query output type 2

• Submitted: 8 Sep 2023 8:48
• Modified: 8 Sep 2023 9:38
• Reporter: Pedro Ferreira
• Status: Verified
• Category: MySQL Server: Information schema
• Severity: S3 (Non-critical)
• Version: 8.1.0, 8.0.34
• OS: Ubuntu (22.04)
• CPU Architecture: x86 (x86_64)
• Tags: min

[8 Sep 2023 8:48] Pedro Ferreira

Description:
This bug is similar to Bug #112151.

Create the following table:

CREATE TABLE t0 (c0 TINYINT);

Then on MySQL client with the option `--column-type-info` run this query:

SELECT c0 FROM (SELECT min(x.x) FROM (SELECT t0.c0 FROM t0) x(x)) t0(c0) ORDER BY c0;

The query output type is LONGLONG, while I expect it to be TINY. Is this a bug? if not, please close this.

The compilation parameters are the same as issue 108148:

-DWITH_DEBUG=1 -DWITH_ASAN=ON -DWITH_UBSAN=ON and boost library version 1.77

How to repeat:
Run the statements above.

[8 Sep 2023 9:38] MySQL Verification Team

Hello Pedro Ferreira,

Thank you for the report and feedback.

regards,
Umesh