Details
-
Bug
-
Resolution: Duplicate
-
Critical
-
Cheshire-Cat
-
Untriaged
-
1
-
Unknown
Description
Getting the following error when query collection.
Repro:
- Build 3455
- Load travel-sample
- Create travel-sample-v2
- Run these N1QL statements to create collections and migrate data into the collections
CREATE COLLECTION `travel-sample-v2`._default.route;
CREATE COLLECTION `travel-sample-v2`._default.airline;
CREATE COLLECTION `travel-sample-v2`._default.airport;
UPSERT INTO `travel-sample-v2`._default.airline (KEY k, VALUE val)
SELECT META().id k, t val FROM `travel-sample` t WHERE t.type='airline' ;
UPSERT INTO `travel-sample-v2`._default.airport (KEY k, VALUE val)
SELECT META().id k, t val FROM `travel-sample` t WHERE t.type='airport' ;
UPSERT INTO `travel-sample-v2`._default.route (KEY k, VALUE val)
SELECT META().id k, t val FROM `travel-sample` t WHERE t.type='route' ;
CREATE INDEX `def_airport_name` ON `travel-sample-v2`._default.airport(name);
CREATE INDEX `def_airport_city` ON `travel-sample-v2`._default.airport(`city`);
CREATE INDEX `def_airport_faa` ON `travel-sample-v2`._default.airport(`faa`);
CREATE INDEX `def_route_src_dst_day` ON `travel-sample-v2`._default.route(`sourceairport`,
`destinationairport`,(distinct (array (`v`.`day`) for `v` in `schedule` end)));
CREATE INDEX `def_route_schedule_utc` ON `travel-sample-v2`._default.route(array (`s`.`utc`)
for `s` in `schedule` end);
CREATE INDEX `def_route_sourceairport` ON `travel-sample-v2`._default.route(`sourceairport`);
CREATE INDEX adv_iata ON `default`:`travel-sample-v2`.`_default`.`airline`(`iata`);
SELECT airline.name, airport.airportname, COUNT(1)
FROM airport
INNER JOIN route ON airport.faa = route.sourceairport
INNER JOIN airline ON route.airline = airline.iata
WHERE airport.city = "San Jose"
AND airport.country = "United States"
AND ANY x in route.schedule SATISFIES x.day =0 END
GROUP BY airline.name, airport.airportname
Note that: the query_context was set to `travel-sample-v2`._default in the UI
Attachments
Issue Links
- depends on
-
MB-39804 Query service returns Error performing bulk get operation
- Resolved