IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Or you didn't double-check enough
Post #258,191
by ben_tilly
6/8/06 2:50:14 PM
Reply
New Or you didn't double-check enough
Logic errors are the hardest kind of bugs to find.

Depending on the implementation, if you were trying it in an example like the above on a table that had been filled in sequentially, it might frequently pick the minimum row. So it would look like it was doing something, even when it wasn't.

Cheers,
Ben
I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Post #258,205
by drewk
Picture of drewk
6/8/06 4:17:32 PM
Reply
New Also possible
Though it was long enough ago that I can't even remember a representative example. I'll chalk that up as "something I may have gotten away with". It wouldn't be the only thing.
===

Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
     Left Outer Join question - (ChrisR) - (20) - June 7, 2006, 10:26:29 PM EDT
         One approach - (ben_tilly) - (6) - June 8, 2006, 01:13:51 PM EDT
             Some variation on MIN... - (ChrisR) - (3) - June 8, 2006, 11:10:15 AM EDT
                 It probably will not optimize - (ben_tilly) - (2) - June 8, 2006, 01:27:27 PM EDT
                     Yep, took forever to run. - (ChrisR) - (1) - June 8, 2006, 02:00:51 PM EDT
                         Nothing non-standard about that - (drewk) - June 8, 2006, 02:40:14 PM EDT
             Pre indentation - (ChrisR) - (1) - June 8, 2006, 02:02:57 PM EDT
                 Bug, indentation can be lost during edits (new thread) - (ben_tilly) - June 8, 2006, 02:18:49 PM EDT
         Does SQL Server support "DISTINCT ON"? - (drewk) - (12) - June 8, 2006, 08:55:49 AM EDT
             That is really what I need! - (ChrisR) - June 8, 2006, 10:56:50 AM EDT
             The more readable version is invalid (at least in Oracle) - (ben_tilly) - (10) - June 8, 2006, 01:12:25 PM EDT
                 Hmm, both Postgres and MySQL support the same non-standard? - (drewk) - (9) - June 8, 2006, 01:49:01 PM EDT
                     Can you please help me find mine? - (folkert) - June 8, 2006, 02:04:49 PM EDT
                     That is a MySQL shortcut - (ben_tilly) - (7) - June 8, 2006, 02:14:38 PM EDT
                         Not surprising - (drewk) - (2) - June 8, 2006, 02:42:46 PM EDT
                             Or you didn't double-check enough - (ben_tilly) - (1) - June 8, 2006, 02:50:14 PM EDT
                                 Also possible - (drewk) - June 8, 2006, 04:17:32 PM EDT
                         I've encountered that problem. - (static) - (3) - June 8, 2006, 08:48:27 PM EDT
                             Justifiable arrogance in many cases - (ben_tilly) - (2) - June 8, 2006, 09:18:47 PM EDT
                                 Oh I have little doubt about that. - (static) - (1) - June 8, 2006, 09:35:59 PM EDT
                                     Oracle is picky but... - (ben_tilly) - June 8, 2006, 10:03:53 PM EDT

...and if a hundred!
65 ms