You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Safari/537.36
Build Identifier:
RUn the statements bellow.
Reproducible: Always
Steps to Reproduce:
CREATE TABLE t0(c0 VARCHAR(319) NOT NULL, c1 TIME, c2 TIMESTAMP PRIMARY KEY UNIQUE NULL, UNIQUE(c0, c2, c1));
CREATE TABLE t1(c0 CHARACTER LARGE OBJECT,c1 DATE);
select t1.c0 from t1 join t0 on coalesce(trim(t0.c0), 1) like t0.c0;
Actual Results:
A crash
Expected Results:
An empty result set.
The text was updated successfully, but these errors were encountered:
Date: 2020-07-17 16:27:38 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)
Last updated: 2020-10-19 11:06:21 +0200
Comment 27916
Date: 2020-07-17 16:27:38 +0200
From: @PedroTadim
User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Safari/537.36
Build Identifier:
RUn the statements bellow.
Reproducible: Always
Steps to Reproduce:
CREATE TABLE t0(c0 VARCHAR(319) NOT NULL, c1 TIME, c2 TIMESTAMP PRIMARY KEY UNIQUE NULL, UNIQUE(c0, c2, c1));
CREATE TABLE t1(c0 CHARACTER LARGE OBJECT,c1 DATE);
select t1.c0 from t1 join t0 on coalesce(trim(t0.c0), 1) like t0.c0;
Actual Results:
A crash
Expected Results:
An empty result set.
The text was updated successfully, but these errors were encountered: