Details
-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
4.0.0
-
Security Level: Public
-
None
-
Untriaged
-
Centos 64-bit
-
Unknown
Description
Steps to reproduce
Create a one node cluster
Config the beer-sample and default bucket in the wizard
create a primary index using cbq
cbq> [root@localhost bin]# ./cbq
|
Couchbase query shell connected to http://localhost:8093/ . Type Ctrl-D to exit.
|
cbq>CREATE PRIMARY INDEX `beer-sample-primary-index` ON `beer-sample`;
|
Created a second primary index:
cbq> [root@localhost bin]# ./cbq
|
Couchbase query shell connected to http://localhost:8093/ . Type Ctrl-D to exit.
|
cbq>CREATE PRIMARY INDEX ON `beer-sample`;
|
Checked that the indexes exist, however you can see that they have been created as a view and not a GSI:
cbq> SELECT * FROM system:indexes ;
|
{
|
"requestID": "91685187-0292-4a4b-bd90-11825713cd83",
|
"signature": {
|
"*": "*"
|
},
|
"results": [
|
{
|
"indexes": {
|
"datastore_id": "http://127.0.0.1:8091",
|
"id": "beer-sample-primary-index",
|
"index_key": [
|
"(meta(`beer-sample`).`id`)"
|
],
|
"is_primary": true,
|
"keyspace_id": "beer-sample",
|
"name": "beer-sample-primary-index",
|
"namespace_id": "default",
|
"state": "online",
|
"using": "view"
|
}
|
},
|
{
|
"indexes": {
|
"datastore_id": "http://127.0.0.1:8091",
|
"id": "#primary",
|
"index_key": [
|
"(meta(`beer-sample`).`id`)"
|
],
|
"is_primary": true,
|
"keyspace_id": "beer-sample",
|
"name": "#primary",
|
"namespace_id": "default",
|
"state": "online",
|
"using": "view"
|
}
|
}
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "56.670051ms",
|
"executionTime": "56.48581ms",
|
"resultCount": 2,
|
"resultSize": 970
|
}
|
}
|
|
Attachments
Issue Links
- duplicates
-
MB-14598 Work item to make GSI index as the DEFAULT INDEXING method for Couchbase/Sherlock.
- Closed