Changeset: 830f1b925d45 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=830f1b925d45
Modified Files:
sql/test/SQLancer/Tests/sqlancer01.sql
Branch: Jun2020
Log Message:
SQLancer, algebra.select undefined
diffs (20 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer01.sql
b/sql/test/SQLancer/Tests/sqlancer01.sql
--- a/sql/test/SQLancer/Tests/sqlancer01.sql
+++ b/sql/test/SQLancer/Tests/sqlancer01.sql
@@ -302,6 +302,16 @@ select 1 from v0 full outer join t0 on c
select cast(sum(all + (cast(t0.c0 as int))) as bigint) from v0 full outer join
t0 on ((cast((cast(v0.c1 as boolean)) not in (true, ((t0.c0)=(t0.c0)),
cast(1745166981 as boolean)) as string))ilike(v0.c0));
ROLLBACK;
+START TRANSACTION; -- Bug 6907
+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;
+ROLLBACK;
+
DROP TABLE tbl_ProductSales;
DROP TABLE another_T;
DROP TABLE integers;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
