Hi,
Thank you for providing a script, this is much easier comparing.
I can now reproduce the error you get.
Please enter a ticket with this script into the tracker, so they can fix this
issue.
Enter these both queries, so they can quickly find the bug:
The query with the wrong results:
SELEC
Hello,
I have created an example:
SET SQL DIALECT 3;
CREATE TABLE T_MAIN (
TNR VARCHAR(16) NOT NULL,
MINB INTEGER
);
ALTER TABLE T_MAIN ADD CONSTRAINT PK_T_MAIN PRIMARY KEY (TNR);
SET SQL DIALECT 3;
CREATE TABLE T_STOCK (
TNR VARCHAR(16),
AMOUN
