perl 5.40.1 build: Possibly DBD::ODBC test t/sql_type_cast.t will fail

[twata1]

Hello,

I split my issue with #231 .

DBI version 1.647 has been bundled with Strawberry-5.40.1 (strawberry-perl-5.40.1.1-64bit-portable-(dev_5401_20250124_gcc13)) from the beginning.

DBD::ODBC test t/sql_type_cast.t will possibly fail when using DBI 1.647 (with SQL Server).

Sample fail report:
http://www.cpantesters.org/cpan/report/d11a1314-6d16-1014-9bdd-e0ea5edf87b7

It seems to me that DBD::ODBC test t/sql_type_cast.t passes when using DBI 1.645.

Sample pass report:
http://www.cpantesters.org/cpan/report/0cf58f01-6d36-1014-9c04-8cf72b64d347

Thank you,

[shawnlaffan]

I've just tested locally with the SP 5.40.2.1 beta release and that test is skipped because $ENV{DBI_DSN} is undefined. What should this be set to so the test is triggered? Better yet, can you test locally with the beta release?

[twata1]

What should this be set to so the test is triggered?

After running portableshell.bat, perform the following on the prompt.

set DBI_DSN=dbi:ODBC:Data:DSN
set DBI_USER=user name
set DBI_PASS=password

However, it is difficult to say in a few words as there are other settings that have to be set up.

Better yet, can you test locally with the beta release?

Yes. I am now in the process of preparing for the test. Please wait for a while now.

[twata1]

Test results
The values of variables DBI_DSN, DBI_USER and DBI_PASS are masked.

With DBI 1.647:

C:\home\boxmandev002>perl -v

This is perl 5, version 40, subversion 2 (v5.40.2) built for MSWin32-x64-multi-thread

Copyright 1987-2025, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl".  If you have access to the
Internet, point your browser at https://www.perl.org/, the Perl Home Page.


C:\home\boxmandev002>set DBI_DSN=dbi:ODBC:********

C:\home\boxmandev002>set DBI_USER=********

C:\home\boxmandev002>set DBI_PASS=********

C:\home\boxmandev002>perl -MV=DBI
DBI
        C:\strawberry-perl-5.40.2.1-beta1-64bit-portable\perl\vendor\lib\DBI.pm: 1.647

C:\home\boxmandev002>cpanm DBD::ODBC
DBD::ODBC is up to date. (1.61)

C:\home\boxmandev002>cpanm --test-only DBD::ODBC
--> Working on DBD::ODBC
Fetching http://www.cpan.org/authors/id/M/MJ/MJEVANS/DBD-ODBC-1.61.tar.gz ... OK
Configuring DBD-ODBC-1.61 ... OK
Building and testing DBD-ODBC-1.61 ... FAIL
! Testing DBD::ODBC failed. See C:\home\BOXMAN~2\.cpanm\work\1745415548.16548\build.log for details. Retry with --force to force i
nstall it.

C:\home\boxmandev002>

Build log:
DBD-ODBC-1.61-build-with-DBI-1.647.log

With DBI 1.645:

C:\home\boxmandev002>cpanm DBI@1.645
--> Working on DBI
Fetching http://backpan.perl.org/authors/id/H/HM/HMBRAND/DBI-1.645.tgz ... OK
Configuring DBI-1.645 ... OK
Building and testing DBI-1.645 ... OK
Successfully installed DBI-1.645 (downgraded from 1.647)
1 distribution installed

C:\home\boxmandev002>perl -MV=DBI
DBI
        C:\strawberry-perl-5.40.2.1-beta1-64bit-portable\perl\site\lib\DBI.pm: 1.645
        C:\strawberry-perl-5.40.2.1-beta1-64bit-portable\perl\vendor\lib\DBI.pm: 1.647

C:\home\boxmandev002>cpanm --test-only DBD::ODBC
--> Working on DBD::ODBC
Fetching http://www.cpan.org/authors/id/M/MJ/MJEVANS/DBD-ODBC-1.61.tar.gz ... OK
Configuring DBD-ODBC-1.61 ... OK
Building and testing DBD-ODBC-1.61 ... OK
Successfully tested DBD-ODBC-1.61

C:\home\boxmandev002>

Build log:
DBD-ODBC-1.61-build-with-DBI-1.645.log

Thank you,

[shawnlaffan]

Thanks @twata. I'll drop DBI back to 1.645 in the SP build config.

[shawnlaffan]

The most recent build configs for 5.38, 5.40 and 5.42 are using DBI 1.645.

This issue is probably closable unless we are able to upgrade to a newer version.