All work

Select view

Select search mode

 
50 of

Unexpected results when using ASIN function with NULLIF

Description

Consider the following test case. It is unexpected that the last two queries both had cardinality 1, since NULLIF(-1, ASIN(t0.c1)) cannot be true and null at the same time.

Environment

Docker image acquired from percona/percona-server:latest
sha256:b76c455d3db1ae297449753b1054547b7910b3fd2ed4fd8c761cc1a6e202095a

Details

Assignee

Reporter

Found by Automation

Yes

Upstream Bug URL

Needs QA

Affects versions

Priority

Created January 25, 2024 at 10:04 AM
Updated January 25, 2024 at 5:07 PM

Activity

Show: