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

[CX] select compare from default let compare = (coverage_tests.P0 is null) gives different results from n1ql

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • CBAS DP
    • CBAS DP
    • analytics
    • None
    • Untriaged
    • Unknown
    • CX Sprint 27

    Description

      Query issued:
      select coverage_tests.P0 from default_shadow;
      gives empty results along with P0:0
       
      }, {
      			"P0": 0
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
      			"P0": 0
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
      			"P0": 0
      		}, {
       
      		}, {
       
      		}, {
      			"P0": 0
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
      			"P0": 0
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
      			"P0": 0
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
      		}, {
       
       
       
      But:
      select compare from default_shadow let compare = (coverage_tests.P0 is null)
      gives false even for empty result in first query.
       
      	}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		}, {
      			"compare": false
      		} ]
       
       
      But n1ql gives empty result in that case.
       
      Uploading the dataset against which these queries were issued.
      The steps are the same as in other bugs:
          use Default;
          create bucket default with {{"bucket":"default","nodes":"hostname","password":""}} ;
          create shadow dataset  default_shadow on default;
          connect bucket default;
          
          And then use curl command :
          curl -s --data pretty=true  --data-urlencode statement@file.txt http://172.23.107.182:8095/analytics/service
       
      
      

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            ritesh.agarwal Ritesh Agarwal
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty