HALOWERKTechnische Prüfungen & Formate
F TD2000 DATASTRUCTURES 07 / postgresql17 grouping sets rollup cube null aggregate reconstruction
Recover complete nullable aggregate rows and grouping-mask distinctions for an explicit grouping-sets, rollup or cube plan.
POST https://detect.halowerk.com/v1/F-TD2000-DATASTRUCTURES-07/postgresql17-grouping-sets-rollup-cube-null-aggregate-reconstructionEingaben
| Feld | Typ | Pflicht | Beschreibung |
|---|---|---|---|
| artifact | object | Ja |
Vollständiges Eingabeschema anzeigen
{
"type": "object",
"additionalProperties": false,
"required": [
"artifact"
],
"properties": {
"artifact": {
"type": "object",
"additionalProperties": false,
"required": [
"sqlGrouping"
],
"properties": {
"sqlGrouping": {
"type": "object",
"additionalProperties": false,
"required": [
"data",
"claim"
],
"properties": {
"data": {
"type": "object",
"additionalProperties": false,
"required": [
"columns",
"plan",
"rows"
],
"properties": {
"columns": {
"type": "number"
},
"plan": {
"anyOf": [
{
"type": "object",
"additionalProperties": false,
"required": [
"columns",
"kind"
],
"properties": {
"columns": {
"type": "array",
"items": {
"type": "number"
},
"maxItems": 512
},
"kind": {
"type": "string",
"maxLength": 20000
}
}
},
{
"type": "object",
"additionalProperties": false,
"required": [
"kind",
"sets"
],
"properties": {
"kind": {
"type": "string",
"maxLength": 20000
},
"sets": {
"$ref": "#/properties/artifact/%24defs/s1"
}
}
}
]
},
"rows": {
"type": "array",
"items": {
"$ref": "#/properties/artifact/%24defs/s0"
},
"maxItems": 512
}
}
},
"claim": {
"anyOf": [
{
"type": "null"
},
{
"type": "object",
"additionalProperties": false,
"required": [
"grouping_sets",
"groups"
],
"properties": {
"grouping_sets": {
"$ref": "#/properties/artifact/%24defs/s1"
},
"groups": {
"type": "array",
"items": {
"type": "object",
"additionalProperties": false,
"required": [
"averages",
"grouping_mask",
"keys",
"maxima",
"minima",
"non_null_counts",
"row_count",
"set_index",
"sums"
],
"properties": {
"averages": {
"type": "array",
"items": {
"anyOf": [
{
"$ref": "#/properties/artifact/%24defs/json"
},
{
"type": "object",
"additionalProperties": false,
"required": [
"denominator",
"numerator"
],
"properties": {
"denominator": {
"type": "string",
"maxLength": 20000
},
"numerator": {
"type": "string",
"maxLength": 20000
}
}
}
]
},
"maxItems": 512
},
"grouping_mask": {
"type": "number"
},
"keys": {
"$ref": "#/properties/artifact/%24defs/s0"
},
"maxima": {
"$ref": "#/properties/artifact/%24defs/s0"
},
"minima": {
"$ref": "#/properties/artifact/%24defs/s0"
},
"non_null_counts": {
"type": "array",
"items": {
"type": "number"
},
"maxItems": 512
},
"row_count": {
"type": "number"
},
"set_index": {
"type": "number"
},
"sums": {
"$ref": "#/properties/artifact/%24defs/s0"
}
}
},
"maxItems": 512
}
}
}
]
}
}
}
},
"$defs": {
"json": {
"anyOf": [
{
"type": "null"
},
{
"type": "boolean"
},
{
"type": "number"
},
{
"type": "string",
"maxLength": 6000
},
{
"type": "array",
"items": {
"$ref": "#/properties/artifact/%24defs/json"
},
"maxItems": 512
},
{
"type": "object",
"maxProperties": 128,
"additionalProperties": {
"$ref": "#/properties/artifact/%24defs/json"
}
}
]
},
"s0": {
"type": "array",
"items": {
"anyOf": [
{
"$ref": "#/properties/artifact/%24defs/json"
},
{
"type": "number"
}
]
},
"maxItems": 512
},
"s1": {
"type": "array",
"items": {
"type": "array",
"items": {
"type": "number"
},
"maxItems": 512
},
"maxItems": 512
}
}
}
}
}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.