Details
Description
Running
SELECT name
|
FROM customers
|
WHERE rating =
|
(SELECT MAX(rating) FROM customers)
|
yields
[
|
{
|
"code": 1,
|
"msg": "ASX1002: Type mismatch: function scan-collection expects its 1st input parameter to be type multiset or array, but the actual input type is object",
|
"query_from_user": "SELECT name\nFROM customers\nWHERE rating = \n (SELECT MAX(rating) FROM customers);"
|
}
|
]
|
The problem is that the variable customers defined in line 2 is used in line 4.
Attachments
Issue Links
- relates to
-
MB-30525 Error message is misleading for analytics subquery if outer query is missing Alias
- Closed