ToString(signed-integer) is broken (32-64 bit conversion)

[92dev]

ToString(signed-integer) is broken (32-64 bit conversion)

[ealsur]

@92dev thanks for the report.

will love to find out that it works well if used from an SDK directly

Have you tried executing the query on the .NET SDK? Is it working and if not, what is the exception? Can you share a repro in that case?

This repository is not to track issues with the Azure Portal or the service in general.

[92dev]

Yeah, just did a deep dive into this shit, it's 100% like @jackbond mentioned,
it's an issue with the Azure portal converting values in javascript and managing it in a weird way
the thing is I used the portal as a source-of-truth (which made sense at the time lol)

after inspecting with the SDK itself - since the value in the DB differs from the one I saw - it works just fine 🙂

all in all, I guess there will be 0 chance of Azure web team ever fixing it (the UI is already all over the place with different icons themes and people maintenance teams)

EDIT: for anyone interested, I opted to change my code to always convert all values to STRING before pushing to CosmosDB, that way I avoid shit with triggers and functions like mentioned above.. who needs performance or integrity when we have a semi-functioning DB..

[Pilchie]

@jackbond - for queries where you need the numeric value where you store something as a string, consider using the STRINGTONUMBER to convert it to a number inside the query engine. Also tagging @sboshra.