[Dbix-class] Sybase ASE 15.7 Issue: Quoted Identifiers and compound SQL statements

[Phillip Moore]

On Fri, Jan 11, 2013 at 11:30 AM, Peter Rabbitson <rabbit+dbic at rabbit.us> wrote:
> Please in the future make additions to the DBIC test suite itself.
> The mini-distro you submitted may be demonstrating the problem, but
> can not be included in DBIC as-is. Basically submitting additions to
> the DBIC suite directly will cut on duble work.

Once we figure out the problem, obviously a new set of test suite
entries will make sense.

But the problem in implementing a generic test for the use of
quoted_identifiers will require a Sybase server (or database, more
correctly I think) that is configured to support them.   I have no
idea how you query this via the client API, and that's really a
requirement before you can add these tests.   I do know that you can't
use quoted_identifiers unless the database supports them (I had to
turn them on using sp_configure before they would work at all).

Doing the right thing in the test suite is more complex than the
simple test case I have.

I would assume there's a straight forward way to query the server
configuration, but I don't know how to do it, and couldn't find the
explanation.   Once that is known, then adding additional tests for
these cases should be straight forward.