Mercurial > sci

diff sql/worker-find-id.sql @ 19:de4bf839b565

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
misc: revamp SQL
author David Demelier <markand@malikania.fr>
date Fri, 15 Jul 2022 11:11:48 +0200
parents 3051ef92173a
children
line wrap: on
line diff
--- a/sql/worker-find-id.sql	Tue Jul 12 20:20:51 2022 +0200
+++ b/sql/worker-find-id.sql	Fri Jul 15 11:11:48 2022 +0200
@@ -16,7 +16,8 @@
 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
 --
 
-SELECT *
-  FROM worker
- WHERE id = ?
+SELECT rowid
+     , *
+  FROM `worker`
+ WHERE `rowid` = ?
  LIMIT 1