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

BIGINT values are not displayed correctly #41

Open
KitaYoshihiro opened this issue Dec 27, 2023 · 0 comments
Open

BIGINT values are not displayed correctly #41

KitaYoshihiro opened this issue Dec 27, 2023 · 0 comments

Comments

@KitaYoshihiro
Copy link

KitaYoshihiro commented Dec 27, 2023

Large BIGINT numbers are not correctly displayed in vscode plugin.

CREATE TABLE test (id BIGINT);
INSERT INTO test VALUES(10000000000000001);
INSERT INTO test VALUES(10000000000000002);
INSERT INTO test VALUES(10000000000000003);
INSERT INTO test VALUES(10000000000000004);
INSERT INTO test VALUES(10000000000000005);

SELECT * FROM test;
+-------------------+
| id                |
+-------------------+
| 10000000000000000 |
| 10000000000000002 |
| 10000000000000004 |
| 10000000000000004 |
| 10000000000000004 |
+-------------------+

There is nothing wrong with the data stored in the table, but the display seems to be wrong.
These numbers are correctly displayed in regular terminals and MySQL Workbench.

(local)
MySQL Shell for VS Code v1.14.2
Windows 10
(remote)
Ubuntu20.04
mysql Ver 8.0.35

Thank you,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant