Loading...

XML

Word

Printable

Upload the attached lines.json into KV node after creating a "default" bucket

/opt/couchbase/bin/cbimport json -c couchbase://127.0.0.1 -u Administrator -p password -b default -d file://lines.json -f lines -g key::#UUID# -t 4

Create dataset on Analytics shadowing default bucket
Connect link Local
Run the below query on N1QL and Analytics and compare the results. After scale of 5 - 7 based on different aggregate and window function. I am just attaching it for var_pop

// N1QL

select var_pop(decimal_field) from default where char_field='C';

 [ [    {        "$1": 6611564.8395061735    }    ]

select var_pop(decimal_field) from default_shadow where char_field='C';

 [ [   {     "$1": 6611564.839506171   } ]

relates to

MB-28769 Documents with numbers greater than long integer are not ingested by analytics.

MB-21179 [CX] SQL++ parser cannot parse -9223372036854775808

MB-30432 select tan(radians(45)) gives out 0.9999999999999999 instead of 1.

links to

test run

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

There are no open Gerrit changes

Window Function: Decimal precision mismatch after scale 6/7 between N1QL and SQl++