On Dec 7, 2007, at 11:47 PM, Joe Wilson wrote:
I believe it makes compound query behavior more compatible with other
popular databases. It is mostly backwards compatible with the previous
syntax and only 2 tests performed by "make test" had to be altered.
Compatibility with other databases is good. But backwards compatibility
with the thousands and thousands of existing SQLite applications is more
important. The current behavior of SQLite regarding the column names
in compound SELECTs may be boneheaded and broken. But it does at
least have the virtue of being backwards compatible with all prior
releases
of SQLite. So a project can update the version of SQLite they are using
to the latest code out of CVS and be reasonable confident that it
will still
work.
If I put in this patch, that confidence is diminished somewhat.
Hence I am moving very slowly and cautiously here.
D. Richard Hipp
[EMAIL PROTECTED]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------