Details
Description
1. create bucket beer-sample and default.
2.create primary view indexes on each of the buckets
3.create index on meta().type
4. Issue a query on bucket where meta().type="json" — this always defaults to Primary Scan – causing the tests to fail.
Automated job to run
./testrunner -i /tmp/tuqvm.ini doc-per-day=6,standard_buckets=1,services_init=kv:index:n1ql -t tuqquery.tuq_index.QueriesViewsTests.test_explain_query_meta
cbq> CREATE INDEX my_index_meta ON `beer-sample`(meta(`beer-sample`).type) ;
{
"requestID": "fd90ef05-98b8-4e3f-8ed9-f4023bdf1908",
"signature": null,
"results": [
],
"status": "success",
"metrics":
}
cbq> EXPLAIN SELECT name FROM `beer-sample` WHERE meta(`beer-sample`).type = "json";
{
"requestID": "eb8dd195-a787-4bca-a24a-e4d8b6489f65",
"signature": "json",
"results": [
{
"#operator": "Sequence",
"~children": [
,
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
,
,
{
"#operator": "InitialProject",
"result_terms": [
]
},
]
}
}
]
}
],
"status": "success",
"metrics":
}
whereas
cbq> SELECT name FROM `beer-sample` WHERE meta(`beer-sample`).type = "json";
{
"requestID": "a023abfc-550b-41fd-8744-4ac5b1794d78",
"signature":
,
"results": [
,
,
,
,
cbq> select * from system:indexes;
{
"requestID": "40c9b401-e683-40ab-99fe-495b1509d604",
"signature":
,
"results": [
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
}
],
"status": "success",
"metrics":
}
attaching logs.