I've just upgraded from DotConnect Oracle 9.5.502 from 9.5.483 and a query is breaking. Here is the issue generated by the new version. This issue did not happen on Version 9.5.483.
Code: Select all
...
WHERE ("e0".ACTIVE = 1) AND EXISTS (
SELECT 1
FROM LISTING "l1"
WHERE ("l1".ACTIVE AND (("l1".SELLER_ID = :p__sellerId_0) AND EXISTS (
SELECT 1
FROM TICKET "t3"
...
I'm using .Net Core 2, with EF Core 2.0.
The full generated query is below.
Code: Select all
SELECT "l0".ID
,"l0".ACTIVE
,"l0".CREATED_BY
,"l0".CREATED_DATE
,"l0".DELIVERY_OPTION
,"l0".EVENT_ID
,"l0".FACE_PRICE
,"l0".FACE_PRICE_CURRENCY
,"l0".HIDE_SEAT_IND
,"l0".IN_HAND_DATE_UTC
,"l0".INCLUDES_PARKING_IND
,"l0".IN_HAND_IND
,"l0".PIGGYBACK_IND
,"l0".LAST_UPDATED_BY
,"l0".LAST_UPDATED_DATE
,"l0".LISTING_PRICE
,"l0".LISTING_PRICE_CURRENCY
,"l0".LISTING_STATUS
,"l0".MULTIPLE_SPLIT_COUNT
,"l0".PAYOUT_PRICE
,"l0".PAYOUT_PRICE_CURRENCY
,"l0".LISTING_PUBLISH_IND
,"l0".PURCHASE_CURRENCY
,"l0".PURCHASE_PRICE
,"l0".QUANTITY
,"l0".SEATING_OPTION
,"l0".SECTION
,"l0".SELLER_ID
,"l0".SHIP_FROM_ADDRESS_ID
,"l0".SPLIT_OPTION
,"l0".TICKET_TYPE
,"t1".ID AS ID1
,"t1".ACTIVE AS ACTIVE1
,"t1".CREATED_BY AS CREATED_BY1
,"t1".CREATED_DATE AS CREATED_DATE1
,"t1".DEFAULT_CURRENCY_CODE
,"t1".DEFAULT_LOCALE
,"t1".DEFAULT_TIMEZONE_ID
,"t1".LAST_SALES_SYNC
,"t1".LAST_UPDATED_BY AS LAST_UPDATED_BY1
,"t1".LAST_UPDATED_DATE AS LAST_UPDATED_DATE1
,"t1".SELLER_NAME
FROM LISTING "l0"
INNER JOIN (
SELECT "s".ID
,"s".ACTIVE
,"s".CREATED_BY
,"s".CREATED_DATE
,"s".DEFAULT_CURRENCY_CODE
,"s".DEFAULT_LOCALE
,"s".DEFAULT_TIMEZONE_ID
,"s".LAST_SALES_SYNC
,"s".LAST_UPDATED_BY
,"s".LAST_UPDATED_DATE
,"s".SELLER_NAME
FROM SELLER "s"
WHERE "s".ACTIVE = 1
) "t1" ON "l0".SELLER_ID = "t1".ID
INNER JOIN (
SELECT DISTINCT "t4".*
FROM (
SELECT "e0".ID
,"e0".EVENT_DATE_TIME
FROM EVENT "e0"
INNER JOIN (
SELECT "v0".*
FROM VENUE "v0"
WHERE "v0".ACTIVE = 1
) "t2" ON "e0".VENUE_ID = "t2".ID
WHERE ("e0".ACTIVE = 1) AND EXISTS (
SELECT 1
FROM LISTING "l1"
WHERE ("l1".ACTIVE AND (("l1".SELLER_ID = :p__sellerId_0) AND EXISTS (
SELECT 1
FROM TICKET "t3"
WHERE (("t3".ACTIVE = 1) AND ("t3".TICKET_STATUS = :p__ToString_1)) AND "l1".ID = "t3".LISTING_ID))) AND "e0".ID = "l1".EVENT_ID)
ORDER BY "e0".EVENT_DATE_TIME
,"e0".ID
OFFSET :p__p_2 ROWS FETCH NEXT :p__p_3 ROWS ONLY
) "t4"
) "t5" ON "l0".EVENT_ID = "t5".ID
WHERE "l0".ACTIVE = 1
ORDER BY "t5".EVENT_DATE_TIME
,"t5".ID
,"l0".ID