Hai Ariel,
- On which older version did this query work?
- Is this a standalone problem, i.e. if you only run this query, you immediately run into this problem, or the problem is triggered in combination of queries ran before this query?
- Can you give us the schema of the tables and sample data to reproduce this problem?
Jennie
On 17 Jul 2020, at 18:16, Ariel Abadi aabadi@starbi.com wrote:
Hi!
Maybe somebody can help me to understand if there is a bug on the latest version or if it is a better way to solve this issue.
Linux Centos 7 Monetdb version 11.37.7 (Jun2020)
I have created a new fresh database to avoid any issue on the upgrade, and imported all the data. The DB seems to be working fine.
We are using creating some dynamic queries, so the final query we need to run is the following:
select sum(nrm_realmin) as nrm_realmin from sb_traf.nrm_20200716 as t0 where (case when (nrm_tim_date || '@' || nrm_vep_id || '@' || nrm_rby_brn_id) in ( select distinct cast(curdate() - cast(value as interval day) as varchar(10)) || '@' || pbd_ven_id || '@' || pbd_deb_id as xx from sb_agre.agre_agr_agreement as agr join sb_agre.agre_prb_product_buy as prb on agr_id = prb_agr_id join sb_agre.agre_pbd_product_buydetail as psd on prb_id = pbd_prb_id left join sys.generate_series(0, 2) on (curdate() - cast(value as interval day)) between coalesce(prb_dstart, agr_dstart) and coalesce(prb_dend, agr_dend) and (curdate() - cast(value as interval day)) <= curdate() ) then 'BILAT' else 'AVAILABLE' end) not ilike '%BILAT%'
I am using this exact query on some other versions and they are all working, but on this version the query keeps running with no answer, even worse, I tried to stop the query via CALL sys.stop(tag) ... and it never stops, I had to restart the database to stop that query.
Does anybody have a clue how I can solve this issue?
Thanks for the help in advance! Rgds Ariel
http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Virus-free. www.avg.com http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail x-msg://94/#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list