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