Date: Wed, 23 May 2018 11:59:29 +0000 (UTC) From: =?UTF-8?Q?Dag-Erling_Sm=c3=b8rgrav?= <des@FreeBSD.org> To: src-committers@freebsd.org, svn-src-user@freebsd.org Subject: svn commit: r334092 - user/des/fbce/db Message-ID: <201805231159.w4NBxTXK094469@repo.freebsd.org>
next in thread | raw e-mail | index | archive | help
Author: des Date: Wed May 23 11:59:29 2018 New Revision: 334092 URL: https://svnweb.freebsd.org/changeset/base/334092 Log: Modify SQL query so it produces the correct result even if run after the start of the election. Modified: user/des/fbce/db/notes Modified: user/des/fbce/db/notes ============================================================================== --- user/des/fbce/db/notes Wed May 23 11:45:46 2018 (r334091) +++ user/des/fbce/db/notes Wed May 23 11:59:29 2018 (r334092) @@ -59,7 +59,7 @@ perl -Ilib -MFBCE -e 'map { $_->reset_password() } FBC # fst3k=# \t on # Showing only tuples. # fst3k=# \o active-20180516.txt -# fst3k=# select p.login from persons p join revisions r on p.id = r.author where r.datetime >= '2017-05-16' group by p.login order by p.login; +# fst3k=# select p.login from persons p join revisions r on p.id = r.author where r.datetime >= '20170516T180000Z' and r.datetime <'20180516T180000Z' group by p.login order by p.login; # fst3k=# \o # ./script/fbce_user.pl activate active-20180516.txt
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201805231159.w4NBxTXK094469>