SELECT COUNT(*) FROM TIME_LOG_ENTRY_VIEW WHERE UNIQUE_ID = /something/

-
SELECT COUNT(*) FROM TIME_LOG_ENTRY_VIEW WHERE UNIQUE_ID = /something/

Result: 5

;_;

Comments

  1. François PietteDecember 27, 2013 at 11:03 PM

    Anthony Frazier Your so called UNIQUE_ID is not so unique. btw: the name does not mean it is unique. A constraint needs to be added when defining the DB.

    ReplyDelete
  2. Anthony FrazierDecember 28, 2013 at 8:18 AM

    I know. Unfortunately, I don't control the DB or the data in it. I think the real issue is that the query that defines the view has a join bug. The spec I was given was that the unique id column was supposed to be... Unique, so this result is blowing up my own app.

    ReplyDelete

Post a Comment