[Bug] SELECT query result weird

[mysqldba-nandy]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Version

1.2.4

What's Wrong?

mysql> select listed_board, count() from security_info group by listed_board order by listed_board;
+--------------+---------+
| listed_board | count() |
+--------------+---------+
| NULL         |  663612 |
| 1            |    3975 |
| 3            |    1973 |
| 4            |     852 |
| 5            |    2479 |
| 6            |     369 |
| 7            |       4 |
| 8            |     482 |
+--------------+---------+
8 rows in set (0.04 sec)

mysql> select count() from security_info where listed_board='1';
+---------+
| count() |
+---------+
|    3904 |
+---------+
1 row in set (0.03 sec)

mysql> select count() from security_info where listed_board=1;
+---------+
| count() |
+---------+
|    3975 |
+---------+
1 row in set (0.03 sec)

The data type of column listed_board is varchar(6), not int. The result of listed_board='1' is weird, on the contrary, listed_board=1 is right.

What You Expected?

The result of select count() from security_info where listed_board='1' should be 3975. Right data type, right result.

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[mysqldba-nandy]

table definition

CREATE TABLE `security_info` (
  `sec_code_par` varchar(75) NOT NULL,
   ...
  `listed_board` varchar(6) NULL,
   ...
) ENGINE=OLAP
UNIQUE KEY(`sec_code_par`)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(`sec_code_par`) BUCKETS 3
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"in_memory" = "false",
"storage_format" = "V2",
"enable_unique_key_merge_on_write" = "true",
"disable_auto_compaction" = "false"
)