[Bug] Some query results from information_schema.columns are incorrect

[lide-reed]

Search before asking

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

Version

dev 1.0.1

What's Wrong?

MySQL [testdb]> show databases;
+--------------------+
| Database |
+--------------------+
| abc |
| testdb |
...

MySQL [testdb]> select table_schema,table_name from information_schema.columns where table_schema='abc';
Empty set (0.05 sec)

What You Expected?

The result of following query is not empty.
select table_schema,table_name from information_schema.columns where table_schema='abc';

How to Reproduce?

Still have not...

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

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

[cambyzju]

I can not reproduce the problem. Could you give more info to reproduce the problem?

[nextdreamblue]

I reproduce this problem like this:

1. create a database
2. create 17 tables like this:

CREATE TABLE `aaa` (
 `aaa` varchar(170) NOT NULL COMMENT "",
 `bbb` varchar(100) NOT NULL COMMENT "",
 `ccc` varchar(170) NULL COMMENT "",
 `ddd` varchar(120) NULL COMMENT "",
 `eee` varchar(120) NULL COMMENT "",
 `fff` varchar(130) NULL COMMENT "",
 `ggg` varchar(170) NULL COMMENT "",
 `hhh` varchar(170) NULL COMMENT "",
 `jjj` varchar(170) NULL COMMENT "",
 `kkk` varchar(170) NULL COMMENT "",
 `lll` varchar(170) NULL COMMENT "",
 `mmm` varchar(170) NULL COMMENT "",
 `nnn` varchar(70) NULL COMMENT "",
 `ooo` varchar(140) NULL COMMENT "",
 `ppp` varchar(70) NULL COMMENT "",
 `qqq` varchar(130) NULL COMMENT "",
 `rrr` bigint(20) NULL COMMENT "",
 `sss` bigint(20) NULL COMMENT "",
 `ttt` decimal(24, 2) NULL COMMENT "",
 `uuu` decimal(24, 2) NULL COMMENT "",
 `vvv` decimal(24, 2) NULL COMMENT "",
 `www` varchar(50) NULL COMMENT "",
 `xxx` varchar(190) NULL COMMENT "",
 `yyy` varchar(190) NULL COMMENT "",
 `zzz` varchar(100) NULL COMMENT "",
 `aa` bigint(20) NULL COMMENT "",
 `bb` bigint(20) NULL COMMENT "",
 `cc` bigint(20) NULL COMMENT "",
 `dd` varchar(60) NULL COMMENT "",
 `ee` varchar(60) NULL COMMENT "",
 `ff` varchar(60) NULL COMMENT "",
 `gg` varchar(50) NULL COMMENT "",
 `hh` bigint(20) NULL COMMENT "",
 `ii` bigint(20) NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`aaa`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`aaa`) BUCKETS 16
PROPERTIES (
"replication_allocation" = "tag.location.default: 2",
"in_memory" = "false",
"storage_format" = "V2"
);

i create 17 tables by this sql with other name, and get:
MySQL [aaa]> show tables;
+---------------+
| Tables_in_aaa |
+---------------+
| ooo |
| eee |
| jjj |
| ggg |
| lll |
| qqq |
| bbb |
| ddd |
| iii |
| nnn |
| kkk |
| ppp |
| aaa |
| fff |
| ccc |
| hhh |
| mmm |
+---------------+
17 rows in set (0.00 sec)

3. create 5 database total, and get
   MySQL [aaa]> show databases;
   +--------------------+
   | Database |
   +--------------------+
   | aaa |
   | bbb |
   | ccc |
   | ddd |
   | eee |
   | doris_audit_db__ |
   | information_schema |
   +--------------------+
   7 rows in set (0.00 sec)

4. and select from information_schema.columns where xxx will return empty.
   MySQL [eee]> select * from information_schema.columns where table_schema='aaa';
   Empty set (0.03 sec)

[lide-reed]

This is an issue introduced by vectorization, it just can be reproduced when set enable_vectorized_engine=true;

[cambyzju]

I have reproduce the problem while set enable_vectorized_engine=true;. Thanks~

I will try to fix it. Please assign this issue to me.

[morningman]

I have reproduce the problem while set enable_vectorized_engine=true;. Thanks~

I will try to fix it. Please assign this issue to me.

done

[cambyzju]

@lide-reed @nextdreamblue the problem already fixed, please merge the codes and try again.