Fwd: SQL info,plus comments- Alaska GEMS

From: Kathy Dopp <kathy_dot_dopp_at_gmail_dot_com>
Date: Sat Oct 07 2006 - 15:45:31 CDT

I thought Dan wouldn't mind my forwarding his email regaring his examination
of the Diebold GEMs database. I hope not.

---------- Forwarded message ----------
From: Dan Lyons <socal_dan2000@yahoo.com>
Date: Oct 7, 2006 1:24 PM
Subject: Re: SQL info,plus comments- Alaska GEMS

Looking through their queries... it's worth noting
that their extremely sizable ones could easily be
shortened.

Say I wrote the statement:

WHERE A=B and C=D and E=F and (G=H or I=J)

Instead, they write the logically equivalent, but much
longer (and more prone to error) statement:

WHERE (A=B and C=D and E=F and G=H) or
      (A=B and C=D and E=F and I=J)

Now, if you imagine three statements in the "or"
clause... you can see what they're doing.

It reminds me of the International Obfuscated C Code
Contest, in which contest entries are judged by being
the most difficult code to read:
http://www.ioccc.org/main.html

_______________________________________________
OVC-discuss mailing list
OVC-discuss@listman.sonic.net
http://lists.sonic.net/mailman/listinfo/ovc-discuss

==================================================================
= The content of this message, with the exception of any external
= quotations under fair use, are released to the Public Domain
==================================================================
Received on Tue Oct 31 23:17:04 2006

This archive was generated by hypermail 2.1.8 : Tue Oct 31 2006 - 23:17:10 CST