Changeset: c9829154dcbb for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c9829154dcbb
Added Files:
sql/test/BugTracker-2016/Tests/create_table_from_complex_query.Bug-3921.sql
Modified Files:
sql/test/BugTracker-2016/Tests/All
Branch: default
Log Message:
Test for Bug 3921
diffs (19 lines):
diff --git a/sql/test/BugTracker-2016/Tests/All
b/sql/test/BugTracker-2016/Tests/All
--- a/sql/test/BugTracker-2016/Tests/All
+++ b/sql/test/BugTracker-2016/Tests/All
@@ -1,2 +1,3 @@
LEFT-JOIN_with_OR_conditions_triggers_assertion.Bug-3908
incorrect_column_name_in_OR_condition_of_LEFT-JOIN_crashes_mserver.Bug-3909
+create_table_from_complex_query.Bug-3921
diff --git
a/sql/test/BugTracker-2016/Tests/create_table_from_complex_query.Bug-3921.sql
b/sql/test/BugTracker-2016/Tests/create_table_from_complex_query.Bug-3921.sql
new file mode 100644
--- /dev/null
+++
b/sql/test/BugTracker-2016/Tests/create_table_from_complex_query.Bug-3921.sql
@@ -0,0 +1,7 @@
+start transaction;
+create table bug3921a (pde_id clob, bene_id clob, srvc_dt clob, prod_srvc_id
clob, plan_cntrct_rec_id clob, plan_pbp_rec_num clob, qty_dspnsd_num double,
days_suply_num double, drug_cvrg_stus_cd clob, ctstrphc_cvrg_cd clob,
ptnt_pay_amt double, othr_troop_amt double, lics_amt double, plro_amt double,
cvrd_d_plan_pd_amt double, ncvrd_plan_pd_amt double, tot_rx_cst_amt double,
benefit_phase clob, ccw_pharmacy_id double, ccw_prscrbr_id double,
pde_prscrbr_id_frmt_cd clob, formulary_id clob, frmlry_rx_id clob,
rptd_gap_dscnt_num double, brnd_gnrc_cd clob, rx_c_cov double, rx_c_lics
double, rx_c_tpc double, rx_c_tdc double, rx_c_oop double, rx_c_gdc double,
rx_e_cov double, rx_e_lics double, rx_e_tpc double, rx_e_tdc double, rx_e_oop
double, rx_e_gdc double, rx_o_cov double, rx_o_lics double, rx_o_tpc double,
rx_o_tdc double, rx_o_oop double, rx_o_gdc double, rx_ce_cov double, rx_ce_lics
double, rx_ce_tpc double, rx_ce_tdc double, rx_ce_oop double, rx_ce_gdc double,
rx_co_cov double, rx_
co_lics double, rx_co_tpc double, rx_co_tdc double, rx_co_oop double,
rx_co_gdc double, rx_eo_cov double, rx_eo_lics double, rx_eo_tpc double,
rx_eo_tdc double, rx_eo_oop double, rx_eo_gdc double, rx_ceo_cov double,
rx_ceo_lics double, rx_ceo_tpc double, rx_ceo_tdc double, rx_ceo_oop double,
rx_ceo_gdc double);
+
+-- this crashes
+create table bug3921b as select bene_id ,CAST( COUNT( DISTINCT CASE WHEN
drug_cvrg_stus_cd IN ('c') THEN ccw_prscrbr_id END ) AS DOUBLE ) as
rx_c_pre,CAST( COUNT( DISTINCT CASE WHEN drug_cvrg_stus_cd IN ('c') THEN
ccw_pharmacy_id END ) AS DOUBLE ) as rx_c_pha from bug3921a group by bene_id
WITH DATA;
+
+rollback;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
