Advertisement
Guest User

Untitled

a guest
May 27th, 2015
247
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.47 KB | None | 0 0
  1. a = Simulation.where(user_id: 1, visibility: 0).where_values.reduce(:and)
  2. a.to_sql
  3. => "\"simulations\".\"user_id\" = $1 AND \"simulations\".\"visibility\" = $2"
  4. b = Simulation.where(visibility: 1).where_values.reduce(:and)
  5. b.to_sql
  6. => "\"simulations\".\"visibility\" = $1"
  7.  
  8. Simulation.where(a.or(b)).to_sql
  9. => "SELECT \"simulations\".* FROM \"simulations\" WHERE (\"simulations\".\"user_id\" = AND \"simulations\".\"visibility\" = OR \"simulations\".\"visibility\" = )"
  10.  
  11. Simulation.where(a.or(b), 1,2,3).first
  12. Simulation Load (2.8ms) SELECT "simulations".* FROM "simulations" WHERE ("simulations"."user_id" = $1 AND "simulations"."visibility" = $2 OR "simulations"."visibility" = $3) ORDER BY "simulations"."id" ASC LIMIT 1
  13. PG::ProtocolViolation: ERROR: bind message supplies 0 parameters, but prepared statement "" requires 3
  14. : SELECT "simulations".* FROM "simulations" WHERE ("simulations"."user_id" = $1 AND "simulations"."visibility" = $2 OR "simulations"."visibility" = $3) ORDER BY "simulations"."id" ASC LIMIT 1
  15. ActiveRecord::StatementInvalid: PG::ProtocolViolation: ERROR: bind message supplies 0 parameters, but prepared statement "" requires 3
  16. : SELECT "simulations".* FROM "simulations" WHERE ("simulations"."user_id" = $1 AND "simulations"."visibility" = $2 OR "simulations"."visibility" = $3) ORDER BY "simulations"."id" ASC LIMIT 1
  17. from /home/jhedtrich/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.0/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `async_exec'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement