Miscellaneous bugfixes (primarily ODBC)

Nathan Bird <[email protected]> Mon, 20 Jun 2011 17:10:16 -0400
Newsgroups gmane.lisp.clsql.general
Message-ID <[email protected]>
I've just posted in the master branch
  * Numerous fixes to the ODBC backend
   * Support LIMIT (mssql uses TOP N instead of LIMIT N)
   * handle column precision problems for mssql backends
   * handle IDENTITY as a column constraint
   * bigint support works with at least postgres (8.4) and mssql 200{0,5}

  * listify was broken when called with nil (which is both an atom and a
list)

  * Fixes to some tests that had invalid where expressions in oodml/select

  * Made parse-timestring and parse-datestring handle already parsed values
    rather than erroring on types other than string

  * Incorporate Ryszard Szopa's patch for functional expression in :order by

We've been using these patches in our production systems for years (some
of this is as old as 2007).

Backwards compatibility: The only problem we forsee is if you are using
bigints right now and expect the return value to be a string rather than
a numeric type.

If you think these patches might effect you, please pull from the git
repo[1] and give it a try. Otherwise we'll officially release this in a
week or so.

[1] http://git.b9.com/clsql.git


Cheers,
Nathan Bird