Show nothing in Plan for some N1QL

select

CASE WHEN a.bus_id is not missing THEN false ELSE MISSING END AS is_cross_smt,

CASE WHEN a.bus_id is not missing THEN 1 ELSE MISSING END AS smt_type,

a.cmp_id,a.cmp_name,a.cmp_is_active,a.cmp_status,a.bus_id,a.bus_name,a.bus_is_active,a.bus_status,

CASE WHEN a.bus_id is not missing THEN

array_agg({

"cdt_id":a.cdt_id,

"cdt_is_active": a.cdt_is_active,

"cdt_name":a.cdt_name,

"cdt_rev":a.cdt_rev,

"cdt_status":a.cdt_status,

"field_list":a.field_list

})

ELSE MISSING END AS cdtlist

from (SELECT

meta(c).id as cmp_id,g.name as cmp_name,g.is_active as cmp_is_active,g.status as cmp_status,

meta(b).id as bus_id,b.name as bus_name,b.is_active as bus_is_active,b.status as bus_status,

meta(t).id as cdt_id,t.name as cdt_name,

t._sync.rev as cdt_rev,t.status as cdt_status,t.is_active as cdt_is_active,

array_agg({"field_id":field.id,"field_name":field.labelName}) as field_list

FROM dev4yzj t UNNEST t.fields AS field JOIN dev4yzj b on keys t.bus_id

JOIN dev4yzj c ON KEYS b.bus_cmp

JOIN dev4yzj g ON keys ("GST:" || b.bus_cmp)

WHERE g.type == "GST" and b.type = "BUS" AND c.type = "CMP" and t.type == "CDT"

 and t.bus_id == "BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF" and length(meta(t).id) < 42

 group by meta(t).id,meta(c).id,g.name,g.is_active,g.status,meta(b).id,b.name,b.is_active,b.status,t.name,t._sync.rev,t.status,t.is_active) as a group by a.bus_id,a.cmp_id,a.cmp_name,a.cmp_is_active,a.cmp_status,a.bus_id,a.bus_name,a.bus_is_active,a.bus_status

UNION ALL

select

CASE WHEN csc.bus_id is not missing THEN true ELSE MISSING END AS is_cross_smt,

CASE WHEN csc.bus_id is not missing THEN 1 ELSE MISSING END AS smt_type,

csc.cmp_id,csc.cmp_name,csc.cmp_status,csc.cmp_is_active,csc.bus_id,csc.bus_name,csc.bus_status,csc.bus_is_active,

CASE WHEN csc.bus_id is not missing THEN

array_agg({

"cdt_id":csc.cdt_id,

"cdt_name":csc.cdt_name,

"cdt_rev":csc.cdt_rev,

"cdt_status":csc.cdt_status,

"cdt_is_active":csc.cdt_is_active,

"field_id":csc.field_id,

"field_name":csc.field_name

}) ELSE MISSING END as cross_cdtlist

from (

select sac.cmp_id,sac.cmp_name,sac.cmp_status,sac.cmp_is_active,sac.bus_id,sac.bus_name,sac.bus_status,sac.bus_is_active,

sac.cdt_id,cc.name as cdt_name,cc._sync.rev as cdt_verion,cc.status as cdt_status,cc.is_active as cdt_is_active,sac.cdt_rev,sac.field_id,

FIRST field.labelName FOR field IN cc.fields WHEN field.id = sac.field_id END AS field_name

from

(

select

ac.cmp_id as cmp_id,g.name as cmp_name,g.is_active as cmp_is_active,g.status as cmp_status,

ac.bus_id as bus_id,b.name as bus_name,b.is_active as bus_is_active,b.status as bus_status,

ac.ref.obj_id as cdt_id,ac.ref.obj_rev as cdt_rev,ac.ref.ref_id as field_id

from dev4yzj ac JOIN dev4yzj b on keys ac.bus_id

JOIN dev4yzj c ON KEYS b.bus_cmp

JOIN dev4yzj g ON keys ("GST:" || b.bus_cmp)

WHERE g.type == "GST" and b.type = "BUS" AND c.type = "CMP" and ac.type == "ACL" and ac.sematic_type == "1"

and ANY acl IN ac.acl_list SATISFIES acl.bus_id == "BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF" END and length(meta(ac).id) < 42)

as sac join dev4yzj cc on keys sac.cdt_id where cc.type == "CDT" and sac.cdt_rev == cc._sync.rev and length(meta(cc).id) < 42

) csc group by csc.bus_id,csc.cmp_id,csc.cmp_name,csc.cmp_status,csc.cmp_is_active,csc.bus_id,csc.bus_name,csc.bus_status,csc.bus_is_active

{

 "explain": {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Authorize",

 "#time": "711.029µs",

 "child": {

 "#operator": "UnionAll",

 "children": [

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "IntersectScan",

 "scans": [

 {

 "#operator": "IndexScan",

 "index": "idx_busid_name_fields_rev_dev4yzj_cdt_n01",

 "index_id": "d5b896fe0ae39222",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "spans": [

 {

 "Exact": true,

 "Range": {

 "High": [

 "successor(\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\")"

 ],

 "Inclusion": 1,

 "Low": [

 "\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\""

 ]

 }

 }

 ],

 "using": "gsi"

 },

 {

 "#operator": "IndexScan",

 "index": "idx_type_lenmetaid_busid_cdtid_dev4yzj_doc_n01",

 "index_id": "63bfc7914d9011b9",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "spans": [

 {

 "Range": {

 "High": [

 "\"CDT\"",

 "42",

 "successor(\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\")"

 ],

 "Inclusion": 0,

 "Low": [

 "\"CDT\"",

 "null",

 "\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\""

 ]

 }

 }

 ],

 "using": "gsi"

 }

 ]

 },

 {

 "#operator": "Fetch",

 "as": "t",

 "keyspace": "dev4yzj",

 "namespace": "default"

 },

 {

 "#operator": "Parallel",

 "~child": {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Unnest",

 "as": "field",

 "expr": "(`t`.`fields`)"

 }

 ]

 }

 },

 {

 "#operator": "Join",

 "as": "b",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "on_keys": "(`t`.`bus_id`)"

 },

 {

 "#operator": "Join",

 "as": "c",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "on_keys": "(`b`.`bus_cmp`)"

 },

 {

 "#operator": "Join",

 "as": "g",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "on_keys": "(\"GST:\" || (`b`.`bus_cmp`))"

 },

 {

 "#operator": "Parallel",

 "~child": {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Filter",

 "condition": "(((((((`g`.`type`) = \"GST\") and ((`b`.`type`) = \"BUS\")) and ((`c`.`type`) = \"CMP\")) and ((`t`.`type`) = \"CDT\")) and ((`t`.`bus_id`) = \"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\")) and (length((meta(`t`).`id`)) < 42))"

 },

 {

 "#operator": "InitialGroup",

 "aggregates": [

 "array_agg({\"field_id\": (`field`.`id`), \"field_name\": (`field`.`labelName`)})"

 ],

 "group_keys": [

 "(meta(`t`).`id`)",

 "(meta(`c`).`id`)",

 "(`g`.`name`)",

 "(`g`.`is_active`)",

 "(`g`.`status`)",

 "(meta(`b`).`id`)",

 "(`b`.`name`)",

 "(`b`.`is_active`)",

 "(`b`.`status`)",

 "(`t`.`name`)",

 "((`t`.`_sync`).`rev`)",

 "(`t`.`status`)",

 "(`t`.`is_active`)"

 ]

 }

 ]

 }

 },

 {

 "#operator": "IntermediateGroup",

 "aggregates": [

 "array_agg({\"field_id\": (`field`.`id`), \"field_name\": (`field`.`labelName`)})"

 ],

 "group_keys": [

 "(meta(`t`).`id`)",

 "(meta(`c`).`id`)",

 "(`g`.`name`)",

 "(`g`.`is_active`)",

 "(`g`.`status`)",

 "(meta(`b`).`id`)",

 "(`b`.`name`)",

 "(`b`.`is_active`)",

 "(`b`.`status`)",

 "(`t`.`name`)",

 "((`t`.`_sync`).`rev`)",

 "(`t`.`status`)",

 "(`t`.`is_active`)"

 ]

 },

 {

 "#operator": "FinalGroup",

 "aggregates": [

 "array_agg({\"field_id\": (`field`.`id`), \"field_name\": (`field`.`labelName`)})"

 ],

 "group_keys": [

 "(meta(`t`).`id`)",

 "(meta(`c`).`id`)",

 "(`g`.`name`)",

 "(`g`.`is_active`)",

 "(`g`.`status`)",

 "(meta(`b`).`id`)",

 "(`b`.`name`)",

 "(`b`.`is_active`)",

 "(`b`.`status`)",

 "(`t`.`name`)",

 "((`t`.`_sync`).`rev`)",

 "(`t`.`status`)",

 "(`t`.`is_active`)"

 ]

 },

 {

 "#operator": "Parallel",

 "~child": {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "InitialProject",

 "result_terms": [

 {

 "as": "cmp_id",

 "expr": "(meta(`c`).`id`)"

 },

 {

 "as": "cmp_name",

 "expr": "(`g`.`name`)"

 },

 {

 "as": "cmp_is_active",

 "expr": "(`g`.`is_active`)"

 },

 {

 "as": "cmp_status",

 "expr": "(`g`.`status`)"

 },

 {

 "as": "bus_id",

 "expr": "(meta(`b`).`id`)"

 },

 {

 "as": "bus_name",

 "expr": "(`b`.`name`)"

 },

 {

 "as": "bus_is_active",

 "expr": "(`b`.`is_active`)"

 },

 {

 "as": "bus_status",

 "expr": "(`b`.`status`)"

 },

 {

 "as": "cdt_id",

 "expr": "(meta(`t`).`id`)"

 },

 {

 "as": "cdt_name",

 "expr": "(`t`.`name`)"

 },

 {

 "as": "cdt_rev",

 "expr": "((`t`.`_sync`).`rev`)"

 },

 {

 "as": "cdt_status",

 "expr": "(`t`.`status`)"

 },

 {

 "as": "cdt_is_active",

 "expr": "(`t`.`is_active`)"

 },

 {

 "as": "field_list",

 "expr": "array_agg({\"field_id\": (`field`.`id`), \"field_name\": (`field`.`labelName`)})"

 }

 ]

 },

 {

 "#operator": "FinalProject"

 }

 ]

 }

 }

 ]

 },

 {

 "#operator": "Alias",

 "as": "a"

 },

 {

 "#operator": "Parallel",

 "~child": {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "InitialGroup",

 "aggregates": [

 "array_agg({\"cdt_id\": (`a`.`cdt_id`), \"cdt_is_active\": (`a`.`cdt_is_active`), \"cdt_name\": (`a`.`cdt_name`), \"cdt_rev\": (`a`.`cdt_rev`), \"cdt_status\": (`a`.`cdt_status`), \"field_list\": (`a`.`field_list`)})"

 ],

 "group_keys": [

 "(`a`.`bus_id`)",

 "(`a`.`cmp_id`)",

 "(`a`.`cmp_name`)",

 "(`a`.`cmp_is_active`)",

 "(`a`.`cmp_status`)",

 "(`a`.`bus_id`)",

 "(`a`.`bus_name`)",

 "(`a`.`bus_is_active`)",

 "(`a`.`bus_status`)"

 ]

 }

 ]

 }

 },

 {

 "#operator": "IntermediateGroup",

 "aggregates": [

 "array_agg({\"cdt_id\": (`a`.`cdt_id`), \"cdt_is_active\": (`a`.`cdt_is_active`), \"cdt_name\": (`a`.`cdt_name`), \"cdt_rev\": (`a`.`cdt_rev`), \"cdt_status\": (`a`.`cdt_status`), \"field_list\": (`a`.`field_list`)})"

 ],

 "group_keys": [

 "(`a`.`bus_id`)",

 "(`a`.`cmp_id`)",

 "(`a`.`cmp_name`)",

 "(`a`.`cmp_is_active`)",

 "(`a`.`cmp_status`)",

 "(`a`.`bus_id`)",

 "(`a`.`bus_name`)",

 "(`a`.`bus_is_active`)",

 "(`a`.`bus_status`)"

 ]

 },

 {

 "#operator": "FinalGroup",

 "aggregates": [

 "array_agg({\"cdt_id\": (`a`.`cdt_id`), \"cdt_is_active\": (`a`.`cdt_is_active`), \"cdt_name\": (`a`.`cdt_name`), \"cdt_rev\": (`a`.`cdt_rev`), \"cdt_status\": (`a`.`cdt_status`), \"field_list\": (`a`.`field_list`)})"

 ],

 "group_keys": [

 "(`a`.`bus_id`)",

 "(`a`.`cmp_id`)",

 "(`a`.`cmp_name`)",

 "(`a`.`cmp_is_active`)",

 "(`a`.`cmp_status`)",

 "(`a`.`bus_id`)",

 "(`a`.`bus_name`)",

 "(`a`.`bus_is_active`)",

 "(`a`.`bus_status`)"

 ]

 },

 {

 "#operator": "Parallel",

 "~child": {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "InitialProject",

 "result_terms": [

 {

 "as": "is_cross_smt",

 "expr": "case when ((`a`.`bus_id`) is not missing) then false else null end"

 },

 {

 "as": "smt_type",

 "expr": "case when ((`a`.`bus_id`) is not missing) then 1 else null end"

 },

 {

 "expr": "(`a`.`cmp_id`)"

 },

 {

 "expr": "(`a`.`cmp_name`)"

 },

 {

 "expr": "(`a`.`cmp_is_active`)"

 },

 {

 "expr": "(`a`.`cmp_status`)"

 },

 {

 "expr": "(`a`.`bus_id`)"

 },

 {

 "expr": "(`a`.`bus_name`)"

 },

 {

 "expr": "(`a`.`bus_is_active`)"

 },

 {

 "expr": "(`a`.`bus_status`)"

 },

 {

 "as": "cdtlist",

 "expr": "case when ((`a`.`bus_id`) is not missing) then array_agg({\"cdt_id\": (`a`.`cdt_id`), \"cdt_is_active\": (`a`.`cdt_is_active`), \"cdt_name\": (`a`.`cdt_name`), \"cdt_rev\": (`a`.`cdt_rev`), \"cdt_status\": (`a`.`cdt_status`), \"field_list\": (`a`.`field_list`)}) else null end"

 }

 ]

 },

 {

 "#operator": "FinalProject"

 }

 ]

 }

 }

 ]

 },

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "DistinctScan",

 "scan": {

 "#operator": "IndexScan",

 "covers": [

 "cover ((distinct (array (`acl`.`bus_id`) for `acl` in (`ac`.`acl_list`) end)))",

 "cover (((`ac`.`ref`).`obj_id`))",

 "cover (((`ac`.`ref`).`ref_id`))",

 "cover (((`ac`.`ref`).`obj_rev`))",

 "cover ((`ac`.`bus_id`))",

 "cover ((`ac`.`cmp_id`))",

 "cover ((meta(`ac`).`id`))"

 ],

 "filter_covers": {

 "cover ((`ac`.`sematic_type`))": "1",

 "cover ((`ac`.`type`))": "ACL",

 "cover ((length((meta(`ac`).`id`)) < 45))": true,

 "cover (any `acl` in (`ac`.`acl_list`) satisfies ((`acl`.`bus_id`) = \"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\") end)": true

 },

 "index": "idx_busidinacl_refobjid_refrefid_refobjrev_busid_cmpid_dev4yzj_acl_n01",

 "index_id": "d14714f525ade87e",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "spans": [

 {

 "Exact": true,

 "Range": {

 "High": [

 "successor(\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\")"

 ],

 "Inclusion": 1,

 "Low": [

 "\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\""

 ]

 }

 }

 ],

 "using": "gsi"

 }

 },

 {

 "#operator": "Join",

 "as": "b",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "on_keys": "cover ((`ac`.`bus_id`))"

 },

 {

 "#operator": "Join",

 "as": "c",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "on_keys": "(`b`.`bus_cmp`)"

 },

 {

 "#operator": "Join",

 "as": "g",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "on_keys": "(\"GST:\" || (`b`.`bus_cmp`))"

 },

 {

 "#operator": "Parallel",

 "~child": {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Filter",

 "condition": "((((((((`g`.`type`) = \"GST\") and ((`b`.`type`) = \"BUS\")) and ((`c`.`type`) = \"CMP\")) and (cover ((`ac`.`type`)) = \"ACL\")) and (cover ((`ac`.`sematic_type`)) = \"1\")) and cover (any `acl` in (`ac`.`acl_list`) satisfies ((`acl`.`bus_id`) = \"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\") end)) and (length(cover ((meta(`ac`).`id`))) < 42))"

 },

 {

 "#operator": "InitialProject",

 "result_terms": [

 {

 "as": "cmp_id",

 "expr": "cover ((`ac`.`cmp_id`))"

 },

 {

 "as": "cmp_name",

 "expr": "(`g`.`name`)"

 },

 {

 "as": "cmp_is_active",

 "expr": "(`g`.`is_active`)"

 },

 {

 "as": "cmp_status",

 "expr": "(`g`.`status`)"

 },

 {

 "as": "bus_id",

 "expr": "cover ((`ac`.`bus_id`))"

 },

 {

 "as": "bus_name",

 "expr": "(`b`.`name`)"

 },

 {

 "as": "bus_is_active",

 "expr": "(`b`.`is_active`)"

 },

 {

 "as": "bus_status",

 "expr": "(`b`.`status`)"

 },

 {

 "as": "cdt_id",

 "expr": "cover (((`ac`.`ref`).`obj_id`))"

 },

 {

 "as": "cdt_rev",

 "expr": "cover (((`ac`.`ref`).`obj_rev`))"

 },

 {

 "as": "field_id",

 "expr": "cover (((`ac`.`ref`).`ref_id`))"

 }

 ]

 },

 {

 "#operator": "FinalProject"

 }

 ]

 }

 }

 ]

 },

 {

 "#operator": "Alias",

 "as": "sac"

 },

 {

 "#operator": "Join",

 "as": "cc",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "on_keys": "(`sac`.`cdt_id`)"

 },

 {

 "#operator": "Parallel",

 "~child": {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Filter",

 "condition": "((((`cc`.`type`) = \"CDT\") and ((`sac`.`cdt_rev`) = ((`cc`.`_sync`).`rev`))) and (length((meta(`cc`).`id`)) < 42))"

 },

 {

 "#operator": "InitialProject",

 "result_terms": [

 {

 "expr": "(`sac`.`cmp_id`)"

 },

 {

 "expr": "(`sac`.`cmp_name`)"

 },

 {

 "expr": "(`sac`.`cmp_status`)"

 },

 {

 "expr": "(`sac`.`cmp_is_active`)"

 },

 {

 "expr": "(`sac`.`bus_id`)"

 },

 {

 "expr": "(`sac`.`bus_name`)"

 },

 {

 "expr": "(`sac`.`bus_status`)"

 },

 {

 "expr": "(`sac`.`bus_is_active`)"

 },

 {

 "expr": "(`sac`.`cdt_id`)"

 },

 {

 "as": "cdt_name",

 "expr": "(`cc`.`name`)"

 },

 {

 "as": "cdt_verion",

 "expr": "((`cc`.`_sync`).`rev`)"

 },

 {

 "as": "cdt_status",

 "expr": "(`cc`.`status`)"

 },

 {

 "as": "cdt_is_active",

 "expr": "(`cc`.`is_active`)"

 },

 {

 "expr": "(`sac`.`cdt_rev`)"

 },

 {

 "expr": "(`sac`.`field_id`)"

 },

 {

 "as": "field_name",

 "expr": "first (`field`.`labelName`) for `field` in (`cc`.`fields`) when ((`field`.`id`) = (`sac`.`field_id`)) end"

 }

 ]

 },

 {

 "#operator": "FinalProject"

 }

 ]

 }

 }

 ]

 },

 {

 "#operator": "Alias",

 "as": "csc"

 },

 {

 "#operator": "Parallel",

 "~child": {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "InitialGroup",

 "aggregates": [

 "array_agg({\"cdt_id\": (`csc`.`cdt_id`), \"cdt_is_active\": (`csc`.`cdt_is_active`), \"cdt_name\": (`csc`.`cdt_name`), \"cdt_rev\": (`csc`.`cdt_rev`), \"cdt_status\": (`csc`.`cdt_status`), \"field_id\": (`csc`.`field_id`), \"field_name\": (`csc`.`field_name`)})"

 ],

 "group_keys": [

 "(`csc`.`bus_id`)",

 "(`csc`.`cmp_id`)",

 "(`csc`.`cmp_name`)",

 "(`csc`.`cmp_status`)",

 "(`csc`.`cmp_is_active`)",

 "(`csc`.`bus_id`)",

 "(`csc`.`bus_name`)",

 "(`csc`.`bus_status`)",

 "(`csc`.`bus_is_active`)"

 ]

 }

 ]

 }

 },

 {

 "#operator": "IntermediateGroup",

 "aggregates": [

 "array_agg({\"cdt_id\": (`csc`.`cdt_id`), \"cdt_is_active\": (`csc`.`cdt_is_active`), \"cdt_name\": (`csc`.`cdt_name`), \"cdt_rev\": (`csc`.`cdt_rev`), \"cdt_status\": (`csc`.`cdt_status`), \"field_id\": (`csc`.`field_id`), \"field_name\": (`csc`.`field_name`)})"

 ],

 "group_keys": [

 "(`csc`.`bus_id`)",

 "(`csc`.`cmp_id`)",

 "(`csc`.`cmp_name`)",

 "(`csc`.`cmp_status`)",

 "(`csc`.`cmp_is_active`)",

 "(`csc`.`bus_id`)",

 "(`csc`.`bus_name`)",

 "(`csc`.`bus_status`)",

 "(`csc`.`bus_is_active`)"

 ]

 },

 {

 "#operator": "FinalGroup",

 "aggregates": [

 "array_agg({\"cdt_id\": (`csc`.`cdt_id`), \"cdt_is_active\": (`csc`.`cdt_is_active`), \"cdt_name\": (`csc`.`cdt_name`), \"cdt_rev\": (`csc`.`cdt_rev`), \"cdt_status\": (`csc`.`cdt_status`), \"field_id\": (`csc`.`field_id`), \"field_name\": (`csc`.`field_name`)})"

 ],

 "group_keys": [

 "(`csc`.`bus_id`)",

 "(`csc`.`cmp_id`)",

 "(`csc`.`cmp_name`)",

 "(`csc`.`cmp_status`)",

 "(`csc`.`cmp_is_active`)",

 "(`csc`.`bus_id`)",

 "(`csc`.`bus_name`)",

 "(`csc`.`bus_status`)",

 "(`csc`.`bus_is_active`)"

 ]

 },

 {

 "#operator": "Parallel",

 "~child": {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "InitialProject",

 "result_terms": [

 {

 "as": "is_cross_smt",

 "expr": "case when ((`csc`.`bus_id`) is not missing) then true else null end"

 },

 {

 "as": "smt_type",

 "expr": "case when ((`csc`.`bus_id`) is not missing) then 1 else null end"

 },

 {

 "expr": "(`csc`.`cmp_id`)"

 },

 {

 "expr": "(`csc`.`cmp_name`)"

 },

 {

 "expr": "(`csc`.`cmp_status`)"

 },

 {

 "expr": "(`csc`.`cmp_is_active`)"

 },

 {

 "expr": "(`csc`.`bus_id`)"

 },

 {

 "expr": "(`csc`.`bus_name`)"

 },

 {

 "expr": "(`csc`.`bus_status`)"

 },

 {

 "expr": "(`csc`.`bus_is_active`)"

 },

 {

 "as": "cross_cdtlist",

 "expr": "case when ((`csc`.`bus_id`) is not missing) then array_agg({\"cdt_id\": (`csc`.`cdt_id`), \"cdt_is_active\": (`csc`.`cdt_is_active`), \"cdt_name\": (`csc`.`cdt_name`), \"cdt_rev\": (`csc`.`cdt_rev`), \"cdt_status\": (`csc`.`cdt_status`), \"field_id\": (`csc`.`field_id`), \"field_name\": (`csc`.`field_name`)}) else null end"

 }

 ]

 },

 {

 "#operator": "FinalProject"

 }

 ]

 }

 }

 ]

 }

 ],

 "~children": [

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "IntersectScan",

 "scans": [

 {

 "#operator": "IndexScan",

 "index": "idx_busid_name_fields_rev_dev4yzj_cdt_n01",

 "index_id": "d5b896fe0ae39222",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "spans": [

 {

 "Exact": true,

 "Range": {

 "High": [

 "successor(\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\")"

 ],

 "Inclusion": 1,

 "Low": [

 "\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\""

 ]

 }

 }

 ],

 "using": "gsi",

 "~children": [

 {

 "#operator": "IndexScan",

 "#time": "677.191µs",

 "index": "idx_busid_name_fields_rev_dev4yzj_cdt_n01",

 "index_id": "d5b896fe0ae39222",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "spans": [

 {

 "Exact": true,

 "Range": {

 "High": [

 "successor(\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\")"

 ],

 "Inclusion": 1,

 "Low": [

 "\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\""

 ]

 }

 }

 ],

 "using": "gsi"

 }

 ]

 },

 {

 "#operator": "IndexScan",

 "index": "idx_type_lenmetaid_busid_cdtid_dev4yzj_doc_n01",

 "index_id": "63bfc7914d9011b9",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "spans": [

 {

 "Range": {

 "High": [

 "\"CDT\"",

 "42",

 "successor(\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\")"

 ],

 "Inclusion": 0,

 "Low": [

 "\"CDT\"",

 "null",

 "\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\""

 ]

 }

 }

 ],

 "using": "gsi",

 "~children": [

 {

 "#operator": "IndexScan",

 "#time": "608.051µs",

 "index": "idx_type_lenmetaid_busid_cdtid_dev4yzj_doc_n01",

 "index_id": "63bfc7914d9011b9",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "spans": [

 {

 "Range": {

 "High": [

 "\"CDT\"",

 "42",

 "successor(\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\")"

 ],

 "Inclusion": 0,

 "Low": [

 "\"CDT\"",

 "null",

 "\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\""

 ]

 }

 }

 ],

 "using": "gsi"

 }

 ]

 }

 ]

 },

 {

 "#operator": "Fetch",

 "#time": "295.887µs",

 "as": "t",

 "keyspace": "dev4yzj",

 "namespace": "default"

 },

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Unnest",

 "as": "field",

 "expr": "(`t`.`fields`)"

 }

 ]

 },

 {

 "#operator": "Join",

 "#time": "-1.100495ms",

 "as": "b",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "on_keys": "(`t`.`bus_id`)"

 },

 {

 "#operator": "Join",

 "#time": "-1.350359ms",

 "as": "c",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "on_keys": "(`b`.`bus_cmp`)"

 },

 {

 "#operator": "Join",

 "#time": "-1.730786ms",

 "as": "g",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "on_keys": "(\"GST:\" || (`b`.`bus_cmp`))"

 },

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Filter",

 "condition": "(((((((`g`.`type`) = \"GST\") and ((`b`.`type`) = \"BUS\")) and ((`c`.`type`) = \"CMP\")) and ((`t`.`type`) = \"CDT\")) and ((`t`.`bus_id`) = \"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\")) and (length((meta(`t`).`id`)) < 42))"

 },

 {

 "#operator": "InitialGroup",

 "aggregates": [

 "array_agg({\"field_id\": (`field`.`id`), \"field_name\": (`field`.`labelName`)})"

 ],

 "group_keys": [

 "(meta(`t`).`id`)",

 "(meta(`c`).`id`)",

 "(`g`.`name`)",

 "(`g`.`is_active`)",

 "(`g`.`status`)",

 "(meta(`b`).`id`)",

 "(`b`.`name`)",

 "(`b`.`is_active`)",

 "(`b`.`status`)",

 "(`t`.`name`)",

 "((`t`.`_sync`).`rev`)",

 "(`t`.`status`)",

 "(`t`.`is_active`)"

 ]

 }

 ]

 },

 {

 "#operator": "IntermediateGroup",

 "aggregates": [

 "array_agg({\"field_id\": (`field`.`id`), \"field_name\": (`field`.`labelName`)})"

 ],

 "group_keys": [

 "(meta(`t`).`id`)",

 "(meta(`c`).`id`)",

 "(`g`.`name`)",

 "(`g`.`is_active`)",

 "(`g`.`status`)",

 "(meta(`b`).`id`)",

 "(`b`.`name`)",

 "(`b`.`is_active`)",

 "(`b`.`status`)",

 "(`t`.`name`)",

 "((`t`.`_sync`).`rev`)",

 "(`t`.`status`)",

 "(`t`.`is_active`)"

 ]

 },

 {

 "#operator": "FinalGroup",

 "aggregates": [

 "array_agg({\"field_id\": (`field`.`id`), \"field_name\": (`field`.`labelName`)})"

 ],

 "group_keys": [

 "(meta(`t`).`id`)",

 "(meta(`c`).`id`)",

 "(`g`.`name`)",

 "(`g`.`is_active`)",

 "(`g`.`status`)",

 "(meta(`b`).`id`)",

 "(`b`.`name`)",

 "(`b`.`is_active`)",

 "(`b`.`status`)",

 "(`t`.`name`)",

 "((`t`.`_sync`).`rev`)",

 "(`t`.`status`)",

 "(`t`.`is_active`)"

 ]

 },

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "InitialProject",

 "result_terms": [

 {

 "as": "cmp_id",

 "expr": "(meta(`c`).`id`)"

 },

 {

 "as": "cmp_name",

 "expr": "(`g`.`name`)"

 },

 {

 "as": "cmp_is_active",

 "expr": "(`g`.`is_active`)"

 },

 {

 "as": "cmp_status",

 "expr": "(`g`.`status`)"

 },

 {

 "as": "bus_id",

 "expr": "(meta(`b`).`id`)"

 },

 {

 "as": "bus_name",

 "expr": "(`b`.`name`)"

 },

 {

 "as": "bus_is_active",

 "expr": "(`b`.`is_active`)"

 },

 {

 "as": "bus_status",

 "expr": "(`b`.`status`)"

 },

 {

 "as": "cdt_id",

 "expr": "(meta(`t`).`id`)"

 },

 {

 "as": "cdt_name",

 "expr": "(`t`.`name`)"

 },

 {

 "as": "cdt_rev",

 "expr": "((`t`.`_sync`).`rev`)"

 },

 {

 "as": "cdt_status",

 "expr": "(`t`.`status`)"

 },

 {

 "as": "cdt_is_active",

 "expr": "(`t`.`is_active`)"

 },

 {

 "as": "field_list",

 "expr": "array_agg({\"field_id\": (`field`.`id`), \"field_name\": (`field`.`labelName`)})"

 }

 ]

 },

 {

 "#operator": "FinalProject"

 }

 ]

 }

 ]

 },

 {

 "#operator": "Alias",

 "as": "a"

 },

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "InitialGroup",

 "aggregates": [

 "array_agg({\"cdt_id\": (`a`.`cdt_id`), \"cdt_is_active\": (`a`.`cdt_is_active`), \"cdt_name\": (`a`.`cdt_name`), \"cdt_rev\": (`a`.`cdt_rev`), \"cdt_status\": (`a`.`cdt_status`), \"field_list\": (`a`.`field_list`)})"

 ],

 "group_keys": [

 "(`a`.`bus_id`)",

 "(`a`.`cmp_id`)",

 "(`a`.`cmp_name`)",

 "(`a`.`cmp_is_active`)",

 "(`a`.`cmp_status`)",

 "(`a`.`bus_id`)",

 "(`a`.`bus_name`)",

 "(`a`.`bus_is_active`)",

 "(`a`.`bus_status`)"

 ]

 }

 ]

 },

 {

 "#operator": "IntermediateGroup",

 "aggregates": [

 "array_agg({\"cdt_id\": (`a`.`cdt_id`), \"cdt_is_active\": (`a`.`cdt_is_active`), \"cdt_name\": (`a`.`cdt_name`), \"cdt_rev\": (`a`.`cdt_rev`), \"cdt_status\": (`a`.`cdt_status`), \"field_list\": (`a`.`field_list`)})"

 ],

 "group_keys": [

 "(`a`.`bus_id`)",

 "(`a`.`cmp_id`)",

 "(`a`.`cmp_name`)",

 "(`a`.`cmp_is_active`)",

 "(`a`.`cmp_status`)",

 "(`a`.`bus_id`)",

 "(`a`.`bus_name`)",

 "(`a`.`bus_is_active`)",

 "(`a`.`bus_status`)"

 ]

 },

 {

 "#operator": "FinalGroup",

 "aggregates": [

 "array_agg({\"cdt_id\": (`a`.`cdt_id`), \"cdt_is_active\": (`a`.`cdt_is_active`), \"cdt_name\": (`a`.`cdt_name`), \"cdt_rev\": (`a`.`cdt_rev`), \"cdt_status\": (`a`.`cdt_status`), \"field_list\": (`a`.`field_list`)})"

 ],

 "group_keys": [

 "(`a`.`bus_id`)",

 "(`a`.`cmp_id`)",

 "(`a`.`cmp_name`)",

 "(`a`.`cmp_is_active`)",

 "(`a`.`cmp_status`)",

 "(`a`.`bus_id`)",

 "(`a`.`bus_name`)",

 "(`a`.`bus_is_active`)",

 "(`a`.`bus_status`)"

 ]

 },

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "InitialProject",

 "result_terms": [

 {

 "as": "is_cross_smt",

 "expr": "case when ((`a`.`bus_id`) is not missing) then false else null end"

 },

 {

 "as": "smt_type",

 "expr": "case when ((`a`.`bus_id`) is not missing) then 1 else null end"

 },

 {

 "expr": "(`a`.`cmp_id`)"

 },

 {

 "expr": "(`a`.`cmp_name`)"

 },

 {

 "expr": "(`a`.`cmp_is_active`)"

 },

 {

 "expr": "(`a`.`cmp_status`)"

 },

 {

 "expr": "(`a`.`bus_id`)"

 },

 {

 "expr": "(`a`.`bus_name`)"

 },

 {

 "expr": "(`a`.`bus_is_active`)"

 },

 {

 "expr": "(`a`.`bus_status`)"

 },

 {

 "as": "cdtlist",

 "expr": "case when ((`a`.`bus_id`) is not missing) then array_agg({\"cdt_id\": (`a`.`cdt_id`), \"cdt_is_active\": (`a`.`cdt_is_active`), \"cdt_name\": (`a`.`cdt_name`), \"cdt_rev\": (`a`.`cdt_rev`), \"cdt_status\": (`a`.`cdt_status`), \"field_list\": (`a`.`field_list`)}) else null end"

 }

 ]

 },

 {

 "#operator": "FinalProject"

 }

 ]

 }

 ]

 },

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "DistinctScan",

 "scan": {

 "#operator": "IndexScan",

 "covers": [

 "cover ((distinct (array (`acl`.`bus_id`) for `acl` in (`ac`.`acl_list`) end)))",

 "cover (((`ac`.`ref`).`obj_id`))",

 "cover (((`ac`.`ref`).`ref_id`))",

 "cover (((`ac`.`ref`).`obj_rev`))",

 "cover ((`ac`.`bus_id`))",

 "cover ((`ac`.`cmp_id`))",

 "cover ((meta(`ac`).`id`))"

 ],

 "filter_covers": {

 "cover ((`ac`.`sematic_type`))": "1",

 "cover ((`ac`.`type`))": "ACL",

 "cover ((length((meta(`ac`).`id`)) < 45))": true,

 "cover (any `acl` in (`ac`.`acl_list`) satisfies ((`acl`.`bus_id`) = \"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\") end)": true

 },

 "index": "idx_busidinacl_refobjid_refrefid_refobjrev_busid_cmpid_dev4yzj_acl_n01",

 "index_id": "d14714f525ade87e",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "spans": [

 {

 "Exact": true,

 "Range": {

 "High": [

 "successor(\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\")"

 ],

 "Inclusion": 1,

 "Low": [

 "\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\""

 ]

 }

 }

 ],

 "using": "gsi",

 "~children": [

 {

 "#operator": "IndexScan",

 "#time": "403.384µs",

 "covers": [

 "cover ((distinct (array (`acl`.`bus_id`) for `acl` in (`ac`.`acl_list`) end)))",

 "cover (((`ac`.`ref`).`obj_id`))",

 "cover (((`ac`.`ref`).`ref_id`))",

 "cover (((`ac`.`ref`).`obj_rev`))",

 "cover ((`ac`.`bus_id`))",

 "cover ((`ac`.`cmp_id`))",

 "cover ((meta(`ac`).`id`))"

 ],

 "filter_covers": {

 "cover ((`ac`.`sematic_type`))": "1",

 "cover ((`ac`.`type`))": "ACL",

 "cover ((length((meta(`ac`).`id`)) < 45))": true,

 "cover (any `acl` in (`ac`.`acl_list`) satisfies ((`acl`.`bus_id`) = \"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\") end)": true

 },

 "index": "idx_busidinacl_refobjid_refrefid_refobjrev_busid_cmpid_dev4yzj_acl_n01",

 "index_id": "d14714f525ade87e",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "spans": [

 {

 "Exact": true,

 "Range": {

 "High": [

 "successor(\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\")"

 ],

 "Inclusion": 1,

 "Low": [

 "\"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\""

 ]

 }

 }

 ],

 "using": "gsi"

 }

 ]

 }

 },

 {

 "#operator": "Join",

 "#time": "-1.218048ms",

 "as": "b",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "on_keys": "cover ((`ac`.`bus_id`))"

 },

 {

 "#operator": "Join",

 "#time": "-1.230405ms",

 "as": "c",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "on_keys": "(`b`.`bus_cmp`)"

 },

 {

 "#operator": "Join",

 "#time": "-1.246523ms",

 "as": "g",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "on_keys": "(\"GST:\" || (`b`.`bus_cmp`))"

 },

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Filter",

 "condition": "((((((((`g`.`type`) = \"GST\") and ((`b`.`type`) = \"BUS\")) and ((`c`.`type`) = \"CMP\")) and (cover ((`ac`.`type`)) = \"ACL\")) and (cover ((`ac`.`sematic_type`)) = \"1\")) and cover (any `acl` in (`ac`.`acl_list`) satisfies ((`acl`.`bus_id`) = \"BUS:153370DD-BC85-425A-B442-B3C9F0A1D3CF\") end)) and (length(cover ((meta(`ac`).`id`))) < 42))"

 },

 {

 "#operator": "InitialProject",

 "result_terms": [

 {

 "as": "cmp_id",

 "expr": "cover ((`ac`.`cmp_id`))"

 },

 {

 "as": "cmp_name",

 "expr": "(`g`.`name`)"

 },

 {

 "as": "cmp_is_active",

 "expr": "(`g`.`is_active`)"

 },

 {

 "as": "cmp_status",

 "expr": "(`g`.`status`)"

 },

 {

 "as": "bus_id",

 "expr": "cover ((`ac`.`bus_id`))"

 },

 {

 "as": "bus_name",

 "expr": "(`b`.`name`)"

 },

 {

 "as": "bus_is_active",

 "expr": "(`b`.`is_active`)"

 },

 {

 "as": "bus_status",

 "expr": "(`b`.`status`)"

 },

 {

 "as": "cdt_id",

 "expr": "cover (((`ac`.`ref`).`obj_id`))"

 },

 {

 "as": "cdt_rev",

 "expr": "cover (((`ac`.`ref`).`obj_rev`))"

 },

 {

 "as": "field_id",

 "expr": "cover (((`ac`.`ref`).`ref_id`))"

 }

 ]

 },

 {

 "#operator": "FinalProject"

 }

 ]

 }

 ]

 },

 {

 "#operator": "Alias",

 "as": "sac"

 },

 {

 "#operator": "Join",

 "#time": "-1.278064ms",

 "as": "cc",

 "keyspace": "dev4yzj",

 "namespace": "default",

 "on_keys": "(`sac`.`cdt_id`)"

 },

 {

 "#operator": "Sequence",

 "~children": [

 {

 "#operator": "Filter",

 "condition": "((((`cc`.`type`) = \"CDT\") and ((`sac`.`cdt_rev`) = ((`cc`.`_sync`).`rev`))) and (length((meta(`cc`).`id`)) < 42))"

 },

 {

 "#operator": "InitialProject",

 "result_terms": [

 {

 "expr": "(`sac`.`cmp_id`)"

 },

 {

 "expr": "(`sac`.`cmp_name`)"

 },

 {

 "expr": "(`sac`.`cmp_status`)"

 },

 {

 "expr": "(`sac`.`cmp_is_active`)"

 },

 {

 "expr": "(`sac`.`bus_id`)"

 },