Description
Consider the following 2 examples:
Case1
1. CREATE PRIMARY INDEX ON default |
2. INSERT INTO default (KEY, VALUE) VALUES ("doc1",{ "f1" : -822337203685477580 }) |
3. INSERT INTO default (KEY, VALUE) VALUES ("doc2", { "f1" : -822337203685477580 }) |
4. SELECT SUM(f1) FROM default |
{
|
"$1": -1644674407370955300 |
}
|
]
|
The output should be -1644674407370955160.
Case2
1. CREATE PRIMARY INDEX ON default |
2. INSERT INTO default (KEY, VALUE) VALUES ("doc1",{ "f1" : -822337203685477580 }) |
3. INSERT INTO default (KEY, VALUE) VALUES ("doc2",{ "f1" : 10 }) |
4. SELECT SUM(f1) FROM default |
{
|
"$1": -822337203685477600 |
}
|
]
|
The output should be -822337203685477570.
Looks like the result is getting rounded off due to conversion to float64. But as the number/result is within the int64 range, we may not need to convert to float64 in such cases.
Attachments
Issue Links
- relates to
-
MB-24464 Big number support
- Open