Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Server int data length is wrongly set as 4, which results in >= 5 length ints being truncated #172

Closed
CreepPork opened this issue Feb 16, 2023 · 1 comment
Labels
bug Something isn't working

Comments

@CreepPork
Copy link

Please answer the questions below, it helps us to track the issue.

  1. Database version (Ex: PostgreSQL 10.0): Microsoft SQL Server 2008

  2. TablePlus version (the number on the welcome or about screen, Ex: build 81): build 192

  3. Linux distro (Ex: Ubuntu 18.04): Ubuntu 22.04

  4. The steps to reproduce this issue:

This happens also when running an SQL query too. I believe that this happens to all int data types.

Structure:

DataGrip DDL:

-- auto-generated definition
create table StoreDoc
(
    StoreDocID  int identity constraint PK_StoreDoc primary key with (fillfactor = 80),
    -- etc...
)

Beekeeper Studio:
Screenshot_20230216_101450

TablePlus:
Screenshot_20230216_101535

Data

Data (4 length int):
image

Data (5 length int) see that data is truncated:
image

@huyphams huyphams added the bug Something isn't working label Feb 16, 2023
@CreepPork
Copy link
Author

Fixed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants