Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
5.5.0
-
5.5.0-2170
-
Untriaged
-
No
-
CX Sprint 112, CX Sprint 113, CX Sprint 114, CX Sprint 115
Description
Different results between SQL++ and N1QL has been observed and analytics result is looking better wrt incompatible type comparisons.
In N1QL where the comparison hits incompatible type, it seems it is evaluated it to True while in analytics it is evaluated it to False.
Query: SELECT age FROM default where age > 1;
Analytics Output:
[
|
{
|
"age": 70
|
},
|
{
|
"age": 33
|
},
|
{
|
"age": 12345.12345
|
}
|
]
|
N1QL Output:
[
|
{
|
"age": 70
|
},
|
{
|
"age": 33
|
},
|
{
|
"age": [
|
1,
|
2
|
]
|
},
|
{
|
"age": {
|
"key": "value"
|
}
|
},
|
{
|
"age": 12345.12345
|
}
|
]
|
Attachments
Issue Links
- relates to
-
-
- Closed
-
Gerrit Reviews
Activity
| Field | Original Value | New Value |
|---|---|---|
| Attachment | data.json [ 50248 ] |
| Attachment | backup-MB-28701.zip [ 50249 ] |
| Description |
Different results between SQL++ and N1QL has been observed and analytics result is looking better wrt incompatible type comparisons.
In N1QL where the comparison hits incompatible type, it seems it is evaluated it to True while in analytics it is evaluated it to False. Query: SELECT age FROM default where age > 1; Analytics Output: {code} [ { "age": 70 }, { "age": 33 }, { "age": 12345.12345 } ] N1QL Output: [ { "age": 70 }, { "age": 33 }, { "age": [ 1, 2 ] }, { "age": { "key": "value" } }, { "age": 12345.12345 } ] |
Different results between SQL++ and N1QL has been observed and analytics result is looking better wrt incompatible type comparisons.
In N1QL where the comparison hits incompatible type, it seems it is evaluated it to True while in analytics it is evaluated it to False. Query: SELECT age FROM default where age > 1; Analytics Output: {code} [ { "age": 70 }, { "age": 33 }, { "age": 12345.12345 } ] {code} N1QL Output: {code} [ { "age": 70 }, { "age": 33 }, { "age": [ 1, 2 ] }, { "age": { "key": "value" } }, { "age": 12345.12345 } ] {code} |
| Fix Version/s | Alice [ 15048 ] | |
| Fix Version/s | vulcan [ 14610 ] |
Technical nit: In Analytics the comparison evaluates to NULL (not to TRUE) and then the WHERE predicate filters such cases (because only the TRUEs survive).
| Rank | Ranked higher |
| Labels | functional-test | functional-test triaged |
| Rank | Ranked higher |
| Rank | Ranked higher |
| Rank | Ranked higher |
| Labels | functional-test triaged | functional-test n1ql triaged |
| Rank | Ranked higher |
| Epic Link | MB-24368 [ 68166 ] |
| Rank | Ranked higher |
| Sprint | CX Sprint 112 [ 617 ] |
| Rank | Ranked lower |
| Sprint | CX Sprint 112 [ 617 ] | CX Sprint 112, CX Sprint 113 [ 617, 618 ] |
| Rank | Ranked higher |
| Sprint | CX Sprint 112, CX Sprint 113 [ 617, 618 ] | CX Sprint 112, CX Sprint 113, CX Sprint 114 [ 617, 618, 619 ] |
| Sprint | CX Sprint 112, CX Sprint 113, CX Sprint 114 [ 617, 618, 619 ] | CX Sprint 112, CX Sprint 113, CX Sprint 114, CX Sprint 115 [ 617, 618, 619, 621 ] |
| Sprint | CX Sprint 112, CX Sprint 113, CX Sprint 114, CX Sprint 115 [ 617, 618, 619, 621 ] | CX Sprint 112, CX Sprint 113, CX Sprint 114, CX Sprint 115, CX Sprint 116 [ 617, 618, 619, 621, 637 ] |
| Fix Version/s | Mad-Hatter [ 15037 ] | |
| Fix Version/s | Alice [ 15048 ] | |
| Labels | functional-test n1ql triaged | Alice-candidate functional-test n1ql triaged |
| Labels | Alice-candidate functional-test n1ql triaged | Alice-candidate functional-test n1ql |
| Sprint | CX Sprint 112, CX Sprint 113, CX Sprint 114, CX Sprint 115, CX Sprint 116 [ 617, 618, 619, 621, 637 ] | CX Sprint 112, CX Sprint 113, CX Sprint 114, CX Sprint 115 [ 617, 618, 619, 621 ] |
| Rank | Ranked higher |
| Rank | Ranked higher |
| Rank | Ranked higher |
| Labels | Alice-candidate functional-test n1ql | functional-test n1ql |
| Labels | functional-test n1ql | functional-test n1ql triaged |
| Rank | Ranked higher |
| Assignee | Till Westmann [ till ] | Ali Alsuliman [ ali.alsuilman ] |
| Rank | Ranked higher |
| Assignee | Ali Alsuliman [ ali.alsuilman ] | Till Westmann [ till ] |
| Rank | Ranked higher |
| Fix Version/s | Cheshire-Cat [ 15915 ] | |
| Fix Version/s | Mad-Hatter [ 15037 ] |
Not being addressed for Mad-Hatter, moving to Cheshire-Cat
| Rank | Ranked higher |
| Rank | Ranked higher |
| Rank | Ranked higher |
| Rank | Ranked higher |
| Fix Version/s | CheshireCat.Next [ 16908 ] | |
| Fix Version/s | Cheshire-Cat [ 15915 ] |
| Fix Version/s | bug-backlog [ 11600 ] | |
| Fix Version/s | CheshireCat.Next [ 16908 ] |
| Rank | Ranked lower |
| Rank | Ranked lower |
| Rank | Ranked lower |
| Rank | Ranked lower |
The Analytics result is the specified result for the converged query language. It is also the expected result for Vulcan.
Deferring to Alice in case further discussion is needed.