Subquery Expression Support probleam


#1

hi, I see the doc about “Subquery Expression Support |expr IN (subquery or list of values)|”.
i run the sql like
" select f1, f2 from t1 where f1 in (select f1 from t2);", the mapd is crashed, what’ s the proleam ?


#2

i rebuild the table , it is ok now.
i have run truncate table before, is it cause the problem ?


#3

Hi @giverking -

Without more information, it’s hard to say what you problem might have been, but it’s almost certainly not because of a TRUNCATE TABLE statement.

If you still need help with this, please post your DDL and even a sample of data if you can, so that we can help you further.

Best,
Randy