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

[Phillip Moore]

Actually, wait a sec..... it's not that bad at all now that I think
about it a bit more.

First of all, none of the Sybase tests are run unless the installer
setups a test database, and exports the DBICTEST_* env vars to refer
to it.   Therefore, SOME administrative action is required on before
these tests are useful at all.   So, there's no reason that person
can't TELL the test suite whether or not the database uses
quoted_identifiers, perhaps via another env var, say:

export DBICTEST_SYBASE_TEST_QUOTED_IDENTIFIERS=1

or something less ugly.    IOW, if there isn't a way to query that
information dynamically, we can just code the tests so that it has to
be asserted.

Having said that, I suspect it's possible to make that query, I just
don't know how (yet -- haven't looked).   But the point here is that
even if such a query isn't feasible, we can still implement tests for
these cases without it.

If we can figure out the root cause, and find a fix, then I am also
happy to make sure that the code continues working on Sybase, since
I'm going to end up with a mission critical dependency on it.   Either
that, or I have to make this work with the other option my employer
gave me: DB2 :-(

On Fri, Jan 11, 2013 at 11:58 AM, Peter Rabbitson <rabbit+dbic at rabbit.us> wrote:
> On Fri, Jan 11, 2013 at 11:56:31AM -0500, Phillip Moore wrote:
>> 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).
>
> Head explodes... Ok, noted.
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk