Skip to Content
1
Former Member
Oct 06, 2015 at 05:38 PM

Internal error during join: invalid input (revision 102 - partitioned tables)

528 Views

Hi folks,

We're facing the following error after upgrading our Hana instance to revision 102:

"Column store error: search table error: [23057] Internal error during join : invalid input"

while trying to execute a hdbprocedure (called by an XSJS service) that makes a query similar to this:

SELECT COL_1,

COL_2,

...

FROM TABLE_1 T1

INNER JOIN TABLE_2 T2 ON T1.COL_A = T2.COL_X

AND T1.COL_B = T2.COL_Y

...

AND T1.DATE_1 = IFNULL(T2.DATE_2, T2.DATE_3)

WHERE T2.DATE_3 = P_DATE;

These tables are partitioned by Hash on level 1 and Range by MONTH(DATE_3) on level 2 for Data Pruning.

If we undo the partitioning, the execution completes successfully. Also, if we execute this query manually (outside the proc), it brings data successfully.

We already checked the data and none of these date columns have invalid data. The weird part is that it was working pretty fine when we were using rev 85.

Any ideas?

Thanks,