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.

Sign up for GitHub

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

Jump to bottom

Big number and DB2 for i #324

Open
pabloto opened this issue Jan 30, 2025 · 2 comments · May be fixed by #333
Open

Big number and DB2 for i #324

pabloto opened this issue Jan 30, 2025 · 2 comments · May be fixed by #333
Assignees
@ThePrez

Comments

@pabloto
Copy link

pabloto commented Jan 30, 2025

Hi,

Could you try this?

values 80000000000000000002;

we have a table with a field defined numeric(20, 0) and the surprise is that the last digit is converted to zero...

Image

Many thanks

⚠️ REMOVE THIS LINE AND ANY SENSITIVE INFORMATION BELOW! ⚠️

Context Version
Code for IBM i version 2.14.7
Visual Studio Code version 1.96.4
Operating System darwin_arm64
Active extensions 
CL (vscode-clle): 1.1.7
COBOL (cobol): 25.1.25
Code Spell Checker (code-spell-checker): 4.0.34
Code for IBM i Walkthroughs (vscode-ibmi-walkthroughs): 0.5.0
Configuration Editing (configuration-editing): 1.0.0
Db2 for IBM i (vscode-db2i): 1.8.0
Dev Containers (remote-containers): 0.394.0
ESLint (vscode-eslint): 3.0.10
Emmet (emmet): 1.0.0
Error Lens (errorlens): 3.23.0
Extension Authoring (extension-editing): 1.0.0
Git (git): 1.0.0
Git Base (git-base): 1.0.0
Git Graph (git-graph): 1.30.0
GitHub (github): 0.0.1
GitHub Authentication (github-authentication): 0.0.2
GitHub Copilot (copilot): 1.260.0
GitHub Copilot Chat (copilot-chat): 0.23.2
GitHub Pull Requests (vscode-pull-request-github): 0.102.0
GitLab Workflow (gitlab-workflow): 5.36.0
GitLens — Git supercharged (gitlens): 16.2.1
IBM i Debug (ibmidebug): 2.0.2
IBM i Project Explorer (vscode-ibmi-projectexplorer): 2.12.0
JSON Language Features (json-language-features): 1.0.0
Live Share (vsliveshare): 1.0.5948
Markdown All in One (markdown-all-in-one): 3.6.2
Markdown Math (markdown-math): 1.0.0
Merge Conflict (merge-conflict): 1.0.0
Microsoft Account (microsoft-authentication): 0.0.1
NPM support for VS Code (npm): 1.0.1
Node Debug Auto-attach (debug-auto-launch): 1.0.0
RPGLE (vscode-rpgle): 0.28.6
Rainbow CSV (rainbow-csv): 3.15.1
Server Ready Action (debug-server-ready): 1.0.0
Simple Browser (simple-browser): 1.0.0
Source Orbit (vscode-sourceorbit): 1.0.2
TODO Highlight (vscode-todo-highlight): 1.0.5
TypeScript and JavaScript Language Features (typescript-language-features): 1.0.0
Vue - Official (volar): 2.2.0
WSL (remote-wsl): 0.88.5
Remote system
Setting Value
IBM i OS V7R4M0
Tech Refresh 10
CCSID Origin 1144
Runtime CCSID 280
Default CCSID 280
SSHD CCSID ?
cqsh true
SQL Enabled
Source dates Enabled

Enabled features

/QOpenSys/pkgs/bin /usr/bin /QSYS.LIB /QIBM/ProdData/IBMiDebugService/bin /QOpenSys/QIBM/ProdData/JavaVM/jdk80 /QOpenSys/QIBM/ProdData/JavaVM/jdk11 /QOpenSys/QIBM/ProdData/JavaVM/jdk17 /QOpensys/pkgs/lib/jvm
bash attr QZDFMDB2.PGM startDebugService.sh 64bit 64bit 64bit openjdk-11
chsh iconv
find setccsid
git uname
grep
ls
md5sum
sort
stat
tar
tn5250
Shell env 
BUILDLIB=AL400MNUV2
CURLIB=AL400MNUV2
HOME=/home/
HOST=directa1.directa.lan
LANG=IT_IT.UTF-8
LS_COLORS=
MAIL=/var/spool/mail/
PATH=/QOpenSys/pkgs/bin:/QOpenSys/pkgs/lib/nodejs18/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin
PS1=\u@\h@\W$
QIBM_PASE_CCSID=1208
SHELL=/QOpenSys/pkgs/bin/bash
SHLVL=1
SSL_CERT_FILE=/home/cacert.pem
TZ=<CET>-1<CEST>,M3.5.0,M10.5.0
WORKDIR=/home/
_=/QOpenSys/pkgs/bin/env
Variants 
{
  "american": "#@$",
  "local": "£§$"
}
@worksofliam worksofliam transferred this issue from codefori/vscode-ibmi Jan 30, 2025
@worksofliam
Copy link
Contributor

@ThePrez Could be a Mapepire issue?

@pabloto
Copy link
Author

pabloto commented Jan 30, 2025

It happen if the number is bigger then 15 digit.

@janfh janfh linked a pull request Feb 20, 2025 that will close this issue
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ThePrez ThePrez

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Use json-bigint for parsing server response to avoid truncation of large integers janfh/vscode-db2i
3 participants
@worksofliam @pabloto @ThePrez