Hello !
It seems that there's a bug when using BUFFER LOAD mixed with nested LOADs.
I call nested LOADs those ones in layers, where we re-process a just-loaded file.
Like this :
LOAD * , LEFT(FIELD_ONE,2) AS PREFIX;
LOAD * FROM AFILE (QVD);
When we use BUFFER LOAD on a situation like that above, and also within a FOR/NEXT, the buffer wont work fine.
Try the attached example and you'll see what I'm talking about...
I really would like to see BUFFER working fine cause it's a very useful resource for development speed.
Thanks in advance for your support !