Comment 2 for bug 925510

Revision history for this message
Rogan Hamby (rogan-hamby) wrote :

Using Evergreen 2.7.3 on Postgres 9.1 and I still get this. I did a very simple report to give me a count of patron IDs where claimed return count is not null or blank and got :

DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: "" LINE 3: ...ca9ecd516f33ec379ecc11aa7051"."claims_returned_count" <> '') ^ at /opt/sequoia/apps/evergreen/bin/clark-kent.pl line 242.

 SELECT * FROM (SELECT COUNT("fe21ca9ecd516f33ec379ecc11aa7051"."id") AS "User ID"
  FROM actor.usr AS "fe21ca9ecd516f33ec379ecc11aa7051"
  WHERE ("fe21ca9ecd516f33ec379ecc11aa7051"."claims_returned_count" IS NOT NULL AND "fe21ca9ecd516f33ec379ecc11aa7051"."claims_returned_count" <> '')
  ORDER BY COUNT("fe21ca9ecd516f33ec379ecc11aa7051"."id") ASC
) limited_to_1048576_hits LIMIT 1048576
;

Is the SQL that's generated.