Subject | What implementation restriction was exceeded exactly? |
---|---|
Author | Kjell Rilbe |
Post date | 2011-08-31T13:19:50Z |
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
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