Details
-
Bug
-
Resolution: Not a Bug
-
Major
-
7.2.0
-
Untriaged
-
0
-
Unknown
Description
explain SELECT COUNT(DISTINCT r.destinationairport)
|
FROM airport a JOIN route r ON r.sourceairport = a.faa
|
WHERE a.city = 'San Francisco' AND a.country = 'United States';
|
{
|
"operator": "distribute-result",
|
"expressions": [
|
"$$53"
|
],
|
"operatorId": "1.1",
|
"physical-operator": "DISTRIBUTE_RESULT",
|
"execution-mode": "UNPARTITIONED",
|
"optimizer-estimates": {
|
"cardinality": 2.4, ---> CARDINALITY SHOULD NOT SHOW FRACTIONAL VALUE
|
"op-cost": 0,
|
"total-cost": 18379.44
|
}
|
...
|