php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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 back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
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: Mon Oct 14 11:01:27 2024 UTC