Int32 data type is returned for integer-like Double values

[craxal]

• Package Name: @azure/data-tables
• Package Version: 13.0.1-alpha.20220112.3
• Operating system: Windows 11
• nodejs
  • version: 16.3.1
• browser
  • name/version:
• typescript
  • version: 4.5.3
• Is the bug related to documentation in
  • README.md
  • source code documentation
  • SDK API docs on https://docs.microsoft.com

Describe the bug
The client library does not return the correct data type for Double entity properties with integer-like values.

To Reproduce
Steps to reproduce the behavior:

1. Run the following code snippet:

    const client = TableClient.fromConnectionString("<CONNECTION_STRING>, "testmismatch");
    await client.createTable();
    await client.createEntity({ partitionKey: "A", rowKey: "A", value: { value: "6824053932181", type: "Double" } });
    const result = await client.listEntities({ disableTypeConversion: true, requestOptions: {} }).byPage().next();
    if (!!result.done) {
        console.log([]);
    } else {
        console.log(JSON.stringify(result.value, null, 2));
    }

2. Observe the console output.

Expected behavior
The output should look like the following (note the expected data type for "value":

[
  {
    "etag": "W/\"datetime'2022-01-19T01%3A28%3A35.4155551Z'\"",
    "partitionKey": "A",
    "rowKey": "A",
    "timestamp": "2022-01-19T01:28:35.4155551Z",
    "value": {
      "value": "6824053932181",
      "type": "Double"
    }
  }
]

Instead, the following comes out (note the actual data type for "value", even though the value is clearly outside the range of Int32):

[
  {
    "etag": "W/\"datetime'2022-01-19T01%3A28%3A35.4155551Z'\"",
    "partitionKey": "A",
    "rowKey": "A",
    "timestamp": "2022-01-19T01:28:35.4155551Z",
    "value": {
      "value": "6824053932181",
      "type": "Int32"
    }
  }
]

Screenshots
N/A

Additional context
N/A

[joheredi]

This problem can be reproduced when the Edm.Double value stored in the service has no decimals for example 123.0

When the SDK retrieves the entity the service doesn’t send odata.type metadata about the type of the property. When parsing the response payload with JavaScript’s native JSON parser the .0 gets lost. So when the SDK gets the chance to work with the data we are no longer able to tell between an Edm.Double with no decimals and an Edm.Int32.

Without the service sending odata.type metadata we don’t have a reliable way in JavaScript to differentiate the types in this scenario.

I'm currently discussing with the Service team alternatives to solve this problem.

[ghost]

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @klaaslanghout.

Issue Details

---

• Package Name: @azure/data-tables
• Package Version: 13.0.1-alpha.20220112.3
• Operating system: Windows 11
• nodejs
  • version: 16.3.1
• browser
  • name/version:
• typescript
  • version: 4.5.3
• Is the bug related to documentation in
  • README.md
  • source code documentation
  • SDK API docs on https://docs.microsoft.com

Describe the bug
The client library does not return the correct data type for Double entity properties with integer-like values.

To Reproduce
Steps to reproduce the behavior:

1. Run the following code snippet:

    const client = TableClient.fromConnectionString("<CONNECTION_STRING>, "testmismatch");
    await client.createTable();
    await client.createEntity({ partitionKey: "A", rowKey: "A", value: { value: "6824053932181", type: "Double" } });
    const result = await client.listEntities({ disableTypeConversion: true, requestOptions: {} }).byPage().next();
    if (!!result.done) {
        console.log([]);
    } else {
        console.log(JSON.stringify(result.value, null, 2));
    }

2. Observe the console output.

Expected behavior
The output should look like the following (note the expected data type for "value":

[
  {
    "etag": "W/\"datetime'2022-01-19T01%3A28%3A35.4155551Z'\"",
    "partitionKey": "A",
    "rowKey": "A",
    "timestamp": "2022-01-19T01:28:35.4155551Z",
    "value": {
      "value": "6824053932181",
      "type": "Double"
    }
  }
]

Instead, the following comes out (note the actual data type for "value", even though the value is clearly outside the range of Int32):

[
  {
    "etag": "W/\"datetime'2022-01-19T01%3A28%3A35.4155551Z'\"",
    "partitionKey": "A",
    "rowKey": "A",
    "timestamp": "2022-01-19T01:28:35.4155551Z",
    "value": {
      "value": "6824053932181",
      "type": "Int32"
    }
  }
]

Screenshots
N/A

Additional context
N/A

Author:	craxal
Assignees:	joheredi
Labels:	bug, customer-reported, Client, Service Attention, Tables, Service
Milestone:	-

[github-actions]

Hi @craxal, we deeply appreciate your input into this project. Regrettably, this issue has remained inactive for over 2 years, leading us to the decision to close it. We've implemented this policy to maintain the relevance of our issue queue and facilitate easier navigation for new contributors. If you still believe this topic requires attention, please feel free to create a new issue, referencing this one. Thank you for your understanding and ongoing support.