Is CQL case-sensitive?

Question

Online help for Confluence's search implies that the "and" operator is case-sensitive. Is this true?

Exact phrase search

To search for content that contains the exact phrase "chalk and cheese":

"chalk and cheese"

...

AND search

To search for content that contains both the terms "chalk" AND "cheese":

"chalk AND cheese"

Robert Lauriston_pxqe9e · Answer

Ah. So "and" isn't a stop word. That's clear from the first example, I guess my brain just rejected it since I expect Confluence to work like Lucene.

It seems weird that the syntax is

"chalk AND cheese"

rather than

"chalk" AND "cheese"

Thomas Schlegel · Answer

@Robert Lauriston,

yes, the usage of the word "AND" is case-sensitive. If you want to use it in terms of "I want to see everything, where the word before the AND and the word after the AND is included" you have to write it in uppercase letters.

If you write it lowercase, it is just a regular word and you'll get pages containing the word "and".