matrixorigin / matrixorigin/matrixone
[Bug]: 单据生成sql语句执行了191秒
- 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
[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
Assessment
This issue has not been assessed yet.