Hi all,

I noticed some strange behavior when executing a SQL query on our AS/
400 (V5R3) DB2 database. The query is like this:
Code:
WITH
    R AS (SELECT t1.ID, t2.ID
          FROM SCHEMA.TABLE1 t1, SCHEMA.TABLE2 t2
          WHERE t1.ID = t2.T1ID
          ORDER BY t1.ID DESC, t2.ID ASC ),
    Q AS (SELECT counter() cntr, R.*
          FROM R)
SELECT *
FROM Q
...