Skip to content

Comment in updatable cell #386

Open
Open
@pabloto

Description

@pabloto

In the following select statement:

update: select * from sample.employee
--  where job = 'MANAGER'
order by empno;

the where clause is not ignored as expected from the comment.


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

Context Version
Code for IBM i version 2.15.3
Visual Studio Code version 1.99.3
Operating System darwin_arm64
Active extensions
CL (vscode-clle): 1.1.7
COBOL (cobol): 25.4.27
Code Spell Checker (code-spell-checker): 4.0.47
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.11.0
Dev Containers (remote-containers): 0.409.0
ESLint (vscode-eslint): 3.0.10
Emmet (emmet): 1.0.0
Error Lens (errorlens): 3.25.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.309.0
GitHub Copilot Chat (copilot-chat): 0.26.7
GitLab Workflow (gitlab-workflow): 6.12.0
GitLens — Git supercharged (gitlens): 17.0.3
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 Language Features (markdown-language-features): 1.0.0
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.29.2
Rainbow CSV (rainbow-csv): 3.19.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.99.0
vscode-icons (vscode-icons): 12.12.0

Remote system
Setting Value
IBM i OS V7R4M0
Tech Refresh 11
CCSID Origin 280
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/user
HOST=directa1.directa.lan
LANG=IT_IT.UTF-8
LIBLS=SAMPLE
LOGIN=user
LOGNAME=user
LS_COLORS=
MAIL=/var/spool/mail/user
OLDPWD=/DIRECTA1/home/user
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/user
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
USER=user
USERNAME=user
WORKDIR=/home/user
_=/QOpenSys/pkgs/bin/env
Variants
{
  "american": "#@$",
  "local": "£§$"
}

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions