With clsql-4.0.4-r1, 99 of 233 tests fail with mysql-community-5.1.34 (from #194561), all of which used to pass with the 5.0 series. The URL has a patch (which is not mine) that I'll attach here, which fixes this, making all tests pass successfully. I tested it with sbcl-1.0.28. Reproducible: Always Steps to Reproduce: 1. emerge clsql 2. add clsql test database to mysql 3. in ~/.clsql-test.config, put ((:mysql ("localhost" "database" "user" "password"))) as appropriate 4. run in sbcl: (asdf:operate 'asdf:load-op 'clsql-mysql) and (asdf:operate 'asdf:test-op 'clsql) Actual Results: 99 out of 233 total tests failed: :BASIC/TYPE/1, :BASIC/TYPE/2, :BASIC/SELECT/1, :BASIC/SELECT/2, :BASIC/SELECT/3, :BASIC/MAP/3, :BASIC/DO/2, :BASIC/BIGINT/1, :FDDL/VIEW/3, :FDDL/VIEW/4, :FDDL/BIG/1, :FDML/INSERT/1, :FDML/INSERT/2, :FDML/INSERT/3, :FDML/INSERT/4, :FDML/UPDATE/1, :FDML/UPDATE/2, :FDML/QUERY/1, :FDML/QUERY/2, :FDML/QUERY/6, :FDML/SELECT/3, :FDML/SELECT/4, :FDML/SELECT/5, :FDML/SELECT/6, :FDML/SELECT/7, :FDML/SELECT/9, :FDML/SELECT/10, :FDML/SELECT/11, :FDML/SELECT/12, :FDML/SELECT/13, :FDML/SELECT/15, :FDML/SELECT/17, :FDML/SELECT/18, :FDML/SELECT/20, :FDML/SELECT/21, :FDML/SELECT/27, :FDML/SELECT/28, :FDML/SELECT/29, :FDML/SELECT/30, :FDML/SELECT/31, :FDML/SELECT/33, :FDML/SELECT/34, :FDML/SELECT/35, :FDML/SELECT/36, :FDML/DO-QUERY/1, :FDML/MAP-QUERY/1, :FDML/MAP-QUERY/2, :FDML/MAP-QUERY/3, :FDML/MAP-QUERY/4, :FDML/LOOP/1, :FDML/TRANSACTION/1, :FDML/TRANSACTION/2, :OODDL/JOIN/1, :OODDL/JOIN/2, :OODDL/JOIN/3, :OODDL/TIME/1, :OODDL/TIME/2, :OODDL/TIME/3, :OODML/SELECT/1, :OODML/SELECT/2, :OODML/SELECT/3, :OODML/SELECT/4, :OODML/SELECT/5, :OODML/SELECT/6, :OODML/SELECT/7, :OODML/SELECT/8, :OODML/SELECT/9, :OODML/SELECT/10, :OODML/SELECT/11, :OODM/RETRIEVAL/1, :OODM/RETRIEVAL/2, :OODM/RETRIEVAL/3, :OODM/RETRIEVAL/4, :OODM/RETRIEVAL/5, :OODM/RETRIEVAL/6, :OODM/RETRIEVAL/7, :OODM/RETRIEVAL/8, :OODM/RETRIEVAL/9, :OODML/UPDATE-RECORDS/1, :OODML/UPDATE-RECORDS/2, :OODML/UPDATE-RECORDS/3, :OODML/UPDATE-INSTANCE/1, :OODML/DO-QUERY/1, :OODML/DO-QUERY/2, :OODML/MAP-QUERY/1, :OODML/MAP-QUERY/2, :OODML/ITERATION/3, :OODML/CACHE/1, :OODML/CACHE/2, :OODML/REFRESH/1, :OODML/REFRESH/2, :OODML/REFRESH/3, :OODML/REFRESH/4, :OODML/UOJ/1, :OODML/FLOAT/1, :OODML/FLOAT/2, :OODML/FLOAT/3, :OODML/FLOAT/4, :OODML/FLOAT/5. Tests skipped: FDDL/OWNER/1 table ownership not supported FDML/QUERY/5 not supported by mysql FDML/QUERY/7 not supported by mysql FDML/QUERY/8 not supported by mysql FDML/SELECT/1 fancy math not supported FDML/SELECT/22 not supported by mysql FDML/SELECT/26 string table aliases not supported on all mysql versions Expected Results: ****************************************************************************** *** CLSQL Test Suite begun at 2009-05-31 11:29:18.000000 *** SBCL *** 1.0.28-gentoo on X86 *** Database MYSQL backend. ****************************************************************************** Doing 233 pending tests of 233 tests total. [...] No tests failed. Tests skipped: FDDL/OWNER/1 table ownership not supported FDML/QUERY/5 not supported by mysql FDML/QUERY/7 not supported by mysql FDML/QUERY/8 not supported by mysql FDML/SELECT/1 fancy math not supported FDML/SELECT/22 not supported by mysql FDML/SELECT/26 string table aliases not supported on all mysql versions
Created attachment 193048 [details, diff] the patch from the URL Simply adding the epatch line right under 'unpack ${A}' in the dev-lisp/clsql-4.0.4-r1.ebuild works for me.
Hi there, I don't know if this is an issue for the lisp devs, but the overlay isn't hosted on either of git.overlays.gentoo.org or overlays.gentoo.org. The only information pertaining to bugs (from "layman -i lisp") says "Support and feedback in `#gentoo-lisp' and via `gentoo-lisp@gentoo.org'" (which gentoo-lisp is a mailing list), so it's not clear whether this bug belongs here or not. @lisp-devs - If bugs for the overlay are supposed to be filed here, please could you update the layman information to say so, and potentially change the contact address to common-lisp@g.o to make it easier for the wranglers to figure out where to file these, or if they're not, please make that fact more explicit...
Fixed in the overlay. Thanks
Thanks for your report Janos. In the future, please talk to us on irc or gentoo-lisp mailing list before filing bugs.