Major Description
https://forums.couchbase.com/t/date-diff-millis-calculate-wrong-result-with-millisecond-option/8666
This was a forum issue. The error is ->
cbq> select DATE_DIFF_MILLIS(1465634581881,1465634581880,'millisecond');
|
{
|
"requestID": "d5cfc31f-b692-4e80-b3e3-35c0e80039cf",
|
"signature": {
|
"$1": "number"
|
},
|
"results": [
|
{
|
"$1": 0
|
}
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "773.224µs",
|
"executionTime": "746.578µs",
|
"resultCount": 1,
|
"resultSize": 31
|
}
|
}
|
Attachments
| For Gerrit Dashboard: MB-20485 | ||||||
|---|---|---|---|---|---|---|
| # | Subject | Branch | Project | Status | CR | V |
| 66681,3 | MB-20485 Fix round off wrong result returned by date_diff_millis() for milliseconds | master | query | Status: MERGED | +2 | +1 |