Changeset: 11c1724677ad for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=11c1724677ad Added Files: sql/test/BugTracker-2017/Tests/name-interference.Bug-6348.sql Modified Files: sql/test/BugTracker-2017/Tests/All Branch: default Log Message:
Added file for bug 6348 diffs (44 lines): diff --git a/sql/test/BugTracker-2017/Tests/All b/sql/test/BugTracker-2017/Tests/All --- a/sql/test/BugTracker-2017/Tests/All +++ b/sql/test/BugTracker-2017/Tests/All @@ -68,3 +68,4 @@ statistics_nils_not_eq_zero.Bug-6331 crash-select_after_MAL_error.Bug-6332 groupby_assertion.Bug-6338 spurious_error.Bug-6344 +name-interference.Bug-6348 diff --git a/sql/test/BugTracker-2017/Tests/name-interference.Bug-6348.sql b/sql/test/BugTracker-2017/Tests/name-interference.Bug-6348.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/name-interference.Bug-6348.sql @@ -0,0 +1,31 @@ +create table cls_0(i integer, j integer, k string); +insert into cls_0 values +( 1, 99, 'b'), +( 2, 99, 'b'), +( 3, 99, 'b'), +( 4, 99, 'a'), +( 5, 99, 'a'), +( 6, 99, 'a'), +( 7, 33, 'b'), +( 8, 33, 'b'), +( 9, 33, 'b'), +( 10, 33, 'a'), +( 11, 33, 'a'), +( 12, 33, 'a'); +select * from cls_0; + +-- The metric functions over all columns are derived in one blow. +-- The result can be cached for easy recall +create procedure cls_0_statistics() +begin + create table cls_0_statistics ( col string, fcn string, tpe string, val string); + insert into cls_0_statistics values + ('i', 'min', 'int', (select cast( min( i ) as string) from cls_0)), + ('i', 'max', 'int', (select cast( min( i ) as string) from cls_0)), + ('j', 'min', 'int', (select cast( min( i ) as string) from cls_0)); +end; + +select * from cls_0_statistics; + +drop procedure cls_0_statistics; +drop table cls_0_statistics; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list