Changeset: 9db5a9ac4d00 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9db5a9ac4d00
Added Files:
sql/test/BugTracker-2015/Tests/NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871.test
sql/test/BugTracker-2015/Tests/adddrop_unknown_table.Bug-3718.test
sql/test/BugTracker-2015/Tests/alias.Bug-3704.test
sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.test
sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part2.test
sql/test/BugTracker-2015/Tests/ambiguous.Bug-3803.test
sql/test/BugTracker-2015/Tests/and_or_expression.Bug-3851.test
sql/test/BugTracker-2015/Tests/and_or_in.Bug-3655.test
sql/test/BugTracker-2015/Tests/apply_merge_distinct.Bug-3760.test
sql/test/BugTracker-2015/Tests/assertHead.Bug-3706.test
sql/test/BugTracker-2015/Tests/backslash_predecing_separator.Bug-3775.test
sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.test
sql/test/BugTracker-2015/Tests/case_aggr.Bug-3705.test
sql/test/BugTracker-2015/Tests/case_type.Bug-3821.test
sql/test/BugTracker-2015/Tests/cast_on_groupby_col_crash.Bug-3769.test
sql/test/BugTracker-2015/Tests/cast_to_num.Bug-3744.test
sql/test/BugTracker-2015/Tests/coalesce.Bug-3830.test
sql/test/BugTracker-2015/Tests/constant-random.Bug-3836.test
sql/test/BugTracker-2015/Tests/convert-to-bit.Bug-3719.test
sql/test/BugTracker-2015/Tests/copy_into.Bug-3813.test.in
sql/test/BugTracker-2015/Tests/crash.Bug-3736.test
sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.test
sql/test/BugTracker-2015/Tests/crash_on_alter_set_not_null.Bug-3715.test
sql/test/BugTracker-2015/Tests/crash_on_declared_table.Bug-3770.test
sql/test/BugTracker-2015/Tests/crash_timestamp_convert.Bug-3816.test
sql/test/BugTracker-2015/Tests/create-temp-table-using-like.Bug-3767.test
sql/test/BugTracker-2015/Tests/date_comparison_incorrect_results.Bug-3834.test
sql/test/BugTracker-2015/Tests/div_zero.Bug-3742.test
sql/test/BugTracker-2015/Tests/dump-DELETE.Bug-3850.test
sql/test/BugTracker-2015/Tests/duplicate-constraint.Bug-3820.test
sql/test/BugTracker-2015/Tests/epoch_now.Bug-3740.test
sql/test/BugTracker-2015/Tests/expression_with_comparison.Bug-3854.test
sql/test/BugTracker-2015/Tests/find_fk.Bug-3690.test
sql/test/BugTracker-2015/Tests/float-space-parse.Bug-3691.test
sql/test/BugTracker-2015/Tests/foreignkey_over_schemas.Bug-3855.test
sql/test/BugTracker-2015/Tests/fractional_precision_limitation.Bug-3808.test
sql/test/BugTracker-2015/Tests/hugeint-wrong-value.Bug-3849.test
sql/test/BugTracker-2015/Tests/ifthenelse.Bug-3699.test
sql/test/BugTracker-2015/Tests/import-non-ascii.Bug-3864.test
sql/test/BugTracker-2015/Tests/incorrect-ROW_NUMBER.Bug-3663.test
sql/test/BugTracker-2015/Tests/incorrect_result_type.Bug-3687.test
sql/test/BugTracker-2015/Tests/inet-funcs.Bug-3645.test
sql/test/BugTracker-2015/Tests/inet-ordering.Bug-3646.test
sql/test/BugTracker-2015/Tests/inet-ordering.Bug-3660.test
sql/test/BugTracker-2015/Tests/inf-nan-handling.Bug-3696.test
sql/test/BugTracker-2015/Tests/insert_into_merge_table_crash.Bug-3703.test
sql/test/BugTracker-2015/Tests/is_null_limit.Bug-3684.test
sql/test/BugTracker-2015/Tests/large_join.Bug-3809.test
sql/test/BugTracker-2015/Tests/left_shift_inet.Bug-3730.test
sql/test/BugTracker-2015/Tests/leftjoin.Bug-3720.test
sql/test/BugTracker-2015/Tests/like-escape.Bug-3822.test
sql/test/BugTracker-2015/Tests/limit_dbl.Bug-3847.test
sql/test/BugTracker-2015/Tests/limit_too_large_value.Bug-3857.test
sql/test/BugTracker-2015/Tests/long_insert.Bug-3845.test
sql/test/BugTracker-2015/Tests/many_union_all.Bug-3879.test
sql/test/BugTracker-2015/Tests/mergejoin_NULL.Bug-3747.test
sql/test/BugTracker-2015/Tests/missed-error.Bug-3842.test
sql/test/BugTracker-2015/Tests/mserver-crashes-under-specific-combination-of-JOIN-and-WHERE-conditions.Bug-3872.test
sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.test
sql/test/BugTracker-2015/Tests/msqldump-merge-and-remote-tables.Bug-3774.test
sql/test/BugTracker-2015/Tests/msqldump_generates_incorrect_syntax_ON_UPDATE_null.Bug-3839.test
sql/test/BugTracker-2015/Tests/name_conflict.Bug-3650.test
sql/test/BugTracker-2015/Tests/negative_oid_crash.Bug-3667.test
sql/test/BugTracker-2015/Tests/nil_cast.Bug-3787.test
sql/test/BugTracker-2015/Tests/not-like-without-wildcard.Bug-3811.test
sql/test/BugTracker-2015/Tests/null.Bug-3833.test
sql/test/BugTracker-2015/Tests/null_is_null.Bug-3739.test
sql/test/BugTracker-2015/Tests/operator-priority.Bug-3686.test
sql/test/BugTracker-2015/Tests/outerjoin_project.Bug-3725.test
sql/test/BugTracker-2015/Tests/prepare_unop_crash.Bug-3653.test
sql/test/BugTracker-2015/Tests/project_rewrite.Bug-3693.test
sql/test/BugTracker-2015/Tests/project_rewrite.Bug-3693_2.test
sql/test/BugTracker-2015/Tests/quantile_function_resolution.Bug-3773.test
sql/test/BugTracker-2015/Tests/readonly.Bug-3709.test
sql/test/BugTracker-2015/Tests/reserved_keywords.Bug-3613.test
sql/test/BugTracker-2015/Tests/row-value-constructor-crash.Bug-3662.test
sql/test/BugTracker-2015/Tests/savepoint.Bug-3738-1.test
sql/test/BugTracker-2015/Tests/savepoint.Bug-3738-2.reqtests
sql/test/BugTracker-2015/Tests/savepoint.Bug-3738-2.test
sql/test/BugTracker-2015/Tests/schema-trigger.Bug-3710.test
sql/test/BugTracker-2015/Tests/schema_view.Bug-3708.test
sql/test/BugTracker-2015/Tests/schema_view2.Bug-3766.test
sql/test/BugTracker-2015/Tests/select-push-crash.Bug-3829.test
sql/test/BugTracker-2015/Tests/select-tilde-arg.Bug-3814.test
sql/test/BugTracker-2015/Tests/sessions_crash.Bug-3759.test
sql/test/BugTracker-2015/Tests/set_default_role.Bug-3364.test
sql/test/BugTracker-2015/Tests/sharp-alias.Bug-3467.test
sql/test/BugTracker-2015/Tests/sql2pcre.Bug-3800.test
sql/test/BugTracker-2015/Tests/string-to-inet.Bug-3666.test
sql/test/BugTracker-2015/Tests/string_split.Bug-3564.test
sql/test/BugTracker-2015/Tests/sum_interval.Bug-3785.test
sql/test/BugTracker-2015/Tests/sys_tracelog.Bug-3887.test
sql/test/BugTracker-2015/Tests/timestamp_convert.Bug-3815.test
sql/test/BugTracker-2015/Tests/trigger-old-row.Bug-3741.test
sql/test/BugTracker-2015/Tests/true_or_predicate.Bug-3733.test
sql/test/BugTracker-2015/Tests/ukey_check_unaligned.Bug-3669.test
sql/test/BugTracker-2015/Tests/union_project.Bug-3723.test
sql/test/BugTracker-2015/Tests/update_with_without_parenthesis.Bug-3838.test
sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.test
sql/test/BugTracker-2015/Tests/uuid-compare.Bug-3827.test
sql/test/BugTracker-2015/Tests/window_function_crash.Bug-3861.test
sql/test/BugTracker-2015/Tests/with-columns-mismatch.Bug-3697.test
Modified Files:
testing/Mz.py.in
Branch: mtest
Log Message:
sql/test/BugTracker-2015
diffs (truncated from 7895 to 300 lines):
diff --git
a/sql/test/BugTracker-2015/Tests/NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871.test
b/sql/test/BugTracker-2015/Tests/NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugTracker-2015/Tests/NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871.test
@@ -0,0 +1,23 @@
+statement ok
+CREATE TABLE foo (col CHAR(8))
+
+statement ok
+INSERT INTO foo VALUES ('bee')
+
+query I rowsort
+SELECT * FROM foo WHERE NOT col LIKE 'b%'
+----
+
+query I rowsort
+SELECT * FROM foo WHERE (col NOT LIKE 'b%')
+----
+
+query T
+SELECT * FROM foo WHERE NOT col NOT like 'b%'
+----
+bee
+
+statement ok
+DROP TABLE foo
+
+
diff --git a/sql/test/BugTracker-2015/Tests/adddrop_unknown_table.Bug-3718.test
b/sql/test/BugTracker-2015/Tests/adddrop_unknown_table.Bug-3718.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2015/Tests/adddrop_unknown_table.Bug-3718.test
@@ -0,0 +1,13 @@
+statement ok
+CREATE merge TABLE mt (i int)
+
+statement error
+ALTER TABLE mt ADD TABLE blablah
+
+statement error
+ALTER TABLE mt DROP TABLE blablah
+
+statement ok
+DROP TABLE mt
+
+
diff --git a/sql/test/BugTracker-2015/Tests/alias.Bug-3704.test
b/sql/test/BugTracker-2015/Tests/alias.Bug-3704.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2015/Tests/alias.Bug-3704.test
@@ -0,0 +1,11 @@
+statement ok
+create table foo (z int)
+
+query I rowsort
+select aaa from (select 0,0,0,0,0,foo.z from foo)as t(aaa,b,c,d,e,f)
+----
+
+statement ok
+drop table foo
+
+
diff --git a/sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.test
b/sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.test
@@ -0,0 +1,77 @@
+statement ok
+CREATE TABLE hmda_lar_14 (AsOfYear DOUBLE PRECISION, RespondentID
VARCHAR(255), AgencyCode VARCHAR(255), LoanType DOUBLE PRECISION, PropertyType
VARCHAR(255), LoanPurpose DOUBLE PRECISION, Occupancy DOUBLE PRECISION,
LoanAmount DOUBLE PRECISION, Preapproval VARCHAR(255), ActionType DOUBLE
PRECISION, MSA_MD VARCHAR(255), StateCode VARCHAR(255), CountyCode
VARCHAR(255), CensusTractNumber VARCHAR(255), ApplicantEthnicity VARCHAR(255),
CoApplicantEthnicity VARCHAR(255), ApplicantRace1 VARCHAR(255), ApplicantRace2
VARCHAR(255), ApplicantRace3 VARCHAR(255), ApplicantRace4 VARCHAR(255),
ApplicantRace5 VARCHAR(255), CoApplicantRace1 VARCHAR(255), CoApplicantRace2
VARCHAR(255), CoApplicantRace3 VARCHAR(255), CoApplicantRace4 VARCHAR(255),
CoApplicantRace5 VARCHAR(255), ApplicantSex DOUBLE PRECISION, CoApplicantSex
DOUBLE PRECISION, ApplicantIncome VARCHAR(255), PurchaserType VARCHAR(255),
DenialReason1 VARCHAR(255), DenialReason2 VARCHAR(255), DenialReason3
VARCHAR(255), RateSpread VARCHAR(2
55), HOEPAStatus VARCHAR(255), LienStatus VARCHAR(255), EditStatus
VARCHAR(255), SequenceNumber VARCHAR(255), Population VARCHAR(255),
MinorityPopulationPct VARCHAR(255), HUDMedianFamilyIncome VARCHAR(255),
TracttoMSA_MDIncomePct VARCHAR(255), NumberofOwnerOccupiedUnits VARCHAR(255),
Numberof1to4Familyunits VARCHAR(255), ApplicationDateIndicator DOUBLE PRECISION)
+
+statement ok
+ALTER TABLE hmda_lar_14 ADD COLUMN temp_double DOUBLE
+
+statement ok
+ALTER TABLE hmda_lar_14 DROP COLUMN tracttomsa_mdincomepct
+
+statement ok
+ALTER TABLE hmda_lar_14 ADD COLUMN tracttomsa_mdincomepct DOUBLE
+
+statement ok
+ALTER TABLE hmda_lar_14 DROP COLUMN temp_double
+
+statement ok
+ALTER TABLE hmda_lar_14 ADD COLUMN temp_double DOUBLE
+
+statement ok
+ALTER TABLE hmda_lar_14 DROP COLUMN numberofowneroccupiedunits
+
+statement ok
+ALTER TABLE hmda_lar_14 ADD COLUMN numberofowneroccupiedunits DOUBLE
+
+statement ok
+ALTER TABLE hmda_lar_14 DROP COLUMN temp_double
+
+statement ok
+ALTER TABLE hmda_lar_14 ADD COLUMN temp_double DOUBLE
+
+statement ok
+ALTER TABLE hmda_lar_14 DROP COLUMN numberof1to4familyunits
+
+statement ok
+ALTER TABLE hmda_lar_14 ADD COLUMN numberof1to4familyunits DOUBLE
+
+statement ok
+ALTER TABLE hmda_lar_14 DROP COLUMN temp_double
+
+statement ok
+CREATE TABLE hmda_ins_14 (
+ activityyear DOUBLE,
+ respondentid VARCHAR(255),
+ agencycode VARCHAR(255),
+ fedtaxid VARCHAR(255),
+ respondentname_ts VARCHAR(255),
+ respondentmailingaddress VARCHAR(255),
+ respondentcity_ts VARCHAR(255),
+ respondentstate_ts VARCHAR(255),
+ respondentzipcode VARCHAR(255),
+ parentname_ts VARCHAR(255),
+ parentaddress VARCHAR(255),
+ parentcity_ts VARCHAR(255),
+ parentstate_ts VARCHAR(255),
+ parentzipcode VARCHAR(255),
+ respondentname_panel VARCHAR(255),
+ respondentcity_panel VARCHAR(255),
+ respondentstate_panel VARCHAR(255),
+ assets_panel DOUBLE,
+ otherlendercode_panel DOUBLE,
+ regioncode_panel DOUBLE,
+ larcount DOUBLE,
+ validityerror VARCHAR(255)
+)
+
+statement ok
+CREATE TABLE hmda_14 AS SELECT a.* , b.activityyear, b.fedtaxid,
b.respondentname_ts, b.respondentmailingaddress, b.respondentcity_ts,
b.respondentstate_ts, b.respondentzipcode, b.parentname_ts, b.parentaddress,
b.parentcity_ts, b.parentstate_ts, b.parentzipcode, b.respondentname_panel,
b.respondentcity_panel, b.respondentstate_panel, b.assets_panel,
b.otherlendercode_panel, b.regioncode_panel, b.larcount, b.validityerror FROM
hmda_lar_14 AS a INNER JOIN hmda_ins_14 AS b ON a.respondentid = b.respondentid
AND a.agencycode = b.agencycode WITH DATA
+
+query RTRI rowsort
+select actiontype, propertytype, loanpurpose, count(*) as num_records from
hmda_14 group by actiontype, propertytype, loanpurpose
+----
+
+query TTT rowsort
+select tables.name, columns.name, location from tables inner join columns on
tables.id=columns.table_id left join storage on tables.name=storage.table and
columns.name=storage.column where location is null and tables.name like 'hmda%'
+----
+
+
diff --git a/sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part2.test
b/sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part2.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part2.test
@@ -0,0 +1,14 @@
+query RTRI rowsort
+select actiontype, propertytype, loanpurpose, count(*) as num_records from
hmda_14 group by actiontype, propertytype, loanpurpose
+----
+
+statement ok
+drop table hmda_lar_14
+
+statement ok
+drop table hmda_ins_14
+
+statement ok
+drop table hmda_14
+
+
diff --git a/sql/test/BugTracker-2015/Tests/ambiguous.Bug-3803.test
b/sql/test/BugTracker-2015/Tests/ambiguous.Bug-3803.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2015/Tests/ambiguous.Bug-3803.test
@@ -0,0 +1,109 @@
+statement ok
+CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER, d INTEGER, e INTEGER)
+
+statement ok
+INSERT INTO t1(e,c,b,d,a) VALUES(103,102,100,101,104)
+
+statement ok
+INSERT INTO t1(a,c,d,e,b) VALUES(107,106,108,109,105)
+
+statement ok
+INSERT INTO t1(e,d,b,a,c) VALUES(110,114,112,111,113)
+
+statement ok
+INSERT INTO t1(d,c,e,a,b) VALUES(116,119,117,115,118)
+
+statement ok
+INSERT INTO t1(c,d,b,e,a) VALUES(123,122,124,120,121)
+
+statement ok
+INSERT INTO t1(a,d,b,e,c) VALUES(127,128,129,126,125)
+
+statement ok
+INSERT INTO t1(e,c,a,d,b) VALUES(132,134,131,133,130)
+
+statement ok
+INSERT INTO t1(a,d,b,e,c) VALUES(138,136,139,135,137)
+
+query IIIIIII rowsort
+SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 WHEN d THEN 333 WHEN e THEN
444 ELSE 555 END, CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 WHEN a<b+3 THEN
333 ELSE 444 END, cast(a+b*2+c*3+d*4 as bigint), cast(a+b*2+c*3 as bigint), c,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, abs(b-c) FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) OR b>c OR d NOT BETWEEN 110
AND 150 ORDER BY 4,1,5,2,6,3,7
+----
+56 values hashing to bf3fcae1d9c9b0ba86af03f38c7ec195
+
+query IIIIII rowsort
+SELECT a, cast(a+b*2+c*3+d*4+e*5 as bigint), c-d, CASE WHEN c>(SELECT avg(c)
FROM t1) THEN a*2 ELSE b*10 END, b-c, a+b*2 FROM t1 ORDER BY 6,2,4,5,3,1
+----
+48 values hashing to 3444f03be798ad301b786be3f3d7e14a
+
+query IIIIIII rowsort
+SELECT cast(a+b*2+c*3+d*4+e*5 as bigint), CASE WHEN a<b-3 THEN 111 WHEN a<=b
THEN 222 WHEN a<b+3 THEN 333 ELSE 444 END, a, abs(b-c), a+b*2, d, CASE WHEN
c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE (e>c OR e<d) OR
a>b ORDER BY 4,5,3,7,1,6,2
+----
+49 values hashing to e3bf92aba7b70a41ce1598b2579636dd
+
+query IIII rowsort
+SELECT a, e, CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, a-b
FROM t1 ORDER BY 2,4,3,1
+----
+32 values hashing to 86bb1f811c19e7215054f2888bc0d6bf
+
+query IIIIII rowsort
+SELECT d, CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
abs(b-c), cast(a+b*2+c*3+d*4+e*5 as bigint), CASE WHEN a<b-3 THEN 111 WHEN a<=b
THEN 222 WHEN a<b+3 THEN 333 ELSE 444 END, d-e FROM t1 ORDER BY 1,6,2,3,5,4
+----
+48 values hashing to e04e2b8fc995b7939b8e31b173b67336
+
+query IIIIII rowsort
+SELECT cast(a+b*2+c*3+d*4+e*5 as bigint), a, abs(a), a-b, d-e, CASE WHEN
c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE EXISTS(SELECT 1
FROM t1 AS x WHERE x.b<t1.b) AND b>c ORDER BY 4,6,3,1,5,2
+----
+18 values hashing to 521b1ec92350bfd04213cc0e0eaa798b
+
+query IIIIIII rowsort
+SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 WHEN a<b+3 THEN 333 ELSE
444 END, cast(a+b*2+c*3+d*4+e*5 as bigint), a, CASE a+1 WHEN b THEN 111 WHEN c
THEN 222 WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, CASE WHEN c>(SELECT
avg(c) FROM t1) THEN a*2 ELSE b*10 END, (SELECT count(*) FROM t1 AS x WHERE
x.c>t1.c AND x.d<t1.d), d FROM t1 WHERE a>b AND (e>a AND e<b) ORDER BY
7,2,4,6,1,3,5
+----
+
+query IIIIII rowsort
+SELECT e, (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), CASE WHEN c>(SELECT
avg(c) FROM t1) THEN a*2 ELSE b*10 END, CASE a+1 WHEN b THEN 111 WHEN c THEN
222 WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, a-b, (SELECT count(*) FROM
t1 AS x WHERE x.c>t1.c AND x.d<t1.d) FROM t1 WHERE a>b AND (c<=d-2 OR c>=d+2)
AND c>d ORDER BY 6,5,4,2,3,1
+----
+
+query IIIIIII rowsort
+SELECT b, a-b, c, abs(b-c), d-e, CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2
ELSE b*10 END, b-c FROM t1 WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
ORDER BY 1,6,4,5,2,7,3
+----
+49 values hashing to 9404d466624c062e0cc9bd0fb7ecb6b3
+
+query IIIIIII rowsort
+SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), b, a,
cast(a+b*2+c*3+d*4+e*5 as bigint), CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2
ELSE b*10 END, CASE a+1 WHEN b THEN 111 WHEN c THEN 222 WHEN d THEN 333 WHEN e
THEN 444 ELSE 555 END, cast(a+b*2+c*3 as bigint) FROM t1 WHERE a>b AND (e>c OR
e<d) ORDER BY 3,7,2,5,6,4,1
+----
+21 values hashing to 7dddd16c76fd86f082afdb2b18870038
+
+query IIIIIII rowsort
+SELECT c-d, a-b, b, b-c, CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE
b*10 END, c, a+b*2 FROM t1 ORDER BY 1,5,4,3,2,6,7
+----
+56 values hashing to 17726ce1f8ce6c313059a18af16c5c23
+
+query IIIIII rowsort
+SELECT cast(a+b*2+c*3+d*4 as bigint), a, c-d, abs(b-c), b, CASE WHEN c>(SELECT
avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1 WHERE (e>c OR e<d) OR (c<=d-2 OR
c>=d+2) ORDER BY 4,3,2,5,1,6
+----
+48 values hashing to e4a2f610304544be61a1494d7d2bc228
+
+query IIIIII rowsort
+SELECT a, cast(a+b*2+c*3+d*4+e*5 as bigint), b, CASE WHEN c>(SELECT avg(c)
FROM t1) THEN a*2 ELSE b*10 END, e, a-b FROM t1 ORDER BY 1,4,5,3,6,2
+----
+48 values hashing to 2ff466e4f3e407415987e8e75fdcd76d
+
+query IIIIIII rowsort
+SELECT d, d-e, CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
a+b*2, cast(a+b*2+c*3+d*4+e*5 as bigint), CASE WHEN a<b-3 THEN 111 WHEN a<=b
THEN 222 WHEN a<b+3 THEN 333 ELSE 444 END, cast(a+b*2+c*3 as bigint) FROM t1
ORDER BY 3,2,4,5,7,1,6
+----
+56 values hashing to f2599e718f02bf02e872faf9c7c4f256
+
+query IIIII rowsort
+SELECT a, CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, (SELECT
count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), cast(a+b*2+c*3+d*4 as
bigint), b FROM t1 WHERE c>d OR d>e ORDER BY 2,5,1,3,4
+----
+35 values hashing to b24468d0c48b6093dad4d6dbd9a3cfbd
+
+query IIII rowsort
+SELECT c, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), CASE
WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, cast(a+b*2+c*3+d*4 as
bigint) FROM t1 WHERE b>c OR (e>c OR e<d) OR d NOT BETWEEN 110 AND 150 ORDER BY
3,2,1,4
+----
+28 values hashing to 5de96c1ced0e3e3bb1f916e609d0592e
+
+statement ok
+DROP TABLE t1
+
+
diff --git a/sql/test/BugTracker-2015/Tests/and_or_expression.Bug-3851.test
b/sql/test/BugTracker-2015/Tests/and_or_expression.Bug-3851.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2015/Tests/and_or_expression.Bug-3851.test
@@ -0,0 +1,14 @@
+statement ok
+CREATE TABLE test (pid INTEGER)
+
+statement ok
+INSERT INTO test VALUES (1)
+
+query I rowsort
+SELECT t.pid FROM test t WHERE FALSE AND (FALSE OR TRUE) AND ( (FALSE AND
(FALSE OR FALSE)) OR TRUE )
+----
+
+statement ok
+DROP TABLE test
+
+
diff --git a/sql/test/BugTracker-2015/Tests/and_or_in.Bug-3655.test
b/sql/test/BugTracker-2015/Tests/and_or_in.Bug-3655.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2015/Tests/and_or_in.Bug-3655.test
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
