title: SELECT SINGLE vs SELECT UP TO 1 ROWS ENDSELECT correctness in HANA?
body: <p>We are moving to HANA, and an external company is doing our code remediation. Some of it is automated. I see where this code change was made:</p>
  
  <pre><code>*{   REPLACE        DEVK9A1ZZH
  *  SELECT SINGLE maktx
  *                INTO tab-maktx
  *                FROM makt
  *                WHERE matnr EQ strmatnr
  *                AND   spras EQ sy-langu.
    SELECT maktx
      UP TO 1 ROWS
      INTO tab-maktx
      FROM makt
      WHERE matnr = strmatnr
      AND   spras = sy-langu ORDER BY maktx.
    ENDSELECT.
  </code></pre>
  
  <p>I thought <code>SELECT SINGLE</code> was always preferable to <code>SELECT...UP TO 1 ROWS...ENDSELECT.</code> and that <code>ORDER BY</code> doesn't do anything when only one record is obtained. It seems that they're replacing every <code>SELECT SINGLE</code> in our code. What in my coworker's original code is not HANA compliant? </p>