Opened 10 years ago

Closed 10 years ago

Last modified 7 years ago

#10631 closed (invalid)

Documentation: SQL for second exclude example is incorrect

Reported by: Stuart Colville 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: no UI/UX: no



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 10 years ago.
Doc fix

Download all attachments as: .zip

Change History (4)

Changed 10 years ago by adamfast

Attachment: ticket_10631.diff added

Doc fix

comment:1 Changed 10 years ago by adamfast

Has patch: set
milestone: 1.1
Triage Stage: UnreviewedReady for checkin

comment:2 Changed 10 years ago by Gary Wilson

Resolution: invalid
Status: newclosed

The AND is correct here.

comment:3 Changed 7 years ago by Jacob

milestone: 1.1

Milestone 1.1 deleted

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