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

If a keyspace alias is a suffix of an unnest alias, Index advice is incorrect

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Unknown

    Description

      ADVISE SELECT COUNT(s.c1) AS num
      		 
      FROM default AS s
      		 
      UNNEST a1 AS us
      		 
      WHERE us.type = "x1";
      		 

       "index_statement": "CREATE INDEX adv_ALL_a1_type_c1 ON `default`(ALL ARRAY `utype` FOR us IN `a1` END,`c1`)"

      It must be us.type

      This happens keyspace alias is postfix of unnest alias  (i.e. matched at the end)

       

      Attachments

        For Gerrit Dashboard: MB-57729
        # Subject Branch Project Status CR V
        193502,2 MB-57729 Do not perform string replacement on the entire array key master query Status: MERGED +2 +1
        193503,2 MB-57729 Do not perform string replacement on the entire array key master query-ee Status: MERGED +2 +1
        193505,2 MB-57729 Do not perform string replacement on the entire array key neo query Status: MERGED +2 +1
        193506,2 MB-57729 Do not perform string replacement on the entire array key neo query-ee Status: MERGED +2 +1
        193507,2 MB-57729 Do not perform string replacement on the entire array key 7.1.x query-ee Status: MERGED +2 +1

        Activity

          People

            pierre.regazzoni Pierre Regazzoni
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty