Description
Found by Geoffrey Beers
with s as ([{"a":1}, {"a":2}]) |
select s1.a from s AS s1 where s1.a = 1 |
union all
|
select s1.a + 10 from s AS s1 where s1.a = 2; |
{
|
"requestID": "b709cb2b-390e-44b0-8b1d-964904f52d2c", |
"errors": [ |
{
|
"code": 12003, |
"msg": "Keyspace not found in CB datastore: default:s - cause: No bucket named s" |
}
|
],
|
"status": "fatal", |
"metrics": { |
"elapsedTime": "33.12533ms", |
"executionTime": "33.052704ms", |
"resultCount": 0, |
"resultSize": 0, |
"serviceLoad": 2, |
"errorCount": 1 |
}
|
}
|
The following works, but extra over head of CTE
with s as ( [{"a":1}, {"a":2}] ) |
select s1.a from s AS s1 where s1.a = 1 |
union all
|
with s as ( [{"a":1}, {"a":2}] ) |
select s1.a + 10 from s AS s1 where s1.a = 2; |
|