Skip Menu |
 

This queue is for tickets about the SQL-Abstract CPAN distribution.

Report information
The Basics
Id: 120676
Status: new
Priority: 0/
Queue: SQL-Abstract

People
Owner: Nobody in particular
Requestors: AVKHOZOV [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: warnings while HASHREF in bind values
Download (untitled) / with headers
text/plain 855b
Hello there! For now Mojo::Pg use SQL::Abstract. Mojo::Pg and PostgreSQL support jsonb type, which is well mapped for Perl hash. It would be nice, if SQL::Abstract will continue to allow use hashref as a bind value without any warnings (https://github.com/dbsrgits/sql-abstract/blob/bd805d8577ae84ee761522c88ff0f5ddeb42619b/lib/SQL/Abstract.pm#L332-L338) Example: $ cat t.pl use Mojo::Pg; my $pg = Mojo::Pg->new('postgresql://and@/test'); $pg->db->insert(tmp => {data => {json => {a => 13, b => 'test'}}}); $ perl t.pl [SQL::Abstract::__ANON__] Warning: HASH ref as bind value in insert is not supported at /usr/local/share/perl/5.22.2/Mojo/Pg/Database.pm line 19. $ psql test -c 'table tmp;' id | data ----+------------------------ 1 | {"a": 13, "b": "test"} (1 row) $ May be hashref will be actual for other databases too.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.