Critical Description
The following query returns error in 5.5.x by KV. This is regression.
empty string is not valid META().id but this result in bigger issues with customers particularly with JOINs. The working queries start failing. We need to treat this is not qualified.
SELECT *
|
FROM default USE KEYS ""; |
"errors": [ |
{
|
"code": 12008, |
"msg": "Error performing bulk get operation - cause: MCResponse status=EINVAL, opcode=GET, opaque=0, msg: " |
}
|
],
|
|
Example :
The following query use to work and return 1 row and now it gives error. As JOIN condition k2 is not satisfied it should not give a row, it is NOT ERROR.
insert into default values("1",{"k1":"n007", "k2":"", "k3":"n0071", "k4":["n007","n006"]}); |
insert into default values("1",{"k1":"n007", "k2":"n008", "k3":"n0071", "k4":["n007","n006"]}); |
insert into default values("n008",{"name":"hello"}); |
|
|
select * from default d JOIN default d2 ON KEYS d.k2 ; |
|
https://forums.couchbase.com/t/n1ql-query-stops-working-in-5-5-1-but-was-working-in-5-0-1/18408
Attachments
Issue Links
- links to
