ODBC ownership tweak on database-list-{tables,views}

Nathan Bird <[email protected]>
Newsgroups gmane.lisp.clsql.general
Message-ID <[email protected]>
I've committed a change in the development branch that changes how
ownership is treated on the ODBC backend. The most important aspect of
this is that I can run the test suites on SqlServer 2000,2005. If anyone
using ODBC can confirm this doesn't cause any problems that would be nice.

Since ODBC doesn't expose the owner we now use that parameter to filter
on schema since that's what tends to be exposed. Some DBs like mssql
2000 conflate the two so at least there it works nicely.  These
functions now strip out all the system tables that I know about for
those two which makes it match the clsql docs of  "only returning user
tables if no owner is specified."

I don't yet have a sqlserver2008 or Access system setup so there may be
other system tables on those two that need to be ignored. If anyone that
has those could run on an empty database
(clsql:list-views)
(clsql:list-tables)
and report any system tables that it is still returning that would be handy.


The test suites still have a lot of failures on those backends... but we
can whittle now.


To get a copy of the development branch:

#clone the repo, skip this if you already have it.
git clone git://git.b9.com/clsql.git
cd clsql
#create and checkout a new branch 'development' based on the origin's.
git checkout -b development origin/development
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.