[PHP-BUG] Bug #65738 [NEW]: Column metadata for datetimeoffset is incorrect
From: chriskl
Operating system: Debian 7.1
PHP version: 5.5.4
Package: MSSQL related
Bug Type: Bug
Bug description:Column metadata for datetimeoffset is incorrect
Description:
When using getColumnMeta() on pdo_dblib, on a column of type
'datetimeoffset(0)', the returned structure looks like this:
array(10) {
["max_length"] => int(104)
["precision"] => int(0)
["scale"] => int(0)
["column_source"] => string(7) "updated"
["native_type"] => string(4) "char"
["native_type_id"] => int(47)
["native_usertype_id"] => int(0)
["name"] => string(7) "updated"
["len"] => int(104)
["pdo_type"] => int(2)
}
Note that it believes that the native_type is char, when it should be
'datetimeoffset'.
Expected result:
I expect to see 'datetimeoffset' as the native_type.
Actual result:
--
You get 'char' - which is incorrect.
--
Edit bug report at https://bugs.php.net/bug.php?id=65738&edit=1
--
Try a snapshot (PHP 5.4):
https://bugs.php.net/fix.php?id=65738&r=trysnapshot54
Try a snapshot (PHP 5.3):
https://bugs.php.net/fix.php?id=65738&r=trysnapshot53
Try a snapshot (trunk):
https://bugs.php.net/fix.php?id=65738&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=65738&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=65738&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=65738&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=65738&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=65738&r=oldversion
Not developer issue:https://bugs.php.net/fix.php?id=65738&r=support
Expected behavior: https://bugs.php.net/fix.php?id=65738&r=notwrong
Not enough info:
https://bugs.php.net/fix.php?id=65738&r=notenoughinfo
Submitted twice:
https://bugs.php.net/fix.php?id=65738&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=65738&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=65738&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=65738&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=65738&r=isapi
Install GNU Sed:https://bugs.php.net/fix.php?id=65738&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=65738&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=65738&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=65738&r=mysqlcfg
Bug #65738 [Com]: Column metadata for datetimeoffset is incorrect
Edit report at https://bugs.php.net/bug.php?id=65738&edit=1
ID: 65738
Comment by: chri...@php.net
Reported by:chri...@php.net
Summary:Column metadata for datetimeoffset is incorrect
Status: Open
Type: Bug
Package:MSSQL related
Operating System: Debian 7.1
PHP Version:5.5.4
Block user comment: N
Private report: N
New Comment:
Actually, unfortunately on a real char field, it also returns "char" and also
type
47 :( So I'm not sure how to distinguish these.
Previous Comments:
[2013-09-23 02:53:43] chri...@php.net
Description:
When using getColumnMeta() on pdo_dblib, on a column of type
'datetimeoffset(0)', the returned structure looks like this:
array(10) {
["max_length"] => int(104)
["precision"] => int(0)
["scale"] => int(0)
["column_source"] => string(7) "updated"
["native_type"] => string(4) "char"
["native_type_id"] => int(47)
["native_usertype_id"] => int(0)
["name"] => string(7) "updated"
["len"] => int(104)
["pdo_type"] => int(2)
}
Note that it believes that the native_type is char, when it should be
'datetimeoffset'.
Expected result:
I expect to see 'datetimeoffset' as the native_type.
Actual result:
--
You get 'char' - which is incorrect.
--
Edit this bug report at https://bugs.php.net/bug.php?id=65738&edit=1
