Description
Server PR: https://github.com/couchbaselabs/docs-devex/pull/196
Capella PR: https://github.com/couchbaselabs/docs-devex/pull/201
The queries that create the dataset on which example queries are constructed are missing hence, we can't try out the example queries.
In particular, for example 3
add:
INSERT INTO products
|
VALUES (uuid(), {
|
"id": 1, |
"name": "Bicycle", |
"price": 299.99, |
"description": "A sturdy and reliable bicycle.", |
"category": "Sports", |
"related_items": [2, 4] |
}),
|
VALUES (uuid(), {
|
"id": 2, |
"name": "Helmet", |
"price": 49.99, |
"description": "A safety helmet for cycling.", |
"category": "Sports", |
"related_items": [1, 3] |
}),
|
VALUES (uuid(), {
|
"id": 3, |
"name": "Water Bottle", |
"price": 9.99, |
"description": "A convenient water bottle for cycling.", |
"category": "Accessories", |
"related_items": [2, 4] |
}),
|
VALUES (uuid(), {
|
"id": 4, |
"name": "Gloves", |
"price": 19.99, |
"description": "Comfortable gloves for cycling.", |
"category": "Sports", |
"related_items": [1, 3] |
})
|
RETURNING *;
|
|
and the following create index statement:
CREATE INDEX p_idx ON products(id);
|