Amazing! It did not occur to me that I should try it outside of Quarry (I
just love and trust Quarry so much ... ;)
Thank you all for your help. I am going to move this to Phabricator as a
task for Quarry.
On Wed, Aug 14, 2019 at 9:30 AM Brad Jorsch (Anomie) <bjorsch(a)wikimedia.org>
wrote:
On Wed, Aug 14, 2019 at 9:10 AM John
<phoenixoverride(a)gmail.com> wrote:
I tweaked the initial select statement from *,*
to just *
MariaDB [fawiki_p]> set @row_number = 0; set @row_number_2 = 0; select *
from ( select (@row_number:=@row_number + 1) as rownumber, ipb_address from
ipblocks where ipb_by_actor = 1789 order by ipb_range_start ) as ipb left
join ( select (@row_number_2:=@row_number_2 + 1) as rownumber, ipb_address
from ipblocks where ipb_by_actor = 1789 order by ipb_range_start ) as lead
on lead.rownumber = ipb.rownumber + 1;
When I try the original Query 3 in the command line client, it works fine
for me:
MariaDB [fawiki_p]> set @row_number = 0;
Query OK, 0 rows affected (0.01 sec)
MariaDB [fawiki_p]> set @row_number_2 = 0;
Query OK, 0 rows affected (0.00 sec)
MariaDB [fawiki_p]>
MariaDB [fawiki_p]> select
-> ipb.*,
-> lead.*
-> from
-> (
-> select
-> (@row_number:=@row_number + 1) as rownumber,
-> ipb_address
-> from ipblocks
-> where ipb_by_actor = 1789 -- HujiBot
-> order by ipb_range_start
-> ) as ipb
-> left join
-> (
-> select
-> (@row_number_2:=@row_number_2 + 1) as rownumber,
-> ipb_address
-> from ipblocks
-> where ipb_by_actor = 1789 -- HujiBot
-> order by ipb_range_start
-> ) as lead
-> on lead.rownumber = ipb.rownumber + 1;
[...]
160 rows in set (0.04 sec)
So perhaps Quarry is doing something odd.
--
Brad Jorsch (Anomie)
Senior Software Engineer
Wikimedia Foundation
_______________________________________________
Wikimedia Cloud Services mailing list
Cloud(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud