Details
-
Bug
-
Resolution: Done
-
Major
-
4.5.0
-
450-1854+
-
Untriaged
-
Yes
Description
The exact test runs ok on build 1760. And there are no test-code changes in the tests on later builds.
The United Q2 queries have started failing with error '"Expression must be a group key or aggregate: (`pilot`.`FILEN`)"'
Note: This query has worked upto build 1760 on sanity.
Couchbase query shell connected to http://localhost:8093/ . Type Ctrl-D to exit.
|
cbq> select
|
> pilot.FILEN as pilot_filen,
|
> min([p.PRFL_ACT_GMT_DEP_DTM, meta(p).id]) PRFL_ACT_GMT_DEP_DTM
|
> from
|
> ( SELECT x.*
|
> FROM ods x
|
> where x.TYPE="CREW_ON_FLIGHT" AND
|
> (
|
> x.PRFL_ACT_GMT_DEP_DTM <= "2015-07-23T18:49:00Z"
|
> )
|
> ) as p unnest array_concat(p.PILOT,p.CREW) pilot
|
> WHERE
|
> pilot.FILEN in (
|
> select raw pilot1.FILEN
|
> from ods f use keys [ "UA_22-07-2015_EWR_IAD_6049" ]
|
> unnest array_concat(f.PILOT,f.CREW) pilot1
|
> )
|
> group by pilot.FILEN
|
> UNION ALL
|
> select
|
> pilot.FILEN as pilot_filen,
|
> min([p.GMT_EST_DEP_DTM, meta(p).id]) GMT_EST_DEP_DTM
|
> from
|
> (
|
> SELECT y.*
|
> FROM ods y
|
> where y.TYPE="CREW_ON_FLIGHT" AND
|
> (
|
> y.GMT_EST_DEP_DTM <= "2015-07-23T18:49:00Z"
|
> )
|
> ) as p unnest array_concat(y.PILOT,y.CREW) pilot
|
> where
|
> pilot.FILEN in (
|
> select raw pilot1.FILEN
|
> from ods f use keys [ "UA_22-07-2015_EWR_IAD_6049" ]
|
> unnest array_concat(f.PILOT,f.CREW) pilot1
|
> );
|
{
|
"requestID": "160fb344-818b-415f-9081-de2892a10e48",
|
"errors": [
|
{
|
"code": 4210,
|
"msg": "Expression must be a group key or aggregate: (`pilot`.`FILEN`)"
|
}
|
],
|
"status": "fatal",
|
"metrics": {
|
"elapsedTime": "17.038326ms",
|
"executionTime": "16.960198ms",
|
"resultCount": 0,
|
"resultSize": 0,
|
"errorCount": 1
|
}
|
}
|
|
Adding logs from build 1854.
https://s3.amazonaws.com/cb-customers/a/1/collectinfo-2016-03-22T221756-ns_1%40127.0.0.1.zip