Strange problem with sql syntax checker and sql Merge

[pabloto]

Hi,

look at this video, making an sql merge the instructions will cut:

Screen.Recording.2025-03-12.at.14.53.57.mov

this is the instruction:

merge into sample.employee e
  using (select *from 
    (values ('000011', 'PAOLO', 'I', 'SALVATORE', 'A00', 1234, 'OPERATOR', 14)) as 
newemp (empno, firstnme, midinit, lastname, workdept, phoneno, job , edlevel))  a
 on a.empno = e.empno
when matched then update  
    set e.firstnme = a.firstnme, e.midinit = a.midinit, e.lastname = a.lastname, 
  e.workdept = a.workdept, e.phoneno = a.phoneno,
  e.job = a.job, e.edlevel = a.edlevel
when not matched then 
    insert (empno, firstnme, midinit, lastname, workdept, phoneno, job , edlevel)
 values (a.empno, a.firstnme, a.midinit, a.lastname, a.workdept, a.phoneno, 
  a.job, a.edlevel);

---

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

Context	Version
Code for IBM i version	2.15.3
Visual Studio Code version	1.98.1
Operating System	darwin_x64

Active extensions

COBOL (cobol): 25.3.9
Code Spell Checker (code-spell-checker): 4.0.40
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.9.3
Dev Containers (remote-containers): 0.401.0
ESLint (vscode-eslint): 3.0.10
Emmet (emmet): 1.0.0
Error Lens (errorlens): 3.24.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.282.0
GitHub Copilot Chat (copilot-chat): 0.25.0
GitLab Workflow (gitlab-workflow): 6.2.2
GitLens — Git supercharged (gitlens): 16.3.2
IBM i Debug (ibmidebug): 2.0.2
IBM i Project Explorer (vscode-ibmi-projectexplorer): 2.12.3
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.3
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.18.0
Server Ready Action (debug-server-ready): 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
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=JDET
CURLIB=JDET
HOME=/home/paolos
HOST=directa1.directa.lan
LANG=IT_IT.UTF-8
LIBLS=EMIR YAJLNEW YAJL DIRSAMPLE DEMODAT DEMOSYS ROBERTO PAOLOS CONTRADAT AL400 AL400SYS AL400MNUV2 FIBLIB BETALIB QGPL GESTSIMDAF GESTSIMDAT JDET QTEMP
LOGIN=paolos
LOGNAME=paolos
LS_COLORS=
MAIL=/var/spool/mail/paolos
OLDPWD=/DIRECTA1/home/paolos
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$
PWD=/home/paolos
QIBM_PASE_CCSID=1208
SHELL=/QOpenSys/pkgs/bin/bash
SHLVL=1
SSH_CLIENT=192.168.0.23 15334 22
SSH_CONNECTION=192.168.0.23 15334 192.168.0.11 22
SSL_CERT_FILE=/home/cacert.pem
TZ=<CET>-1<CEST>,M3.5.0,M10.5.0
USER=paolos
USERNAME=paolos
WORKDIR=/home/paolos
_=/QOpenSys/pkgs/bin/env

Variants

{
  "american": "#@$",
  "local": "£§$"
}

[worksofliam]

Weird! I'm out this week, but I will take this on first thing when I return.

[worksofliam]

@pabloto A fix is out in 1.9.4. Thanks!

[pabloto]

Thanks to you!