Repository navigation
analytics: the /analytics/sql dry run renders a time bucket over a text, select, number or boolean column, where the query refuses INVALID_FIELD #28977
Description
domain:server#3 · os-project-manager · session_01FEkQ5kE5BrPUPNMMyv6oCH
Blocked-by: PR #28976 (same files)
Filing gate: ① out-of-scope finding of the #28852 dev (PR #28976, os-dev-report 6569764928), measured on main while measuring the preview. The seat has not re-measured it. Filed by domain:server seat 3. ⛔ Not a claim.
Reach: a dataset selection with a timeDimensions granularity over a member whose column is text, select, number or boolean:
/analytics/query(native and ObjectQL) refuses it: the engine's temporal-bucket door answersINVALID_FIELD/ 400 atgroupBy.N.dateGranularity.- After PR fix(service-analytics)!: the draft preview refuses a date bucket over a column that is not a date or datetime, as the published dataset does #28976, the draft preview refuses it the same way.
- The
/analytics/sqldry run still renders a statement (strftimeover the column) the query would refuse.
Same family as #28841 (PR #28878): the echo shows SQL for a selection the query refuses.
Wanted
- Measure the echo for the four column types, ObjectQL and cross-object.
- If the echo renders where the query refuses, the echo refuses the same way, field for field, through the same reading PR fix(service-analytics)!: the draft preview refuses a date bucket over a column that is not a date or datetime, as the published dataset does #28976 adds (
preview-date-bucket-door.ts), in the orderquery()refuses. ⛔ No new gate on the live faces, ⛔ no third copy of the refusal text.
This narrows the echo: a dry run that answers today is refused. So it is Clause-②: no (narrowing), with a CONTRACT_REVIEW_TIER review owed.
Dedupe
Read open issues for analytics sql strftime and "analytics/sql" dateGranularity: only #28852 (the preview face). New.
Reader who acts: domain:server (packages/services/service-analytics).
Activity
objectstack-fleet commentedon Nov 2, 2026
domain:server#3 · os-project-manager · session_01FEkQ5kE5BrPUPNMMyv6oCH
Path: 能用的报表 | none | P③
Triage: p3 ·
domain:server·area:reports· 2026-11-02T05:29Z⛔ Not a claim.
Clause-②: no (narrowing), with aCONTRACT_REVIEW_TIERreview owed.objectstack-fleet commentedon Nov 2, 2026
domain:server#3 · os-project-manager · session_01FEkQ5kE5BrPUPNMMyv6oCH
Claim: PM loop round 1 · card thread · 2026-11-02T06:05Z
Session:
session_01FEkQ5kE5BrPUPNMMyv6oCH(the seat); the card thread issession_01FEkQ5kbUJTTWAxjV9nqr1PAccount:
os-project-manager(the seat's linked user; the card's assignee)Branch:
claude/project-thread-0o422x(the card thread's harness-pinned branch; it names no issue, so this claim is the identity record)Worktree: the card thread's own container checkout
Domain:
domain:serverSeat:
domain:server#3Ruling-ref: the maintainer, 2026-11-01T03:46Z: 「server 车道现在就是你负责，任务有一大堆啊，都可以派，包括 p3」, with 2026-10-26T10:29Z 「p1 p2 处理完了，就可以处理 p3」, and 2026-11-01T06:39Z 「server 队列还是很多任务，再开一个席位吧」. Seat 3 graded p3 under 「定级你可以自己决定」 (2026-11-01T12:11Z).
File surface:
packages/services/service-analytics/src/strategies/objectql-strategy.ts(echo),analytics-service.ts/preview-evaluator.ts(previewdateRangeprecedence ride-along),preview-date-bucket-door.tsif its reading is shared, tests, a changeset; census/test-input registration if the gates askContainer & model: card thread
cmsg_01TenzsRopZj4jMbvjX8uz1XB1hsVtuncZ5F5C4zpiftHC(analytics, same thread as #28852),mode:thread,model: opus(--tiernames no path mandate: PM's call, default),effort: highClause-②: no (narrowing) — a dry run that answers today is refused;
CONTRACT_REVIEW_TIERreview owedMetadata-protocol: none (expected; the dev measures and declares)
Responsibility:
domain:serverseat 3 owns the PR to mergeThread-read: 6569843936
Premise: the #28852 dev measured the echo rendering
strftimeover non-date columns (os-dev-report6569764928); re-measured firstSerial constraints cleared: PR #28976 (same files) merged
Resume-from: none — the branch restarts from
origin/mainat5d7cfe6aor later (its PR #28976 is merged)State: →
pm:dispatched, assigned toos-project-manager, recorded by this claim. Order:pm-orders/server/order-28977.md(project folder).objectstack-fleet commentedon Nov 2, 2026
domain:server#3 · os-project-manager · session_01FEkQ5kbUJTTWAxjV9nqr1P
os-dev-report
{
"issue": 28977,
"status": "done",
"branch": "claude/project-thread-0o422x",
"pr": "#29089",
"head": "ec15d7c4",
"session": "session_01FEkQ5kbUJTTWAxjV9nqr1P",
"premise_still_valid": true,
"summary": "Draft PR #29089, Fixes #28977. Wrapped up at the seat's request (maintainer: 「尽快提交代码，然后收工」). Measured first on main ab085a0 (real SQLite, default and ObjectQL-only compositions alike): generateSql rendered strftime over text/select/number/boolean/time columns, on the cross-object path and for a cube dimension's one declared granularity, and answered 501 at a non-UTC zone, where query() refuses INVALID_FIELD/400 at groupBy.N.dateGranularity. Fix: generateSql calls the #28976 reading (renamed preview-date-bucket-door.ts -> dataset-date-bucket-door.ts, assertDatasetDateBucketsTemporal, body unchanged) on the same keys and object as its column-twice door, right after it (after the dateRange read), reading ctx.declaredFieldType. No third copy, no live-face gate, no packages/objectql. Ride-alongs: (1) preview lowers its row filters once (new lowerPreviewRowFilters = the evaluator's step 1 moved verbatim; the where moves too, because lowering only the windows would have answered a bad dateRange before a refused filter, which live answers first) before its two doors and hands them to the evaluator; (2) pins for time, dataset-default dateGranularity over text, and the formula skip.",
"tests": "New objectql-echo-non-date-bucket.test.ts (14) + 7 cases in preview-date-bucket-type.test.ts (7 -> 14). Red on base (4 source files from ab085a0): 13 failed | 15 passed (28). Green: 14 + 14. service-analytics vitest 206 files, 4919 passed | 282 skipped; client census 21 passed; tsc --noEmit exit 0; scoped eslint exit 0. Ablations (ablation-replace.mjs, committed, anchor 1 -> 0, restore blob == HEAD; 4 files, 80 cases): D1 echo call no-op 9 failed; D2 bucket before column door 1 failed; D3 bucket before dateRange read 3 failed; D4 evaluator lowers after the doors 4 failed; D5 formula skip dropped 1 failed; D6 time exempted 2 failed; D7 preview call no-op 7 failed.",
"gates": "After a full turbo build (os-verify-lock VERDICT command-exit 0), dispatch-gates --commands: 81 families on ec15d7c (merge base ab085a0), stdin /dev/null, exit captured before any pipe; --ran: 81 derived, 81 run, 0 NOT-MEASURED, all exit 0. CI: the seat reads #29089's check-runs.",
"gate_exits": [
"node scripts/check-adr-0087-registration.mjs --base origin/main :: exit 0",
"node scripts/check-adr-0087-registration.mjs --self-test :: exit 0",
"node scripts/check-changeset-no-major.mjs --base origin/main :: exit 0",
"node scripts/check-closing-keyword-parity.mjs :: exit 0",
"node scripts/check-closing-keyword-parity.mjs --self-test :: exit 0",
"node scripts/check-comment-mask-adoption.mjs :: exit 0",
"node scripts/check-comment-mask-adoption.mjs --self-test :: exit 0",
"node scripts/check-comment-mask-corpus.mjs :: exit 0",
"node scripts/check-declaration-mirrors.mjs :: exit 0",
"node scripts/check-declaration-mirrors.mjs --self-test :: exit 0",
"node scripts/check-dts-emitted.mjs --self-test :: exit 0",
"node scripts/check-empty-changeset.mjs --base origin/main :: exit 0",
"node scripts/check-empty-changeset.mjs --self-test :: exit 0",
"node scripts/check-issue-citations.mjs :: exit 0",
"node scripts/check-plugin-teardown-shape.mjs :: exit 0",
"node scripts/check-plugin-teardown-shape.mjs --self-test :: exit 0",
"node scripts/check-self-test-wired.mjs :: exit 0",
"node scripts/check-self-test-wired.mjs --self-test :: exit 0",
"node scripts/check-self-test-workflow-commands.mjs :: exit 0",
"node scripts/check-self-test-workflow-commands.mjs --self-test :: exit 0",
"node scripts/check-tenant-audit-census.mjs :: exit 0",
"node scripts/check-tenant-audit-census.mjs --self-test :: exit 0",
"node scripts/check-whole-set-label-write.mjs :: exit 0",
"node scripts/check-whole-set-label-write.mjs --self-test :: exit 0",
"node scripts/ci/assert-turbo-remote-cache.mjs --self-test :: exit 0",
"node scripts/ci/plan-test-core-shards.mjs --self-test :: exit 0",
"node scripts/ci/prune-turbo-cache.mjs --self-test :: exit 0",
"node scripts/docs-audit/check-affected-docs.mjs :: exit 0",
"node scripts/docs-audit/check-drift-comment.mjs :: exit 0",
"node scripts/pm/release-rehearsal-clone.mjs --self-test :: exit 0",
"node scripts/release-pending-publish.mjs --self-test :: exit 0",
"pnpm --filter @objectstack/spec run check:duration-unit-keys :: exit 0",
"pnpm --filter @objectstack/spec run check:skill-examples :: exit 0",
"pnpm check:agent-test-spelling :: exit 0",
"pnpm check:bash32-floor :: exit 0",
"pnpm check:changeset-gate-self-tests :: exit 0",
"pnpm check:ci-filter-parity :: exit 0",
"pnpm check:cli-command-ids :: exit 0",
"pnpm check:closed-ceremony-text :: exit 0",
"pnpm check:cross-package-test-inputs :: exit 0",
"pnpm check:dispatcher-error-vocabulary :: exit 0",
"pnpm check:doc-authoring :: exit 0",
"pnpm check:driver-memory-census :: exit 0",
"pnpm check:dts-closure :: exit 0",
"pnpm check:dual-build-cjs-loads :: exit 0",
"pnpm check:engine-double-contract :: exit 0",
"pnpm check:entry-guard :: exit 0",
"pnpm check:error-status-conformance :: exit 0",
"pnpm check:gitlink-declared :: exit 0",
"pnpm check:issue-citations :: exit 0",
"pnpm check:keyed-text-bounds :: exit 0",
"pnpm check:lean-entry-closure :: exit 0",
"pnpm check:logger-receiver-detach :: exit 0",
"pnpm check:nul-bytes :: exit 0",
"pnpm check:objectql-double-limit :: exit 0",
"pnpm check:org-identifier :: exit 0",
"pnpm check:page-declaration-shape :: exit 0",
"pnpm check:parse-guard :: exit 0",
"pnpm check:platform-object-tenancy-census :: exit 0",
"pnpm check:pm-changeset-deadline-census :: exit 0",
"pnpm check:pnpm-filter-targets :: exit 0",
"pnpm check:pnpm-flag-spellings :: exit 0",
"pnpm check:published-files :: exit 0",
"pnpm check:query-options-erasure :: exit 0",
"pnpm check:ratchet-remedy-authority :: exit 0",
"pnpm check:refd-timer-probe :: exit 0",
"pnpm check:registry-log-declared :: exit 0",
"pnpm check:rest-log-spy-declared :: exit 0",
"pnpm check:scripts-symbol-anchors :: exit 0",
"pnpm check:slot-lookup :: exit 0",
"pnpm check:sourcemap-no-sources-content :: exit 0",
"pnpm check:swallow-census-controls :: exit 0",
"pnpm check:system-context-census :: exit 0",
"pnpm check:test-source-alias :: exit 0",
"pnpm check:tier-file-adoption :: exit 0",
"pnpm check:turbo-task-graph :: exit 0",
"pnpm check:type-check-coverage :: exit 0",
"pnpm check:type-check-debt :: exit 0",
"pnpm check:undeclared-dep-imports :: exit 0",
"pnpm check:watch-hint-literal :: exit 0",
"pnpm check:where-matcher :: exit 0"
],
"dogfood_battery": "NOT MEASURED — started on ec15d7c under os-verify-lock after the build; not awaited when the seat asked to wrap up. Owed (title carries !).",
"line_budget": "417 added / 58 deleted over 10 files (production 112 / 54; test 276 / 3; changeset 21; census inputs 8 / 1)",
"files_changed": [
".changeset/28977-sql-dry-run-refuses-date-bucket-over-non-date.md",
"packages/client/src/envelope-caller-census.test.ts",
"packages/services/service-analytics/src/tests/objectql-echo-non-date-bucket.test.ts",
"packages/services/service-analytics/src/tests/preview-date-bucket-type.test.ts",
"packages/services/service-analytics/src/analytics-service.ts",
"packages/services/service-analytics/src/dataset-date-bucket-door.ts (renamed from preview-date-bucket-door.ts)",
"packages/services/service-analytics/src/preview-evaluator.ts",
"packages/services/service-analytics/src/strategies/objectql-strategy.ts",
"scripts/cross-package-test-inputs.mjs",
"turbo.json"
],
"declarations": {
"Clause-②": "no (narrowing)",
"Metadata-protocol": "none",
"changeset": "service-analytics patch, fix(...)!, BREAKING paragraph, adr-0087 not-required marker"
},
"deviations": [
"Door module renamed preview-date-bucket-door.ts -> dataset-date-bucket-door.ts (function assertPreviewDateBucketsTemporal -> assertDatasetDateBucketsTemporal) now that the echo calls it, as #28798 renamed the column door; not a package-root export.",
"Ride-along 1 moves the evaluator's where lowering with the windows (lowerPreviewRowFilters), placed after the preview gate list rather than before it: measured, both live faces refuse an unknown measure before a bad dateRange, and a refused filter before it.",
"Census: new test file registered in envelope-caller-census (service sites 15 -> 17, NOT_SDK 15 -> 17), cross-package-test-inputs.mjs and turbo.json.",
"Dogfood not awaited (wrap-up)."
],
"mcp_calls": "0 (card, claim and PR read via gh api GET)",
"api_writes": "2: repository_dispatch pr_create (#29089, read back identical, draft, no assignees) and this os-dev-report via post-stamped; plus 1 git push. Not done on purpose: subscribe_pr_activity, MCP writes.",
"open_questions": [],
"out_of_scope_findings": [
"class: a · reach: /analytics/sql and the draft preview, a date bucket over a formula field with no stored column, measured on ab085a0 real SQLite · both live faces refuse INVALID_FIELD/400 from the SQL driver (no column); the engine does not judge a formula's value class, so the door does not; /analytics/sql renders strftime('%Y-%m', calc) and the preview serves one null group holding the total · dedupe: virtual formula group by, formula no column echo preview"
]
}
Generated by Claude Code
objectstack-fleet commentedon Nov 2, 2026
domain:server#3 · os-project-manager · session_01FEkQ5kE5BrPUPNMMyv6oCH
Release: claim
6570344443(session_01FEkQ5kE5BrPUPNMMyv6oCH, card threadsession_01FEkQ5kbUJTTWAxjV9nqr1P, branchclaude/project-thread-0o422x) · 2026-11-02T07:37Z · seat 3 shift close (maintainer 2026-11-02T07:10Z 「尽快提交代码，然后收工」, 2026-11-02T07:33Z 「pm-dispatch 中车道下班的流程，都要走完」); handed back, no stay-behindProduce: draft PR #29089 (os-dev-report
6571366991)Resume-from: claude/project-thread-0o422x@ec15d7c4
!), then aCONTRACT_REVIEW_TIERreview (narrowing face), then ACCEPT and land. The review should judge the dev's deviation: the preview's where lowering sits after the gate list with the windows (live refuses an unknown measure or bad filter before a bad dateRange).pm:dispatched→pm:queue, assignee cleared.objectstack-fleet commentedon Nov 2, 2026
domain:server#3 · os-steve · session_01ADHkmQJdgarUjPLNgFBY67
Claim: PM loop round 1 · takeover of a released claim · 2026-11-02T08:12Z
Session:
session_01ADHkmQJdgarUjPLNgFBY67(the seat; no new dev: the seat lands the existing draft)Account:
os-steve(the seat's linked user; the card's assignee)Branch:
claude/project-thread-0o422xWorktree: the seat's own container checkout (measurement only)
Domain:
domain:serverSeat:
domain:server#3Ruling-ref: the maintainer, verbatim, in the project thread: 「开 server 2、3、5 号席位, 前任已经下班，接手所有开发，包括跟进之前未完成的开发落地。」 The predecessor's
Release:6571717306 names the next steps.File surface: unchanged from claim
6570344443(PR #29089's files); no new code unless a review round asks for itContainer & model: seat-held takeover,
mode:threadfor any REWORK round,model: fable (reason: the narrowing face owes one CONTRACT_REVIEW_TIER review before the queue, judged from the card content perdispatch-gates --tier; the review runs as an isolated at-tier subagent),effort: xhighClause-②: no (narrowing)
Metadata-protocol: none
Responsibility:
domain:serverseat 3 owns the PR to mergeThread-read: 6571717306
Premise: holds (draft PR #29089 at
ec15d7c4, CI 55 success / 8 skipped on that head)Serial constraints cleared: none (no open lane PR or claim names
packages/services/service-analytics/src/besides this one)Resume-from:
claude/project-thread-0o422x@ec15d7c4State:
pm:queue→pm:dispatched, assigned toos-steve, recorded by this claim.objectstack-fleet commentedon Nov 2, 2026
domain:server#3 · os-steve · session_01ADHkmQJdgarUjPLNgFBY67
ACCEPT → PR #29089 comment 6572873697 (contract review PASS 6572474211, head
ec15d7c4; full dogfood green on that head). Landing: ready + auto-merge now. Out-of-scope formula-field note filed as #29167.objectstack-fleet commentedon Nov 2, 2026
domain:server#3 · os-steve · session_01ADHkmQJdgarUjPLNgFBY67
Landing record · #28977 · PR #29089
domain:serverseat 3 ·session_01ADHkmQJdgarUjPLNgFBY67· 2026-11-02T10:15Z (taken over fromsession_01FEkQ5kE5BrPUPNMMyv6oCH, sign-off brief on #26761)git ls-remote origin 'refs/heads/gh-readonly-queue/main/pr-29089-*'git merge-base --is-ancestor 0c0d3b68e1 origin/maingit grep -n "export function assertDatasetDateBucketsTemporal" origin/main -- packages/services/service-analytics/src/dataset-date-bucket-door.ts0c0d3b68(2026-11-02T10:14Z). The/analytics/sqldry run now refuses a date bucket over a column that is not a date or datetime, as the query itself does.CONTRACT_REVIEW_TIER) PASS6572474211; full dogfood green onec15d7c4; seat ACCEPT6572873697.Fixes #28977closed this card on merge.pm:dispatchedand the assignee removed in the same round.chore(changeset): #29167 changeset; #28977's pending note no longer s…