search

StarRocks / starrocks

StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries.
https://starrocks.io
Apache License 2.0
8.74k stars 1.75k forks source link

Query fails with No matching function with signature: array_map(function, array<datetime>, array<boolean>) #27936

Closed rcauble closed 1 year ago

rcauble commented 1 year ago

bug-repro.zip

Steps to reproduce the behavior (Required)

  1. Download the attachment and name as bug-repro.zip
  2. unzip bug-repro.zip
  3. cd bug-repro
  4. ./bug.sh

Expected behavior (Required)

Should run without error.

Real behavior (Required)

You'll get an error message No matching function with signature: array_map(function, array, array). But if you look at the SQL we never actually invoke a function with that signature.

StarRocks version (Required)

starrocks/allin1-ubuntu:3.1.0-rc01

fzhedu commented 1 year ago

as array_filter is based on array_map, and related code was changed, so this error came. simply reproduce

select array_map((x,y)->((x is null) and (y is null)), [1232], [[['abc']]]);

will fixed by https://github.com/StarRocks/starrocks/pull/27963