search

codefori / vscode-db2i

Db2 for IBM i Tools for VS Code
MIT License
46 stars 25 forks source link

SQL gives different result set between VS code / ACS / greenscren #251

Open dev-wouter opened 1 month ago

dev-wouter commented 1 month ago

hi,

when trying only to use VS-Code i stumbled on something strange. when looking at 1 date field the result set in VS code shows null, but actually it is loval date. even when i have a where 'Is not null' it still gives the loval fields in the result set.

i think VS code makes the loval value to a null in the result set but the query does not translate Null to loval 353338660-e2b11fab-a8ba-4fe7-b20c-b6eae04bd52c

if needed more info you can always ask.

Ps. working on the latest releases of the plugins/ vs code

worksofliam commented 4 weeks ago

@ThePrez Any opinion on this?