Aggregates in insert/upsert into select returns error

Description

Components

Affects versions

Fix versions

Labels

Environment

None

Link to Log File, atop/blg, CBCollectInfo, Core dump

None

Release Notes Description

None

Activity

Show:

CB robot April 29, 2020 at 6:26 AM

Build couchbase-server-1006.5.1-1125 contains query commit 5a4e41c with commit message:
. Fix issue with aggregation in INSERT/UPSERT INTO SELECT

CB robot April 29, 2020 at 6:26 AM

Build couchbase-server-1006.5.1-1125 contains query commit 579c645 with commit message:
. Update test for new decade

CB robot April 29, 2020 at 6:26 AM

Build couchbase-server-1006.5.1-1125 contains query commit 0f29818 with commit message:
. Update decade

Ajay Pal Bhullar March 9, 2020 at 9:54 PM

verified in 7.0.0-1432 , 6.5.1-6240 closing out, tested sum, min,max,avg

Ajay Pal Bhullar March 9, 2020 at 9:03 PM

Nevermind I understand now, I was attempting to do this insert on an empty bucket, so

SELECT SUM(1) AS doc FROM default;

returns null, hence it inserts an empty document. There is no issue

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Is this a Regression?

Yes

Triage

Untriaged

Priority

Instabug

Open Instabug

PagerDuty

Sentry

Zendesk Support

Created January 10, 2020 at 1:26 PM
Updated June 17, 2021 at 10:32 PM
Resolved January 14, 2020 at 12:02 AM
Instabug