24.08.2017 17:50, Jiří Činčura wrote:
I have a query that on one particular database throws: 2017-08-24T16:29:11.5140 (2704:0000000001620040) ERROR AT JStatement::openCursor I:\DOWNLOADS\BI2.FDB (ATT_16, SYSDBA:NONE, NONE, TCPv6:::1/51084) C:\Users\Jiri\Documents\devel\bin\Firebird-3.0.2.32703-0_x64\isql.exe:7116 335544381 : Implementation limit exceeded 335544388 : block size exceeds implementation restriction On other databases (same structure, same plan produced) on the same server (different data of course) it works fine. Backup & restore didn't help. I can provide the database, but given it's a customer data it needs to be handled as private data. The minimum query I can replicate it looks like this: with DAYS as (select distinct(DR.F_DA_DATE) from T_DAILY_RAW DR ) select count(*) from T_EMAILS_WEBDB_RAW EWR inner join DAYS DR on DR.F_DA_DATE = EWR.F_EWR_SENT inner join T_EMAIL_TYPE_DIM EMTD on EMTD.F_EMT_VALUE = EWR.F_EWR_TYPE;
What is the plan? I suspect some hardcoded limit for the hash join algorithm has been reached. Do you see HASH in the plan?
Dmitry ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel