On Mon, 2003-03-24 at 11:48, [EMAIL PROTECTED] wrote:
> All
>
> Before submitting the following issue as a bug report,
> I wanted to run it by this list, in order to:
>
> a) Check that I am not missing something.
> b) Get an opinion on whether the issue is with DBI or DBD::Sybase.
>
> select "foo " from master..sysengines
> select "foo " order by 1
> select "foo " from master..sysengines order by 1
> ======================================
>
> (having replaced {server}, {user} and {pwd}, obviously)
>
> I get the following output:
> ======================================
> SQL: select "foo " from master..sysengines
> DATA: *foo *
>
> SQL: select "foo " order by 1
> DATA: *foo *
>
> SQL: select "foo " from master..sysengines order by 1
> DATA: *foo*
> ======================================
This isn't DBI, and it isn't DBD::Sybase. The last query probably
creates a work table, where "foo " is treated as a varchar, which causes
the trailing whitespace to be removed. You could check this assumption
by turning on showplan.
Michael
--
Michael Peppler Data Migrations, Inc.
[EMAIL PROTECTED] http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html
