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-coercionOverview
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"
}