search

microsoft / dbt-fabric

MIT License
79 stars 28 forks source link

Incorrect result set from the Table in Fabric Warehouse #218

Closed SharmaRakeshPFE closed 2 months ago

SharmaRakeshPFE commented 3 months ago

While working on the Fabric Portal I noticed different result set from the table. For an example the query is resulting columns from a different table which was not even referenced.

Table referenced in the query is EMP_FLAT_TBL but the result returned is from different table (EMP). This behavior was noticed multiple times in query and even in function.

SELECT FROM EMP_FLAT_TBL where Id='V59OF92YF627HFY0' SELECT FROM EMP_FLAT_TBL where Id is NULL

CREATE FUNCTION dbo.fn_return_bio(@id varchar(50)) RETURNS TABLE AS RETURN ( SELECT JSON_VALUE(JDETAILS, '$.bio') as 'Bio' FROM EMPJSON1 WHERE JSON_VALUE(JDETAILS, '$.id') ='ENTOCR13RSCLZ6KU' )

SELECT * FROM dbo.fn_return_bio('ENTOCR13RSCLZ6KU');

Error_1 Error_2 Error_3
prdpsvs commented 2 months ago

@SharmaRakeshPFE , How is this issue related to dbt-fabric adapter. You need open a ticket with Microsoft Support. If this is related to dbt-fabric adapter, please re-open the issue with information to repro the errror/issue.