php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #77047 pg_convert has a broken regex for the 'TIME WITHOUT TIMEZONE' data type
Submitted: 2018-10-22 14:48 UTC Modified: -
From: andy at gajetzki dot com Assigned:
Status: Closed Package: PostgreSQL related
PHP Version: 7.1.23 OS: Linux
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: andy at gajetzki dot com
New email:
PHP Version: OS:

 

 [2018-10-22 14:48 UTC] andy at gajetzki dot com
Description:
------------
While using pg_insert, it was discovered that any values other than empty strings and null cannot be inserted into fields having the 'time without timezone' data type. 

Expected result:
----------------
Data should be inserted without error

Actual result:
--------------
pg_insert(): Cannot compile regex in xxx.php on line yy
PHP Notice:  pg_insert(): Expects NULL or string for PostgreSQL time field (occurrence_time) in xxx.php on line yy


Patches

Pull Requests

Pull requests:

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2018-11-18 10:53 UTC] ab@php.net
Automatic comment on behalf of andy@gajetzki.com
Revision: http://git.php.net/?p=php-src.git;a=commit;h=369c991d5cbb0e606ec1106697925d6d958cc4bf
Log: FIX #77047: fixes regex for "time" data type
 [2018-11-18 10:53 UTC] ab@php.net
-Status: Open +Status: Closed
 [2018-11-18 11:34 UTC] ab@php.net
Automatic comment on behalf of ab
Revision: http://git.php.net/?p=php-src.git;a=commit;h=0434141ce93d5033e47c46c78a8849ac3bfa4311
Log: Fixed bug #77047 pg_convert has a broken regex for the 'TIME WITHOUT TIMEZONE' data type
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun Oct 06 13:01:27 2024 UTC