Timeline for Finding violations of the symmetry constraint
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 28, 2012 at 21:01 | history | tweeted | twitter.com/#!/StackDBAs/status/262660503229317120 | ||
| Oct 28, 2012 at 20:29 | vote | accept | max | ||
| Oct 28, 2012 at 19:08 | history | edited | A-K |
edited tags
|
|
| Oct 28, 2012 at 19:07 | answer | added | A-K | timeline score: 4 | |
| Oct 28, 2012 at 18:58 | comment | added | a1ex07 | @max: Then I guess Stuart Moore's approach should work for you to identify such cases. To prevent them in the future, I'd create a stored procedure that inserts/deletes 2 records within one transaction, and limit write access to the table , so only this procedure can write into it. | |
| Oct 28, 2012 at 17:44 | history | edited | max | CC BY-SA 3.0 |
added 180 characters in body
|
| Oct 28, 2012 at 17:42 | comment | added | max | @a1ex07: thx, didn't realize I was imprecise. I only want to find the cases where "a pair of friends shows only once". Updated the question. | |
| Oct 28, 2012 at 14:58 | comment | added | a1ex07 |
@max: Can you post Friends table definition? "Data errors" is quite vague ; I can think about many types of them (Friend1Id=Friend2Id, any of Friend ids is null, no corresponding row in parent table (say Person/User etc), more than 1 row with the same Friend1Id+Friend2Id, a pair of friends shows only once) ?
|
|
| Oct 28, 2012 at 13:18 | comment | added | Stuart Moore | That makes 2 of us. I'm fine with being told I'm wrong, but it would be nice to know what I was wrong about so I can learn from it. | |
| Oct 28, 2012 at 11:36 | comment | added | max | Can anyone explain why both my question and @Stuart Moore answer are downvoted? It's my first post on dba.stackexchange, so I'd like to understand the rules. | |
| Oct 28, 2012 at 10:28 | answer | added | Stuart Moore | timeline score: 5 | |
| Oct 28, 2012 at 9:04 | review | First posts | |||
| Oct 28, 2012 at 11:33 | |||||
| Oct 28, 2012 at 8:48 | history | asked | max | CC BY-SA 3.0 |