My SQL queries are returning different numbers than expected, even when a specific WHERE clause is written. See the picture below:
I am looking at a specific ID in my where-clause but I receive a completely different ID. I've double checked this in the Snowflake editor and the returned ID is not present in our database. However, the where-clause ID is present in the database. In the Snowflake editor I do get the same ID returned (as should be).
No other field seems to be affected by this. While looking at other IDs that are even larger in numerical form VS Code/SQLTools seems to round the numbers. The error seems to only occur with these large numbers.
My SQL queries are returning different numbers than expected, even when a specific WHERE clause is written. See the picture below:
I am looking at a specific ID in my where-clause but I receive a completely different ID. I've double checked this in the Snowflake editor and the returned ID is not present in our database. However, the where-clause ID is present in the database. In the Snowflake editor I do get the same ID returned (as should be).
No other field seems to be affected by this. While looking at other IDs that are even larger in numerical form VS Code/SQLTools seems to round the numbers. The error seems to only occur with these large numbers.