Different Results for Data Preview on Projection Node with Table UDF and Table UDF Select Statement

[sap_cohort]

I have a simple Calc View with a Projection Node with a Table Function (TUDF) as a source. Semantics/Aggregation/Projection(Table Function Source)

During Testing I am comparing a Data Preview directly on Projection Node vs a Select Statement on the Table Function used by the Projection Node. When I do this I get different results!
I am using the same exact Parameters for the Projection Node Data Preview and the Table Function Select (in SQL Console). There are no filters on the Projection Node. , but getting different results!

Not looking for an answer just some ideas or possibilities why I might be getting different results ?

[pfefferf]

Please can you share some more details to your question. E.g. how looks your projection node, what is the logic of your UDF, what is your SQL statement, what are the different results?

Regards,
Florian

[sap_cohort]

Hi,

Thanks for the follow up. Here is an image of the simple Calc View. I believe the TF Code should not matter since it is the same code that gets executed whether I right-click on the Projection Node or directly do an SQL Console select on the TF.

Everything I am testing is below the Aggregation Node. Why in the world would I get different values when there are no filters in the Projection node and the Projection includes all of the fields from the Table Function? I can't imagine any scenario why this would be? Thanks for any help or ideas with this!

[sap_cohort · Accepted solution]

A weekend upgrade from 1.0 SPS12 to 2.0 SPS 3 seems to have corrected the problem!
Thanks for your attention! - Ken