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
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
