BBC: Blead Breaks Spreadsheet::WriteExcel

[cjg-cguevara]

This is a bug report for perl from "Carlos Guevara" [email protected],
generated with the help of perlbug 1.43 running under perl 5.41.8.

---

BBC: Blead Breaks Spreadsheet::WriteExcel

Please see http://fast-matrix.cpantesters.org/?dist=Spreadsheet::WriteExcel

---

Flags

• category=core
• severity=low

---

Perl configuration

Site configuration information for perl 5.41.8:

Configured by cpan at Tue Jan 14 00:11:14 EST 2025.

Summary of my perl5 (revision 5 version 41 subversion 8) configuration:
  Commit id: 61978476912ee303cc78e7bf09602a4b38f3d75e
  Platform:
    osname=linux
    osvers=5.14.0-503.21.1.el9_5.x86_64
    archname=x86_64-linux
    uname='linux cjg-rhel9 5.14.0-503.21.1.el9_5.x86_64 #1 smp preempt_dynamic thu dec 19 09:37:00 est 2024 x86_64 x86_64 x86_64 gnulinux '
    config_args='-des -Dprefix=/home/cpan/bin/perl -Dscriptdir=/home/cpan/bin/perl/bin -Dusedevel -Duse64bitall'
    hint=recommended
    useposix=true
    d_sigaction=define
    useithreads=undef
    usemultiplicity=undef
    use64bitint=define
    use64bitall=define
    uselongdouble=undef
    usemymalloc=n
    default_inc_excludes_dot=define
  Compiler:
    cc='cc'
    ccflags ='-fwrapv -fno-strict-aliasing -pipe -fstack-protector-strong -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_FORTIFY_SOURCE=2'
    optimize='-O2'
    cppflags='-fwrapv -fno-strict-aliasing -pipe -fstack-protector-strong -I/usr/local/include'
    ccversion=''
    gccversion='11.5.0 20240719 (Red Hat 11.5.0-2)'
    gccosandvers=''
    intsize=4
    longsize=8
    ptrsize=8
    doublesize=8
    byteorder=12345678
    doublekind=3
    d_longlong=define
    longlongsize=8
    d_longdbl=define
    longdblsize=16
    longdblkind=3
    ivtype='long'
    ivsize=8
    nvtype='double'
    nvsize=8
    Off_t='off_t'
    lseeksize=8
    alignbytes=8
    prototype=define
  Linker and Libraries:
    ld='cc'
    ldflags =' -fstack-protector-strong -L/usr/local/lib'
    libpth=/usr/local/lib /usr/lib /usr/lib64 /usr/local/lib64
    libs=-lpthread -ldb -ldl -lm -lcrypt -lutil -lc
    perllibs=-lpthread -ldl -lm -lcrypt -lutil -lc
    libc=/lib/../lib64/libc.so.6
    so=so
    useshrplib=false
    libperl=libperl.a
    gnulibc_version='2.34'
  Dynamic Linking:
    dlsrc=dl_dlopen.xs
    dlext=so
    d_dlsymun=undef
    ccdlflags='-Wl,-E'
    cccdlflags='-fPIC'
    lddlflags='-shared -O2 -L/usr/local/lib -fstack-protector-strong'


---
@INC for perl 5.41.8:
    /home/cpan/bin/perl/lib/site_perl/5.41.8/x86_64-linux
    /home/cpan/bin/perl/lib/site_perl/5.41.8
    /home/cpan/bin/perl/lib/5.41.8/x86_64-linux
    /home/cpan/bin/perl/lib/5.41.8

---
Environment for perl 5.41.8:
    HOME=/home/cpan
    LANG=en_US.UTF-8
    LANGUAGE (unset)
    LC_ALL=C
    LD_LIBRARY_PATH (unset)
    LOGDIR (unset)
    PATH=/home/cpan/bin/perl/bin:/home/cpan/bin:/usr/share/Modules/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin
    PERL_BADLANG (unset)
    SHELL=/bin/bash

[jkeenan]

Examination of some of the locations* in CPANtesters failure reports suggests that the FAILs are due to the same substr-related change in blead cited in #22914.

• Some URLs:
  https://metacpan.org/release/JMCNAMARA/Spreadsheet-WriteExcel-2.40/source/t/50_name_stored.t#L336
  https://metacpan.org/release/JMCNAMARA/Spreadsheet-WriteExcel-2.40/source/t/52_name_print_titles.t#L528

We're less than a week away from a development release. I would suggest reverting cdbed2a so that we can focus on other problems in the meantime.

[jkeenan]

Examination of some of the locations* in CPANtesters failure reports suggests that the FAILs are due to the same substr-related change in blead cited in #22914.

* Some URLs:
  https://metacpan.org/release/JMCNAMARA/Spreadsheet-WriteExcel-2.40/source/t/50_name_stored.t#L336
  https://metacpan.org/release/JMCNAMARA/Spreadsheet-WriteExcel-2.40/source/t/52_name_print_titles.t#L528

We're less than a week away from a development release. I would suggest reverting cdbed2a so that we can focus on other problems in the meantime.

Same breakage point as #22914:

cdbed2a40eb1292d5be2fd59c091cf78f6a4be69 is the first bad commit
commit cdbed2a40eb1292d5be2fd59c091cf78f6a4be69
Author: Richard Leach <[email protected]>
Date:   Tue Nov 19 23:02:37 2024 +0000

    OP_SUBSTR_LEFT - a specialised OP_SUBSTR variant

@richardleach ^^

[richardleach]

Local testing suggests this should be fixed by b1397c4