GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Does bitwise op. of a column get cached?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Does bitwise op. of a column get cached?

    MySQL checks if a query is deterministic then caches the result.
    My question is a query like this:

    select a from b
    where c & 1 and d=100;

    This query seems pretty static to me. But will the result get cached? I would like to make sure.

    TIA for any help.

  • #2
    I tested this query and found it DOES cache such queries.

    Comment

    Working...
    X