Joe Wilson <[EMAIL PROTECTED]> wrote: > > So few lines of code are changed by the patch that one could easily > add a new PRAGMA to have the old compound SELECT behavior to be the > default. If a database is explicitly created or altered with the new > PRAGMA setting, it could have the new behavior, i.e.: >
My goal is to keep SQLite simple. It is already way more complex than it needs to be. Adding new pragma settings is going in the wrong direction. A great way to measure the complexity of a library, I am discovering, it to attempt to write detailed specifications describing exactly what the library does. The preferred way of doing this is a set of "requirements". Each requirement consists of a single sentence which makes a statement of about the behavior of the library which is always try. A good interface has simple and easy to understand requirements. Every time you add a new mode setting, you have to go through and duplicate lots of requirements and add conditional clauses to each requirement. Consider the task of writing requirements that describes the how ORDER BY terms are matched to column names in a compound SELECT. Those requirements are already going to be numerious and complex enough without doubling the number and adding an "if the database is [not] in the legacy mode" clause to the beginning of each one. Joe, I appreciate your desire to help. But adding complexity is not helping. If you want to be helpful without adding complexity, consider writing up a paragraph or two about how the current ORDER BY matching works and how it ought to work. Be precise, unambiguous, and consise. If you can write formal requirements instead of prose, that would be even better. Once we can state clearly and consisely exactly what SQLite ought to do, it will be relatively simple to make it actually do that. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
