Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-42152

Error 12008 when query collection

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • 7.0.0
    • Cheshire-Cat
    • query
    • Untriaged
    • 1
    • Unknown

    Description

      Getting the following error when query collection.

      Repro:

      1. Build 3455
      2. Load travel-sample
      3. Create travel-sample-v2
      4. 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

          Activity

            People

              marco.greco Marco Greco (Inactive)
              binh.le Binh Le
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty