Skip to content

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

@CreepPork

Description

@CreepPork

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions