HALOWERKTechnische Prüfungen & Formate
F A NIGHT OS SQLITE / sqlite expression affinity comparison coercion
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.
POST https://detect.halowerk.com/v1/F-A-NIGHT-OS-SQLITE/sqlite-expression-affinity-comparison-coercionEingaben
| Feld | Typ | Pflicht | Beschreibung |
|---|---|---|---|
| artifact | object | Ja |
Vollständiges Eingabeschema anzeigen
{
"type": "object",
"additionalProperties": false,
"required": [
"artifact"
],
"properties": {
"artifact": {
"type": "object",
"additionalProperties": false,
"required": [
"sqlite_affinity"
],
"properties": {
"sqlite_affinity": {
"type": "object",
"additionalProperties": false,
"required": [
"claim",
"comparisons"
],
"properties": {
"claim": {
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
"comparisons": {
"type": "array",
"maxItems": 512,
"items": {
"type": "object",
"additionalProperties": false,
"required": [
"in_rhs",
"left",
"operator",
"right"
],
"properties": {
"in_rhs": {
"type": "boolean"
},
"left": {
"type": "object",
"additionalProperties": false,
"required": [
"affinity",
"column",
"column_collation",
"explicit_collation",
"kind",
"unary_plus",
"value"
],
"properties": {
"affinity": {
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
"column": {
"type": "boolean"
},
"column_collation": {
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
"explicit_collation": {
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
"kind": {
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
"unary_plus": {
"type": "boolean"
},
"value": {
"anyOf": [
{
"type": "array",
"maxItems": 512,
"items": {
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
}
},
{
"type": "null"
},
{
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
{
"type": "string",
"maxLength": 1024
}
]
}
}
},
"operator": {
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
"right": {
"type": "object",
"additionalProperties": false,
"required": [
"affinity",
"column",
"column_collation",
"explicit_collation",
"kind",
"unary_plus",
"value"
],
"properties": {
"affinity": {
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
"column": {
"type": "boolean"
},
"column_collation": {
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
"explicit_collation": {
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
"kind": {
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
"unary_plus": {
"type": "boolean"
},
"value": {
"anyOf": [
{
"type": "array",
"maxItems": 512,
"items": {
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
}
},
{
"type": "null"
},
{
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
{
"type": "string",
"maxLength": 1024
}
]
}
}
}
}
}
}
}
}
}
}
}
}Ergebnis & Dokumentation
Maschinenlesbare Dokumentation dieses Hubs
Quelle dieser Seite: der veröffentlichte HALOWERK-Katalog. Stand: 2026-11-01, 15:19 UTC.
Weitere Endpunkte dieses Hubs
- Technische Prüfungen & Formate0,003 USDC
aria concrete role property support closure
POSThttps://detect.halowerk.com/u/aria-concrete-role-property-support-closureA component API exporter needs properties that are unsupported or prohibited for its selected explicit ARIA role rather than losing them silently during conversion.
- Technische Prüfungen & Formate0,003 USDC
aria description author source precedence
POSThttps://detect.halowerk.com/u/aria-description-author-source-precedenceA description-metadata exporter needs which author ARIA source survives precedence and which competing source is overridden before transferring help text.
- Technische Prüfungen & Formate0,003 USDC
aria explicit concrete role token fallback
POSThttps://detect.halowerk.com/u/aria-explicit-concrete-role-token-fallbackBefore removing compatibility role tokens, a website migration agent needs which concrete source role survives the normative fallback order.