Skip to content

Find with Parameter 1 but SQL query taking it as NULL #675

@metripurari

Description

@metripurari

Can Some one please Help me ASAP.

Loading development environment (Rails 6.0.6.1)
[1] pry(main)> User.where(id: 1)
User Load (43.8ms) SELECT db.users.* FROM db.users WHERE db.users.deleted_at IS NULL AND db.users.id = NULL
=> []

Expected behavior

It Should return a row

  • Database: Mysql

  • Gems included by the bundle:

    • actioncable (6.0.6.1)
    • actionmailbox (6.0.6.1)
    • actionmailer (6.0.6.1)
    • actionpack (6.0.6.1)
    • actiontext (6.0.6.1)
    • actionview (6.0.6.1)
    • active_model_serializers (0.10.13)
    • activejob (6.0.6.1)
    • activemodel (6.0.6.1)
    • activerecord (6.0.6.1)
    • activerecord-import (1.4.1)
    • activerecord-session_store (2.0.0)
    • activestorage (6.0.6.1)
    • activesupport (6.0.6.1)
    • acts_as_list (1.0.4)
    • addressable (2.8.1)
    • airbrake (13.0.3)
    • airbrake-ruby (6.2.0)
    • apartment (2.2.1 f266f73)
    • ast (2.4.2)
    • autoprefixer-rails (10.4.7.0)
    • aws-eventstream (1.2.0)
    • aws-partitions (1.678.0)
    • aws-sdk-core (3.169.0)
    • aws-sdk-kms (1.62.0)
    • aws-sdk-s3 (1.118.0)
    • aws-sigv4 (1.5.2)
    • bcrypt (3.1.18)
    • bindex (0.8.1)
    • bootstrap (4.0.0)
    • bootstrap-datepicker-rails (1.9.0.1)
    • bootstrap-select-rails (1.13.8)
    • builder (3.2.4)
    • bundler (2.3.17)
    • byebug (11.1.3)
    • case_transform (0.2)
    • chartkick (5.0.1)
    • childprocess (4.1.0)
    • ci_reporter (2.0.0)
    • ci_reporter_rspec (1.0.0)
    • climate_control (0.2.0)
    • coderay (1.1.3)
    • concurrent-ruby (1.2.0)
    • connection_pool (2.3.0)
    • content_disposition (1.0.0)
    • counter_culture (3.3.0)
    • crack (0.4.5)
    • crass (1.0.6)
    • database_cleaner (2.0.1)
    • database_cleaner-active_record (2.0.1)
    • database_cleaner-core (2.0.1)
    • date (3.3.1)
    • devise (4.8.1)
    • devise-security (0.17.0)
    • devise_invitable (2.0.7)
    • diff-lcs (1.5.0)
    • docile (1.4.0)
    • dotenv (2.8.1)
    • dotenv-rails (2.8.1)
    • down (5.4.0)
    • erubi (1.12.0)
    • execjs (2.8.1)
    • factory_bot (6.2.1)
    • factory_bot_rails (6.2.0)
    • ffi (1.14.2)
    • flag-icons-rails (3.4.6.1)
    • font-awesome-sass (4.7.0)
    • globalid (1.0.1)
    • groupdate (6.1.0)
    • hashdiff (1.0.1)
    • httparty (0.21.0)
    • i18n (1.12.0)
    • iniparse (1.5.0)
    • intellocompute (0.1.0 a6be71c)
    • interception (0.5)
    • jmespath (1.6.2)
    • jquery-fileupload-rails (1.0.0)
    • jquery-rails (4.5.1)
    • jquery-sparkline-rails (2.1.1 c5b531f)
    • jquery-ui-rails (6.0.1)
    • json (2.6.3)
    • jsonapi-renderer (0.2.2)
    • jwt (2.6.0)
    • kaminari (1.2.2)
    • kaminari-actionview (1.2.2)
    • kaminari-activerecord (1.2.2)
    • kaminari-core (1.2.2)
    • local_time (2.1.0)
    • lograge (0.12.0)
    • logstash-event (1.2.02)
    • logstash-logger (0.26.1)
    • loofah (2.19.1)
    • mail (2.8.0.1)
    • marcel (1.0.2)
    • method_source (1.0.0)
    • mime-types (3.4.1)
    • mime-types-data (3.2022.0105)
    • mimemagic (0.3.10)
    • mini_mime (1.1.2)
    • minitest (5.17.0)
    • multi_json (1.15.0)
    • multi_xml (0.6.0)
    • mustermann (3.0.0)
    • mysql2 (0.5.5)
    • net-imap (0.3.4)
    • net-pop (0.1.2)
    • net-protocol (0.2.1)
    • net-smtp (0.3.3)
    • nio4r (2.5.8)
    • nokogiri (1.14.0)
    • orm_adapter (0.5.0)
    • overcommit (0.60.0)
    • pace-rails (0.1.3)
    • paperclip (6.1.0)
    • parallel (1.22.1)
    • paranoia (2.6.1)
    • parser (3.2.0.0)
    • popper_js (1.16.1)
    • pretender (0.4.0)
    • pry (0.14.2)
    • pry-byebug (3.10.1)
    • pry-doc (1.4.0)
    • pry-rails (0.3.9)
    • pry-rescue (1.5.2)
    • psych (3.3.4)
    • public_suffix (5.0.1)
    • puma (5.6.5)
    • puma-daemon (0.1.2)
    • racc (1.6.2)
    • rack (2.2.6.2)
    • rack-protection (3.0.4)
    • rack-test (2.0.2)
    • rails (6.0.6.1)
    • rails-dom-testing (2.0.3)
    • rails-html-sanitizer (1.5.0)
    • rails-i18n (7.0.6)
    • railties (6.0.6.1)
    • rainbow (3.1.1)
    • rake (13.0.6)
    • ransack (3.1.0)
    • rb-fsevent (0.11.2)
    • rb-inotify (0.10.1)
    • rbtree3 (0.7.0)
    • recaptcha (5.12.3)
    • redis (4.5.1)
    • regexp_parser (2.6.2)
    • request_store (1.5.1)
    • responders (3.0.1)
    • rexml (3.2.5)
    • ros-apartment (2.3.0)
    • rspec (3.12.0)
    • rspec-core (3.12.0)
    • rspec-expectations (3.12.2)
    • rspec-mocks (3.12.3)
    • rspec-rails (5.1.2)
    • rspec-sidekiq (3.1.0)
    • rspec-support (3.12.0)
    • rspec_junit_formatter (0.6.0)
    • rubocop (1.44.0)
    • rubocop-ast (1.24.1)
    • ruby-progressbar (1.11.0)
    • ruby2_keywords (0.0.5)
    • ruby_http_client (3.5.5)
    • rubyzip (2.3.2)
    • sass (3.7.4)
    • sass-listen (4.0.0)
    • sass-rails (6.0.0)
    • sassc (2.4.0)
    • sassc-rails (2.1.2)
    • sendgrid-actionmailer (3.2.0)
    • sendgrid-ruby (6.6.2)
    • sentry-rails (5.7.0)
    • sentry-ruby (5.7.0)
    • shrine (3.4.0)
    • sidekiq (5.2.10)
    • simplecov (0.22.0)
    • simplecov-cobertura (2.1.0)
    • simplecov-html (0.12.3)
    • simplecov_json_formatter (0.1.4)
    • sinatra (3.0.4)
    • slim (5.0.0)
    • sprockets (4.2.0)
    • sprockets-rails (3.2.2)
    • temple (0.10.0)
    • terrapin (0.6.0)
    • thor (1.2.1)
    • thread_safe (0.3.6)
    • tilt (2.0.11)
    • timeout (0.3.1)
    • to_bool (2.0.0)
    • tzinfo (1.2.10)
    • uglifier (4.2.0)
    • unicode-display_width (2.4.2)
    • vcr (6.1.0)
    • warden (1.2.9)
    • web-console (4.2.0)
    • webmock (3.18.1)
    • webrick (1.7.0)
    • websocket-driver (0.7.5)
    • websocket-extensions (0.1.5)
    • write_xlsx (1.09.5)
    • yard (0.9.28)
    • zeitwerk (2.6.6)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions