Description
This query:
SELECT * FROM default d RIGHT OUTER JOIN standard_bucket0 s ON (d.name == s.name) limit 10
Never finishes executing
There are two buckets default and standard_bucket0, both have the exact same 12096 docs in them and the indexes present are:
primary(default)
primary(standard)
default(name)
Explain:
{
"plan": {
"#operator": "Sequence",
"~children": [
{
"#operator": "Sequence",
"~children": [
{
"#operator": "PrimaryScan3",
"as": "s",
"index": "#primary",
"index_projection": {
"primary_key": true
},
"keyspace": "standard_bucket0",
"namespace": "default",
"using": "gsi"
},
{
"#operator": "Fetch",
"as": "s",
"keyspace": "standard_bucket0",
"namespace": "default"
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "AnsiJoin",
"alias": "d",
"on_clause": "((`d`.`name`) = (`s`.`name`))",
"outer": true,
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan3",
"ansi_join": true,
"as": "d",
"index": "idx1",
"index_id": "f6fb7495c5f7760b",
"index_projection": {
"primary_key": true
},
"keyspace": "default",
"namespace": "default",
"spans": [
{
"exact": true,
"range": [
{
"high": "(`s`.`name`)",
"inclusion": 3,
"low": "(`s`.`name`)"
}
]
}
],
"using": "gsi"
},
{
"#operator": "Fetch",
"ansi_join": true,
"as": "d",
"keyspace": "default",
"namespace": "default"
}
]
}
},
{
"#operator": "InitialProject",
"result_terms": [
{
"expr": "self",
"star": true
}
]
},
{
"#operator": "FinalProject"
}
]
}
}
]
},
{
"#operator": "Limit",
"expr": "10"
}
]
},
"text": "SELECT * FROM default d RIGHT OUTER JOIN standard_bucket0 s ON (d.name == s.name) LIMIT 10"
}
Attachments
Issue Links
- is duplicated by
-
MB-27834 [ANSI JOIN] array query hangs
-
- Closed
-