Subject What implementation restriction was exceeded exactly?
Author Kjell Rilbe
I know the SQL below is somewhat silly, but ignoring that, why did it
give me this error:

Error executing query: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction

The SQL is "only" about 7 kbyte and the "or-list" contains far fewer
than the 1499 items that's maximum for "in-lists". So what
implementation restriction was exceeded, exactly?

SELECT "Epostadress_1"."ECO_ID"
FROM "Epostadress" "Epostadress_1"
WHERE (("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?)
or ("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?) or ("Epostadress_1"."Adress" = ?) or
("Epostadress_1"."Adress" = ?))

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64