Changeset: 246635fc47aa for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=246635fc47aa Added Files: sql/test/BugTracker-2014/Tests/create-view-crash.Bug-3414.sql sql/test/BugTracker-2014/Tests/create-view-crash.Bug-3414.stable.err sql/test/BugTracker-2014/Tests/create-view-crash.Bug-3414.stable.out Modified Files: sql/test/BugTracker-2014/Tests/All Branch: Jan2014 Log Message:
Added test for bug 3414. diffs (61 lines): diff --git a/sql/test/BugTracker-2014/Tests/All b/sql/test/BugTracker-2014/Tests/All --- a/sql/test/BugTracker-2014/Tests/All +++ b/sql/test/BugTracker-2014/Tests/All @@ -1,3 +1,4 @@ +create-view-crash.Bug-3414 nested_common_table_exp.Bug-3417 query-crash.Bug-3418 groupby.Bug-3421 diff --git a/sql/test/BugTracker-2014/Tests/create-view-crash.Bug-3414.sql b/sql/test/BugTracker-2014/Tests/create-view-crash.Bug-3414.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2014/Tests/create-view-crash.Bug-3414.sql @@ -0,0 +1,36 @@ +START TRANSACTION; + +CREATE TABLE sys.v_models_that_satisfy_criteria_dup ( + set_number int, + set_corr_coef real, + last_crit int, + crit_number int, + traffic_min real, + traffic_max real, + crit_corr_coef real, + min_lift real, + min_previous_precision real, + target_value varchar(1024), + model_number int, + number_of_scenarios bigint, + previous_precision real, + new_precision real, + lift real, + total_traffic real, + corr real, + corrb real, + expr1 real, + expr2 real, + expr3 real +); + +CREATE VIEW v_models_that_satisfy_criteria_min_set_dup AS +SELECT a.* + FROM v_models_that_satisfy_criteria_dup AS a + WHERE a.set_number = ( + SELECT MIN(b.set_number) + FROM v_models_that_satisfy_criteria_dup AS b + WHERE b.model_number = a.model_number + ); + +ROLLBACK; diff --git a/sql/test/BugTracker-2014/Tests/create-view-crash.Bug-3414.stable.err b/sql/test/BugTracker-2014/Tests/create-view-crash.Bug-3414.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2014/Tests/create-view-crash.Bug-3414.stable.err @@ -0,0 +1,1 @@ +Something other than a crash. diff --git a/sql/test/BugTracker-2014/Tests/create-view-crash.Bug-3414.stable.out b/sql/test/BugTracker-2014/Tests/create-view-crash.Bug-3414.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2014/Tests/create-view-crash.Bug-3414.stable.out @@ -0,0 +1,1 @@ +Something other than a crash. _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
