DotConnect Oracle 9.5.502 Bug - Bool missing value

[fred.steffen]

Hi there...

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"
         ...

See where it says ` ... WHERE ("l1".ACTIVE AND (("l1".SELLER_ID ... `, it should have ` = 1`.

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

[Shalex]

Could you please upload a test project for reproducing to ftp://ftp.devart.com (credentials: anonymous / yourEmail) or some other file exchange server?