CREATE PRIMARY INDEX/CREATE INDEX/DROP INDEX DROP PRIMARY INDEX

Be able to create and drop indexes on collections.

Setup: Standard.

Actions:

• Set query context default:myBucket.
• Run query CREATE PRIMARY INDEX ON myScope.myCollection .

Expected Result: Index named "#primary" appears.

Setup: Standard.

Actions:

• Set query context default:.
• Run query CREATE INDEX my_idx_1 ON myBucket.myScope.myCollection(foo, bar) .

Expected Result: Index named "my_idx_1" appears.

Setup: Standard.

Actions:

• Set query context default:garbage.
• Run query CREATE INDEX my_idx_1 ON default:myBucket.myScope.myCollection(foo, bar) .
• Run query DROP INDEX default:myBucket.myScope.myCollection.my_idx_1 .

Expected Result: Index named "my_idx1" appears and disappears.

Setup: Standard.

Actions:

• Set query context default:myBucket.
• Run query CREATE PRIMARY INDEX ON myScope.myCollection .
• Run query DROP PRIMARY INDEX ON myScope.myCollection

Expected Result: Index named "#primary" appears and disappears.