Opened 7 years ago

Closed 7 years ago

Last modified 5 years ago

#10631 closed (invalid)

Documentation: SQL for second exclude example is incorrect

Reported by: muffinresearch Owned by: nobody
Component: Documentation Version: 1.0
Severity: Keywords:
Cc: Triage Stage: Ready for checkin
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:



The second example has AND instead of OR.

WHERE NOT pub_date > '2005-1-3'
AND NOT headline = 'Hello'

Should be:

WHERE NOT pub_date > '2005-1-3'
OR NOT headline = 'Hello'

Attachments (1)

ticket_10631.diff (393 bytes) - added by adamfast 7 years ago.
Doc fix

Download all attachments as: .zip

Change History (4)

Changed 7 years ago by adamfast

Doc fix

comment:1 Changed 7 years ago by adamfast

  • Has patch set
  • milestone set to 1.1
  • Needs documentation unset
  • Needs tests unset
  • Patch needs improvement unset
  • Triage Stage changed from Unreviewed to Ready for checkin

comment:2 Changed 7 years ago by gwilson

  • Resolution set to invalid
  • Status changed from new to closed

The AND is correct here.

comment:3 Changed 5 years ago by jacob

  • milestone 1.1 deleted

Milestone 1.1 deleted

Note: See TracTickets for help on using tickets.
Back to Top