Bug #48908 [Com]: Cannot query smalldatetime type columns

Edit report at https://bugs.php.net/bug.php?id=48908&edit=1 ID: 48908 Comment by: Fr33z3m4n at gmx dot net Reported by: aaron at aarondm dot com Summary: Cannot query smalldatetime type columns Status: Open Type: Bug Package: MSSQL related Operating System: ArchLinux PHP Version: 5.2.10 Block user comment: N Private report: N New Comment: Same Problem and is reproducable. Debian 2.6.26-26lenny1 PHP Version 5.3.6-12 Zend Engine v2.3.0, Copyright (c) 1998-2011 Zend Technologies with Suhosin v0.9.32.1, Copyright (c) 2007-2010, by SektionEins GmbH Previous Comments: ------------------------------------------------------------------------ [2010-07-20 11:51:29] tom dot lawton at kondor dot co dot uk PHP 5.2.4 / ubuntu 8.10LTS has this bug and is reproducable. Suhosin patch reports canary mismatch if a query returns smalldatetime. Apache does not trigger 500, nor does PHP report any error to the page - it dies silently. ------------------------------------------------------------------------ [2010-01-07 12:36:21] undicizeri at gmail dot com Same bug here. I'm using Ubuntu with php 5.2.6 and debian with php 5.2.12. ------------------------------------------------------------------------ [2009-12-21 11:22:41] php at mike2k dot com Sample query/workaround: old: SELECT acct_itm.cre_dtm AS cre_dtm new: SELECT CONVERT(varchar(10),acct_itm.cre_dtm,120) AS cre_dtm Not the most ideal. Might be a bug in the FreeTDS driver and not something PHP can handle but has to pass upstream. ------------------------------------------------------------------------ [2009-12-21 10:13:22] php at mike2k dot com Always repeatable. This is an issue for us as well. The previous comment is from a Windows user so they're probably able to leverage more native Windows MSSQL libraries... PHP 5.2.11, on Linux, using FreeTDS on CentOS 5.3 (or 5.4, not sure) x86_64 The workaround is having to cast the column inside of the query. I will try to post an example workaround query when I grab one from the dev team. Related Packages/versions of the driver, just in case: freetds-devel-0.64-11.el5.centos freetds-devel-0.64-6.el5 freetds-0.64-11.el5.centos freetds-0.64-6.el5 unixODBC-2.2.11-7.1 (32 bit) unixODBC-2.2.11-7.1 (64 bit) unixODBC-devel-2.2.11-7.1 (32 bit) unixODBC-devel-2.2.11-7.1 (64 bit) ------------------------------------------------------------------------ [2009-07-16 16:14:14] aaron at aarondm dot com I have run the same query on Windows Server 2003 (Enterprise Edition) and this does not seem to be an issue. On windows it is able to fetch the column data with no problems. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=48908 -- Edit this bug report at https://bugs.php.net/bug.php?id=48908&edit=1