mz_now_operators.yml 435 B

1234567891011121314151617181920212223
  1. columns:
  2. - column: "Valid/Invalid"
  3. - column: "mz_now() clause"
  4. rows:
  5. - "mz_now() clause": |
  6. ```mzsql
  7. WHERE mz_now() > order_date + INTERVAL '5min';
  8. ```
  9. "Valid/Invalid": |
  10. <blue>Materialize SQL</blue> ✅
  11. - "Valid/Invalid": |
  12. <red>Anti-pattern</red> ❌
  13. "mz_now() clause": |
  14. <red>Not supported</red>
  15. ```mzsql
  16. WHERE mz_now() - INTERVAL '5min' > order_date;
  17. ```