I have the following question about sql and ejb-ql:
key pk action
1 1 I
1 2 U
1 3 U *
4 4 I *
5 5 I *
6 6 I
6 7 D
My boss forces me to use a flat table as above. Here is what happened to this table:
1. A user inserted a record (key and pk == 1) 2. They then updated the same record. You will notice that the "key" is the same (pk == 2) 3. They then updated the update. Key is the same and pk ==3 4. They then inserted a fresh record (pk ==4) 5. Fresh insert again 6. Fresh insert again 7. Delete of immediately previous fresh insert
You will notice that for each action I have an insert into the db (this is for logging/history purposes).
I need to be able to retrieve all record that would have survived the updates and deletes through sql i.e. those marked by a star.