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/83.0.4103.106 Safari/537.36
Build Identifier:
Run the statements bellow.
Reproducible: Always
Steps to Reproduce:
CREATE TABLE t0 (c0 BOOLEAN, c1 CHAR(140));
create view v0(c0) as (select distinct 0.4 from t0 where ((t0.c0)and((((lower(t0.c1))||(((((-69891801)/(1210439951)))+(cast(0.5895729273161221 as int))))))
between symmetric (cast(0.5 as string)) and (greatest(t0.c1, ((t0.c1)||(-2045486895)))))));
create view v1(c0, c1) as (select all 0.1, ((((cast(0.2 as int))/(+ (((((-212060493)*(816153822)))|(((2000022046)+(1143103273))))))))%(cast(cast(0.76693934 as int) as int))) from v0
group by 0.3, cast(- (cast(2.000022046E9 as int)) as boolean), sql_max(cast(cast(v0.c0 as string(336)) as int), length('1')), ((cast(0.19825737 as int))%(-1509376269)), v0.c0
having count(all (0.7) is not null) order by v0.c0 asc nulls first) with check option;
select all sum(all cast(t0.c0 as int)) as agg0 from v1 join t0 on cast(cast(v1.c1 as int) as boolean) where (v1.c1) not in (v1.c1, 0.36970723) is null;
The text was updated successfully, but these errors were encountered:
Date: 2020-06-17 16:39:50 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)
Last updated: 2020-07-27 09:30:12 +0200
Comment 27864
Date: 2020-06-17 16:39:50 +0200
From: @PedroTadim
User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.106 Safari/537.36
Build Identifier:
Run the statements bellow.
Reproducible: Always
Steps to Reproduce:
CREATE TABLE t0 (c0 BOOLEAN, c1 CHAR(140));
create view v0(c0) as (select distinct 0.4 from t0 where ((t0.c0)and((((lower(t0.c1))||(((((-69891801)/(1210439951)))+(cast(0.5895729273161221 as int))))))
between symmetric (cast(0.5 as string)) and (greatest(t0.c1, ((t0.c1)||(-2045486895)))))));
create view v1(c0, c1) as (select all 0.1, ((((cast(0.2 as int))/(+ (((((-212060493)*(816153822)))|(((2000022046)+(1143103273))))))))%(cast(cast(0.76693934 as int) as int))) from v0
group by 0.3, cast(- (cast(2.000022046E9 as int)) as boolean), sql_max(cast(cast(v0.c0 as string(336)) as int), length('1')), ((cast(0.19825737 as int))%(-1509376269)), v0.c0
having count(all (0.7) is not null) order by v0.c0 asc nulls first) with check option;
select all sum(all cast(t0.c0 as int)) as agg0 from v1 join t0 on cast(cast(v1.c1 as int) as boolean) where (v1.c1) not in (v1.c1, 0.36970723) is null;
The text was updated successfully, but these errors were encountered: