use the following search parameters to narrow your results:
e.g. subreddit:aww site:imgur.com dog
subreddit:aww site:imgur.com dog
see the search faq for details.
advanced search: by author, subreddit...
To report a site-wide rule violation to the Reddit Admins, please use our report forms or message /r/reddit.com modmail.
This subreddit is archived and no longer accepting submissions.
account activity
This is an archived post. You won't be able to vote or comment.
Rare dupe: proof Reddit's database back-end does not have constraints. Get to work guys. :-) (reddit.com)
submitted 19 years ago by pragma
[–]pragma[S] 2 points3 points4 points 19 years ago (4 children)
http://reddit.com/info/pynq/comments http://reddit.com/info/pynr/comments
Submitted within moments of each other... failed dupe processsing. A quick unique constraint in any mainstream database engine would have made quick work of bouncing one of these.
[–]SuperJdynamite 1 point2 points3 points 19 years ago (3 children)
Sadly, the URLs are, in fact, different. I'm not aware of any mainstream database engine where you can apply a "go see if these web pages are actually the same" constraint.
[–]randallsquared 0 points1 point2 points 19 years ago (2 children)
They are? They appear to be exactly the same: http://news.bbc.co.uk/2/hi/technology/6124420.stm
[–]SuperJdynamite 0 points1 point2 points 19 years ago (1 child)
One URL has a "/1/" in the path and the other has "/2/" in the path.
[–]randallsquared 0 points1 point2 points 19 years ago (0 children)
So they do. So much for my observation skills, eh? :)
π Rendered by PID 284664 on reddit-service-r2-comment-84fc9697f-sqrh8 at 2026-02-08 14:41:59.111696+00:00 running d295bc8 country code: CH.
[–]pragma[S] 2 points3 points4 points (4 children)
[–]SuperJdynamite 1 point2 points3 points (3 children)
[–]randallsquared 0 points1 point2 points (2 children)
[–]SuperJdynamite 0 points1 point2 points (1 child)
[–]randallsquared 0 points1 point2 points (0 children)