Details
-
Bug
-
Resolution: Fixed
-
Major
-
feature-backlog
-
None
-
Untriaged
-
Unknown
Description
Explain is a common n1ql keyword.
I tried using explain before select statement:
explain SELECT DISTINCT primary_key_id FROM simple_shadow WHERE (((decimal_field1 != 4966) OR (int_field1 <= 5146) AND primary_key_id >= "549" AND NOT (bool_field1))) OR ((NOT (bool_field1) OR char_field1 IS NOT NULL)) ;
Result:
"results": [ "distribute result [%0->$$23]\n-- DISTRIBUTE_RESULT |PARTITIONED|\n exchange\n – ONE_TO_ONE_EXCHANGE |PARTITIONED|\n distinct ([%0->$$23])\n – PRE_SORTED_DISTINCT_BY |PARTITIONED|\n exchange\n – ONE_TO_ONE_EXCHANGE |PARTITIONED|\n order (ASC, %0->$$23) \n – STABLE_SORT [$$23(ASC)] |PARTITIONED|\n exchange\n – HASH_PARTITION_EXCHANGE [$$23] |PARTITIONED|\n project ([$$23])\n – STREAM_PROJECT |PARTITIONED|\n assign [$$23] <- [function-call: asterix:open-record-constructor, Args:[AString:
]]\n – ASSIGN |PARTITIONED|\n project ([$$2])\n – STREAM_PROJECT |PARTITIONED|\n exchange\n – ONE_TO_ONE_EXCHANGE |PARTITIONED|\n data-scan []<[$$26, $$2, $$27] < CouchbaseAnalytics:simple_shadow\n – DATASOURCE_SCAN |PARTITIONED|\n exchange\n – ONE_TO_ONE_EXCHANGE |PARTITIONED|\n empty-tuple-source\n – EMPTY_TUPLE_SOURCE |PARTITIONED|\n" ]