matrixorigin / matrixorigin/matrixone

[Bug]: 单据生成sql语句执行了191秒

Open
#24,579 2 comments 0 reactions 1 assignee Claimed by @ck89119 View on GitHub
deferred kind/bug
Dominant language
Go
Stars
1.9k
Forks
311
Avg merge
1d 3h
Merged PRs (30d)
768

Description

### Is there an existing issue for the same bug?

- [x] I have checked the existing issues.

### Branch Name

dev

### Commit ID

unknown

### Other Environment Information

```Markdown
- Hardware parameters:
- OS type:
- Others:
```

### Actual Behavior

Image

[MatrixOne.Query.History.May.22.2026.csv](https://github.com/user-attachments/files/28218478/MatrixOne.Query.History.May.22.2026.csv)

数据库连接:
mysql -h freetier-01.cn-hangzhou.cluster.cn-dev.matrixone.tech -P 6001 -u "ws_bf2d347f:moi_core_system:accountadmin" -pmoi_2d76c2c1a5eb95b160e10e0b1dc47109ded45fbc9ad7641d3adcbd07ce09da78

建表sql:
CREATE TABLE `purchase_order_report` (
`ebeln` varchar(255) DEFAULT NULL COMMENT '采购凭证编号',
`lifnr` text DEFAULT NULL COMMENT '供应商代码',
`lifnr_name` text DEFAULT NULL COMMENT '供应商名称',
`bukrs` text DEFAULT NULL COMMENT '业务实体/公司名称',
`netwr_tax` text DEFAULT NULL COMMENT '订单含税金额(来源EKPO)',
`netwr` text DEFAULT NULL COMMENT '订单净值',
`ekgrp` text DEFAULT NULL COMMENT '采购组',
`eknam` text DEFAULT NULL COMMENT '采购组描述',
`ernam` text DEFAULT NULL COMMENT '采购员',
`zterm` text DEFAULT NULL COMMENT '付款条件',
`bedat` text DEFAULT NULL COMMENT '凭证日期',
`kbetr` text DEFAULT NULL COMMENT '税率',
`waers` text DEFAULT NULL COMMENT '币种',
`werks` text DEFAULT NULL COMMENT '工厂',
`werks_name` text DEFAULT NULL COMMENT '工厂描述'
) COMMENT='采购订单级报表'

建表sql:
CREATE TABLE `doc_relation` (
`doc_number_a` varchar(50) NOT NULL COMMENT '单据号A',
`doc_type_a` varchar(20) NOT NULL COMMENT '单据类型A',
`doc_number_b` varchar(50) NOT NULL COMMENT '单据号B',
`doc_type_b` varchar(20) NOT NULL COMMENT '单据类型B',
PRIMARY KEY (`doc_number_a`,`doc_type_a`,`doc_number_b`,`doc_type_b`),
KEY `idx_b` (`doc_number_b`,`doc_type_b`)
)

### Expected Behavior

_No response_

### Steps to Reproduce

```Markdown
单据页面提问:上海老姜物流供应对应的销售订单
```

### Additional information

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.