[php-maint] Bug#769127: Bug#769127: php5-odbc: last digit missing and being replaced by something that looked like 2 Zerobytes

[Ondřej Surý]

Control: severity -1 important

Hi Kurt,

this looks like this:

https://github.com/php/php-src/commit/df9078ea55e2bd60d718c6e6948b70311650fe39

It would be helpful if you can apply this patch and rebuild your PHP to
confirm the patch fixes your issue. Or I can publish upcoming 5.4.35
with this patch to you somewhere, so you can install them and confirm
the bug is fixed before we push this to wheezy.

Cheers,
Ondrej

On Tue, Nov 11, 2014, at 16:33, kurt kuene wrote:
> Package: php5-odbc
> Version: 5.4.34-0+deb7u1
> Severity: critical
> Justification: causes serious data loss
> 
> Dear Maintainer,
> 
> we used it to connect to a sql server 2012
> 
> /etc/freetds/freetds.conf: unmodified
> 
> we used the following dsn to connect:
> "DRIVER=TDS;TEXTSIZE=4096000;DATABASE=example;SERVER=db.example.com;PORT=1234"
> 
> we connect using this method:
> odbc_pconnect()
> 
> we sent the following sql statements to configure our db link:
> set dateformat ymd; 
> set textsize 4096000;
> set concat_null_yields_null on;
> set ansi_nulls on;
> set ansi_null_dflt_on on;
> set ansi_padding on;
> set implicit_transactions off;
> set quoted_identifier on
> 
> we encountered strange results when querying a db view:
> 
> Q1 (query 1): "select * from example_view"
> Q2 (query 2): "select id from example_view"
> 
> the view "example_view" contains an INT field named "id".
> 
> the result of Q1:
> the ID field was returned with the last digit missing and being replaced
> by something that looked like 2 Zerobytes \0\0
> 
> the result of Q2:
> the ID field was returned correctly.
> 
> 
> 
> -- System Information:
> Debian Release: 7.7
>   APT prefers stable
>   APT policy: (900, 'stable'), (700, 'oldstable')
> Architecture: i386 (i686)
> 
> Kernel: Linux 2.6.32-26-pve (SMP w/24 CPU cores)
> Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
> Shell: /bin/sh linked to /bin/dash
> 
> Versions of packages php5-odbc depends on:
> ii  dpkg                                       1.16.15
> ii  libapache2-mod-php5 [phpapi-20100525+lfs]  5.4.34-0+deb7u1
> ii  libc6                                      2.13-38+deb7u6
> ii  libodbc1                                   2.2.14p2-5
> ii  php5-cli [phpapi-20100525+lfs]             5.4.34-0+deb7u1
> ii  php5-common                                5.4.34-0+deb7u1
> ii  ucf                                        3.0025+nmu3
> ii  unixodbc                                   2.2.14p2-5
> 
> php5-odbc recommends no packages.
> 
> php5-odbc suggests no packages.
> 
> -- no debconf information
> 
> _______________________________________________
> pkg-php-maint mailing list
> pkg-php-maint at lists.alioth.debian.org
> http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-php-maint


-- 
Ondřej Surý <ondrej at sury.org>
Knot DNS (https://www.knot-dns.cz/) – a high-performance DNS server