Synametrics Technologies

I work with WinSQL Lite 10.0.178.718 version, IBM iSeries v7r1m0, Windows 7

If error take place in runtime, then WINSQL does not return any error message and displays emty result tab.
It make sence that query is good, but no data to select
In version 10 I got message "0 Row(s) affected" WITHOUT ANY ERROR MESSAGE

In version 9 I got right error message: "

Error: SQL0811 - Result of SELECT more than one row. (State:S1000, Native Code: FFFFFCD5)
0 Row(s) affected
SQL0811 - Result of SELECT more than one row.

"

SQL:

WITH TEST(ID, PRICE) AS
(VALUES (12345678, 20.20)
,       (12345678, 40.00)
,       (12000000, 50.00)
,       (13000000, 60.00)
,       (14000000, 70.00)
)
SELECT TEST.ID
,(SELECT T1.PRICE
FROM TEST T1
WHERE T1.ID = TEST.ID) AS PRICE
  
FROM TEST

Hi

any fix to this?

I use WinSQL lite version 10 with the same issue. Version 11 has the same error.

Connecting to DB2 on Windows 10 using ODBC.

Data Studio from IBM display the error message which WinSQL or ODBC is suppressing.