title: Python: strange SQLite3 query result
body: <p>I'm getting unexpected results with an SQLite3 query in Python3.</p>
  
  <pre><code>if first_waypoint_number &lt; last_waypoint_number:
          result = list(c.execute("SELECT WPNumber, WPID, ROUTE FROM rte WHERE ROUTE = ? AND WPNumber BETWEEN ? AND ?", (route, first_waypoint_number, last_waypoint_number)))
          print(result)
  else:
          result = list(c.execute("SELECT WPNumber, WPID, ROUTE FROM rte WHERE ROUTE = ? AND WPNumber BETWEEN ? AND ? ORDER BY WPNumber DESC", (route, first_waypoint_number, last_waypoint_number)))
          print(result)
  </code></pre>
  
  <p>The first query works like expected, and produces this result:</p>
  
  <pre><code>[('A123', 25, 'WAYPOINTX'), ('A123', 26, 'WAYPONTY'), ('A123', 27, 'WAYPOINTZ')]
  </code></pre>
  
  <p>The second query however, produces an empty list <code>[]</code>, while it should return the same list in reverse order.</p>
  
  <p>I've tested both queries in SQLite3 without problems.</p>
  
  <p>Am I missing something here?</p>