Xpath query to identify Capital and small letters

SonarQube Server / Community Build Writing rules
2

Hi. It’s not possible.

Using the sslr-plsql-toolkit-3.3.0.2273.jar you can see that a code like select * from dual; generates this XML:

<COMPILATION_UNIT tokenValue="SELECT" tokenLine="1" tokenColumn="0">
  <COMPILATION_UNIT tokenValue="SELECT" tokenLine="1" tokenColumn="0">
    <SELECT_WITH_SEMICOLON tokenValue="SELECT" tokenLine="1" tokenColumn="0">
      <SELECT tokenValue="SELECT" tokenLine="1" tokenColumn="0">
        <SUBQUERY tokenValue="SELECT" tokenLine="1" tokenColumn="0">
          <QUERY_BLOCK tokenValue="SELECT" tokenLine="1" tokenColumn="0">
            <SELECT tokenValue="SELECT" tokenLine="1" tokenColumn="0"/>
            <SELECT_LIST tokenValue="*" tokenLine="1" tokenColumn="7">

As you can see, even with the “select” keyword written in lower case, in the XML we’ll have the following: <SELECT tokenValue="SELECT" tokenLine="1" tokenColumn="0">

Therefore, there’s no way to distinguish between upper and lower cases in a XPATH rule.

Edit: this is a duplicate of To indentify english capital and small letter