Skip to content

[P1] OrderStatus 完整路径:客户定位、最近订单、全部明细 #12

Description

@Kosthi

父任务 / 依赖

背景

当前 order_status.rs 仅:

SELECT * FROM orders WHERE ... ORDER BY o_id DESC LIMIT 1

缺少客户选取(id / last name 中位)、订单头字段校验与 order_line 读取。

任务清单

  • 按赛题/TPC-C:以 c_id 或 c_last 选取客户(last name 中位规则)
  • 读取最近一笔订单:o_entry_d 非空可回读;o_carrier_id ∈ 0..10
  • 读取该订单全部 order_line
  • BEGIN…COMMIT;迁入约 3 次 batch 往返
  • 使用索引友好谓词:orders(o_w_id, o_d_id, o_c_id, o_id)

验收标准

  • 小数据集上结果与手工 SQL 一致
  • 空订单客户行为明确(成功读到空/或按规范处理)并有测试说明

参考

赛题第三章(四)OrderStatus 行;TPC-C 2.6.2.2

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    2026-final2026 final contest alignmentarea/transactionTPC-C transactionsenhancementNew feature or requestpriority/p1Ranking workload & semantics

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions