Skip to content

[P1] Payment / Delivery 对齐 BATCH 边界与远程/中位客户规则 #14

Description

@Kosthi

父任务 / 依赖

背景

Payment/Delivery 主路径已有较完整实现,但需迁入排名 BATCH、补齐远程比例与中位客户等细节,并服务 Delivery「实际处理行数」门禁统计。

任务清单

Payment

  • 远程客户仓约 30%
  • 按姓检索时中位客户选取规则
  • w_ytd / d_ytd / customer / history 同事务更新
  • 2-batch 依赖阶段

Delivery

  • 十区 MIN(no_o_id) 最早未配送;空区跳过
  • SUM(ol_amount) 更新 c_balance + c_delivery_cnt;删 new_orders;写 carrier/delivery_d
  • 统计「本笔实际处理的订单数/明细」供门禁
  • 2–3 batch 边界;全空直接 COMMIT 仍算提交,但不算「实际处理」

验收标准

  • 与现有逻辑回归通过;BATCH 路径下可完成提交
  • 报告能区分空 Delivery 与有效 Delivery

参考

赛题第三章(四)、附件 A §7

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