LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Missing Records

    Employee
    Posted 10-21-2011 13:12

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: JAWILBUR

    Has this happened to you?

    The Scenario: When using a DB query node to execute a set of UNION statements gives me one set of data with X amount of records.

    Splitting the statements into 3 separate nodes gives me more records collectively. Same exact code is being used.

    See the attached file.
    Attachments:
    image001.jpg
    image003.jpg


  • 2.  RE: Missing Records

    Employee
    Posted 10-23-2011 08:29

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rboccuzzi

    I have not seen this behavior before, so I suspect possibly, it dealing with duplicates differently?

    Without seeing the code and data, that would be my guess...can you post the nodes in question? Even then, without the data, not sure I will be able to tell. Can you run a duplicate detector on both results, or even better, have you isolated the records that are in one but not the other?