Rails5.2 - Active Record .select() causing error when .count is called

Question

How do I add another column to scope and still be able to call .count, .find, .where, etc.

 User.all.select('users.*,"one" as one').count

Result:

  (1.3ms)  SELECT COUNT(users.*,"one" as one) FROM "users"
Traceback (most recent call last):
        1: from (irb):7
ActiveRecord::StatementInvalid (PG::SyntaxError: ERROR:  syntax error at or near "as")
LINE 1: SELECT COUNT(users.*,"one" as one) FROM "users"
                                   ^
: SELECT COUNT(users.*,"one" as one) FROM "users"

This is a simplified example, but need to count a scope after much manipulation, added `select as` statements and unions. — user2012677, Jul 26 '19 at 11:30
Can you try writing it as `User.all.select("users.*, 'one' as one").count`? (swap double quotes and single quotes). In PostgreSQL you need to use single quotes for strings. — Gregory Witek, Jul 26 '19 at 12:52
`User.all.select("users.*, 'one' as one").size` works, but might not be what you're looking for. — Eyeslandic, Jul 26 '19 at 13:02

score -1 · Accepted Answer · answered Jul 26 '19 at 13:59

-1

 User.all.select('users.*,"one" as one').count(:all)

and

 User.all.select('users.*,"one" as one').count(:id)

Both work because it specifies what the SQL code should count on.

answered Jul 26 '19 at 13:59

user2012677

5,465
6
51
113

They don't produce the query the op is looking for though. – Eyeslandic Jul 26 '19 at 17:48
Look at the query the op provided, the generated sql of your queries doesn't use the `select` fields – Eyeslandic Jul 26 '19 at 17:52
If you are returning a count, the select does not matter, but matters, if you do other operations before the count. – user2012677 Jul 26 '19 at 17:52

Rails5.2 - Active Record .select() causing error when .count is called

1 Answers1