← Back to directory

An offline SQLite expression-migration fixture author needs why a column compari...

https://detect.halowerk.com/v1/F-A-NIGHT-OS-SQLITE/sqlite-expression-affinity-comparison-coercion

Overview

An offline SQLite expression-migration fixture author needs why a column comparison changes after unary plus or IN-list normalization, including exact64bit numeric comparison and COLLATE precedence, without querying a database.

Protocol x402 (POST)
Price $0.0030
Payment Asset USD Coin
Payment Network eip155:8453
Category uncategorized
Provider detect
Source bazaar
Indexed 2026-11-02 17:26:23

Health

Status unknown
Latency (p50) —
Uptime (30d) —
Reliability Score —
Last Checked Never
Last Healthy Never
Consecutive Failures 0

x402 Payment Validation

Payment Requirements —
Asset Verified —
Facilitator —

Input Schema

{ "body": { "artifact": { "sqlite_affinity": { "claim": 1, "comparisons": [ { "in_rhs": false, "left": { "affinity": 2, "column": true, "column_collation": 1, "explicit_collation": 0, "kind": 3, "unary_plus": false, "value": "500" }, "operator": 0, "right": { "affinity": 0, "column": false, "column_collation": 1, "explicit_collation": 0, "kind": 1, "unary_plus": false, "value": "500" } }, { "in_rhs": false, "left": { "affinity": 2, "column": true, "column_collation": 1, "explicit_collation": 0, "kind": 3, "unary_plus": true, "value": "500" }, "operator": 0, "right": { "affinity": 0, "column": false, "column_collation": 1, "explicit_collation": 0, "kind": 1, "unary_plus": false, "value": "500" } } ] } } }, "bodyType": "json", "method": "POST", "type": "http" }

Output Schema

{ "example": { "billable": true, "findings": [ { "confidence": 100, "evidence": [], "limits": [ "Only the explicitly supplied bounded anonymous operand model and exact integer claim are evaluated.", "No external resource or native system is queried or changed; source contents and contact values are not returned.", "This is a declared-model correspondence finding without a security, legal, operational or compliance verdict." ], "module": "sqlite-expression-affinity-comparison-coercion", "state": "not_observed", "value": { "affinity_application_codes": [ 3, 0 ], "claim_matches": true, "comparison_result_codes": [ 1, 0 ], "selected_collation_codes": [ 1, 1 ], "sql_null_results": 0, "statistic": 1, "storage_classes_after_affinity": [ [ 3, 3 ], [ 3, 1 ] ], "true_comparisons": 1 }, "warnings": [] } ], "known_count": 1, "scope": { "contact_values_returned": false, "network": false, "supplied_artifact_only": true }, "warnings": [] }, "type": "json" }