Skip Menu |

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

Report information
The Basics
Id: 127356
Status: new
Priority: 0/
Queue: SQL-Abstract
People
Owner: Nobody in particular
Requestors: ser.khomutov [...] gmail.com
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Fri Oct 12 06:48:54 2018 ser.khomutov [...] gmail.com - Ticket created
Subject: Undef in not_in clause
Date: Fri, 12 Oct 2018 13:48:31 +0300
To: bug-SQL-Abstract [...] rt.cpan.org
From: Сергей Хомутов <ser.khomutov [...] gmail.com>
Hello, i got a error when try to pass arrayref with any undef element in not_in clause. SQL::Abstract::puke(): [SQL::Abstract::__ANON__] Fatal: SQL::Abstract before v1.75 used to generate incorrect SQL when the -NOT IN operator was given an undef-containing list: !!!AUDIT YOUR CODE AND DATA!!! (the upcoming Data::Query-based version of SQL::Abstract will emit the logically correct SQL instead of raising this exception) SQL::Abstract version is 1.81 . May be this undef element should be eliminated from not_in clause on Sql::Abstract side ? Regards.