test/debug.log in composite_primary_keys-3.0.0.b3 vs test/debug.log in composite_primary_keys-3.0.3
- old
+ new
@@ -1,271 +1,282 @@
-# Logfile created on Sat Nov 06 22:39:48 -0600 2010 by logger.rb/22285
+# Logfile created on Sat Nov 20 00:07:06 -0700 2010 by logger.rb/22285
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (1.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
+ [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
-PGError: ERROR: column suburbs.city_idsuburb_id does not exist
-LINE 1: ...T "suburbs".* FROM "suburbs" ORDER BY suburbs.ci...
- ^
-: SELECT "suburbs".* FROM "suburbs" ORDER BY suburbs.city_idsuburb_id DESC LIMIT 1
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
-PGError: ERROR: column suburbs.city_idsuburb_id does not exist
-LINE 1: ...T "suburbs".* FROM "suburbs" ORDER BY suburbs.ci...
- ^
-: SELECT "suburbs".* FROM "suburbs" ORDER BY suburbs.city_idsuburb_id DESC LIMIT 1
+PGError: ERROR: operator does not exist: character varying = integer
+LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1))
+ ^
+HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
+: SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1))
[1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
+ [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
-PGError: ERROR: column suburbs.city_idsuburb_id does not exist
-LINE 1: ...T "suburbs".* FROM "suburbs" ORDER BY suburbs.ci...
- ^
-: SELECT "suburbs".* FROM "suburbs" ORDER BY suburbs.city_idsuburb_id DESC LIMIT 1
- [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
+ [1m[36mSQL (1.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: operator does not exist: character varying = integer
+LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1))
+ ^
+HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
+: SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1))
+ [1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
+ [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function
+LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass...
+ ^
+: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1))
+PGError: ERROR: operator does not exist: character varying = integer
+LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1))
+ ^
+HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
+: SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1))
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
+ [1m[36mSQL (1.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function
+LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass...
+ ^
+: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1))
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
-PGError: ERROR: column suburbs.suburb_iddesc does not exist
-LINE 1: ... FROM "suburbs" ORDER BY suburbs.city_id, suburbs.su...
- ^
-: SELECT "suburbs".* FROM "suburbs" ORDER BY suburbs.city_id, suburbs.suburb_idDESC LIMIT 1
- [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function
+LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass...
+ ^
+: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1))
[1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
+ [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (1.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function
+LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass...
+ ^
+: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1))
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (1.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (1.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function
+LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass...
+ ^
+: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1))
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (1.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function
+LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass...
+ ^
+: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1))
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'panic'
+ [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+ [1m[36mSQL (1.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function
+LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass...
+ ^
+: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1))
[1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'panic'
+ [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
+ [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function
+LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass...
+ ^
+: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1))
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: column "rooms.dorm_id" must appear in the GROUP BY clause or be used in an aggregate function
+LINE 1: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_ass...
+ ^
+: SELECT "rooms".*, COUNT(*) FROM "rooms" INNER JOIN "room_assignments" ON ("rooms"."dorm_id" = "room_assignments"."dorm_id" AND "rooms"."room_id" = "room_assignments"."room_id") WHERE (("room_assignments".student_id = 1))
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (1.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
+ [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+ [1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
+ [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
+ [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
[1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (1.0ms)[0m [1mSET standard_conforming_strings = on[0m
+ [1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
+ [1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
+ [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (1.0ms)[0m [1mSHOW TIME ZONE[0m
-PGError: ERROR: column memberships.user_idgroup_id does not exist
-LINE 1: SELECT "memberships"."user_idgroup_id" AS t0_r0, "member...
- ^
-: SELECT "memberships"."user_idgroup_id" AS t0_r0, "memberships"."user_id" AS t0_r1, "memberships"."group_id" AS t0_r2, "membership_statuses"."id" AS t1_r0, "membership_statuses"."user_id" AS t1_r1, "membership_statuses"."group_id" AS t1_r2, "membership_statuses"."status" AS t1_r3 FROM "memberships" LEFT OUTER JOIN "membership_statuses" ON "membership_statuses"."user_id" = "memberships"."user_id" AND "membership_statuses"."group_id" = "memberships"."group_id" WHERE (membership_statuses.status = 'Active')
- [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
+ [1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'notice'
+ [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
+ [1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
+ [1m[36mSQL (1.0ms)[0m [1mSET standard_conforming_strings = on[0m
+ [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'notice'
+ [1m[36mSQL (1.0ms)[0m [1mSHOW TIME ZONE[0m
+ [1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
+ [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
+PGError: ERROR: schema "(SELECT DISTINCT "tariffs"" does not exist
+LINE 1: SELECT COUNT(*) FROM "(SELECT DISTINCT ""tariffs"""."tariff_...
+ ^
+: SELECT COUNT(*) FROM "(SELECT DISTINCT ""tariffs"""."tariff_id"
+ [1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
+ [1m[36mSQL (1.0ms)[0m [1mSET standard_conforming_strings = on[0m
+ [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: schema "(SELECT DISTINCT "tariffs"" does not exist
+LINE 1: SELECT COUNT(*) FROM "(SELECT DISTINCT ""tariffs"""."tariff_...
+ ^
+: SELECT COUNT(*) FROM "(SELECT DISTINCT ""tariffs"""."tariff_id"
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (1.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: schema "(SELECT DISTINCT "tariffs"" does not exist
+LINE 1: SELECT COUNT(*) FROM "(SELECT DISTINCT ""tariffs"""."tariff_...
+ ^
+: SELECT COUNT(*) FROM "(SELECT DISTINCT ""tariffs"""."tariff_id"
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
+ [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (1.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+TypeError: wrong argument type Arel::SelectManager (expected String): #<Arel::SelectManager:0x59f0df0>
[1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (1.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
-PGError: ERROR: column memberships.user_idgroup_id does not exist
-LINE 1: SELECT DISTINCT "memberships".user_idgroup_id FROM ...
- ^
-: SELECT DISTINCT "memberships".user_idgroup_id FROM "memberships" LEFT OUTER JOIN "membership_statuses" ON "membership_statuses"."user_id" = "memberships"."user_id" AND "membership_statuses"."group_id" = "memberships"."group_id" WHERE (membership_statuses.status = 'Active') LIMIT 1
+ [1m[36mSQL (1.0ms)[0m [1mSHOW TIME ZONE[0m
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+ [1m[36mSQL (1.0ms)[0m [1mSHOW TIME ZONE[0m
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
+ [1m[36mSQL (1.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
[1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
+ [1m[36mSQL (1.0ms)[0m [1mSET standard_conforming_strings = on[0m
+ [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
+ [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: column "i" does not exist
+LINE 1: SELECT COUNT(DISTINCT i) FROM "products" LEFT OUTER JOIN "pr...
+ ^
+: SELECT COUNT(DISTINCT i) FROM "products" LEFT OUTER JOIN "product_tariffs" ON "product_tariffs"."product_id" = "products"."id"
+ [1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
+ [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
[1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (1.0ms)[0m [1mSET standard_conforming_strings = on[0m
+ [1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: column "tariff_idstart_date" does not exist
+LINE 1: SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LE...
+ ^
+: SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LEFT OUTER JOIN "product_tariffs" ON "product_tariffs"."tariff_id" = "tariffs"."tariff_id" AND "product_tariffs"."tariff_start_date" = "tariffs"."start_date"
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (1.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (2.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+PGError: ERROR: column "tariff_idstart_date" does not exist
+LINE 1: SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LE...
+ ^
+: SELECT COUNT(DISTINCT tariff_idstart_date) FROM "tariffs" LEFT OUTER JOIN "product_tariffs" ON "product_tariffs"."tariff_id" = "tariffs"."tariff_id" AND "product_tariffs"."tariff_start_date" = "tariffs"."start_date"
+PGError: ERROR: operator does not exist: character varying = integer
+LINE 1: ...ments".person_type = 'User') AND ("comments".person_id = 1))
+ ^
+HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
+: SELECT "hacks".* FROM "hacks" INNER JOIN "comments" ON ("hacks"."name" = "comments"."hack_id") WHERE (("comments".person_type = 'User') AND ("comments".person_id = 1))
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
+ [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
+ [1m[36mSQL (1.0ms)[0m [1mSHOW TIME ZONE[0m
[1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (0.0ms)[0m [1mSHOW client_min_messages[0m
- [1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
- [1m[36mSQL (1.0ms)[0m [1mSET standard_conforming_strings = on[0m
- [1m[35mSQL (1.0ms)[0m SET client_min_messages TO 'notice'
- [1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
- [1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'panic'
[1m[36mSQL (0.0ms)[0m [1mSET standard_conforming_strings = on[0m
[1m[35mSQL (0.0ms)[0m SET client_min_messages TO 'notice'
[1m[36mSQL (0.0ms)[0m [1mSHOW TIME ZONE[0m
[1m[36mSQL (1.0ms)[0m [1mSHOW client_min_messages[0m