ORA-00909, when using IQueryFilter by anything and trying to take 0 results in response.
Posted: Mon 19 Sep 2016 10:49
Hi everyone,
I encountered a strange situation where as in topic, I am filtering results for by example SDO_GEOMETRY.
Everything is just fine when I try to take "normal" number of items in response, but when I want to take 0 EF creates not valid SELEC.
It goes like this whent not valid:
SELECT
1 AS C1,
TO_NUMBER(NULL) AS C2,
TO_NUMBER(NULL) AS C3,
TO_CHAR(NULL) AS C4,
TO_CHAR(NULL) AS C5,
TO_CHAR(NULL) AS C6,
CAST(NULL AS TIMESTAMP(9)) AS C7,
TO_CHAR(NULL) AS C8,
(CASE WHEN CAST(NULL AS SDO_GEOMETRY) IS NULL THEN NULL ELSE 'SRID=' || NVL(CAST(NULL AS SDO_GEOMETRY).SDO_SRID, '0') || ';' || SDO_UTIL.TO_WKTGEOMETRY(CAST(NULL AS SDO_GEOMETRY)) END) AS C9
FROM ( SELECT 1 AS X FROM DUAL) "SingleRowTable1"
WHERE 1 = 0
And when I want filter by string it is all the same.
Anyone knows why it could be happening?
I encountered a strange situation where as in topic, I am filtering results for by example SDO_GEOMETRY.
Everything is just fine when I try to take "normal" number of items in response, but when I want to take 0 EF creates not valid SELEC.
It goes like this whent not valid:
SELECT
1 AS C1,
TO_NUMBER(NULL) AS C2,
TO_NUMBER(NULL) AS C3,
TO_CHAR(NULL) AS C4,
TO_CHAR(NULL) AS C5,
TO_CHAR(NULL) AS C6,
CAST(NULL AS TIMESTAMP(9)) AS C7,
TO_CHAR(NULL) AS C8,
(CASE WHEN CAST(NULL AS SDO_GEOMETRY) IS NULL THEN NULL ELSE 'SRID=' || NVL(CAST(NULL AS SDO_GEOMETRY).SDO_SRID, '0') || ';' || SDO_UTIL.TO_WKTGEOMETRY(CAST(NULL AS SDO_GEOMETRY)) END) AS C9
FROM ( SELECT 1 AS X FROM DUAL) "SingleRowTable1"
WHERE 1 = 0
And when I want filter by string it is all the same.
Anyone knows why it could be happening?