Date: 2020-06-16 11:20:50 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)

Last updated: 2020-07-27 09:30:13 +0200

Comment 27858

Date: 2020-06-16 11:20:50 +0200
From: @PedroTadim

User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36
Build Identifier:

Runs the statements bellow.

Reproducible: Always

Steps to Reproduce:

CREATE TABLE "t0" ("c0" DOUBLE PRECISION NOT NULL,"c1" VARCHAR(64));
create view v0(c0, c1) as (select all t0.c0, r'epfNW⟚榢tptPbC{5{ZW}6,R' from t0) with check option;
SELECT v0.c0 FROM v0 WHERE (v0.c1) NOT BETWEEN SYMMETRIC (replace(CAST(CAST(v0.c0 AS INT) AS STRING), v0.c1, replace(CAST(0.1 AS STRING), v0.c1, v0.c1))) AND (v0.c1);

Actual Results:

batcalc.between undefined error

Expected Results:

empty result set.