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)
wrote:
> On Wed, Aug 14, 2019 at 9:1
On Wed, Aug 14, 2019 at 9:10 AM John 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 o
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 (@r
Let's way the output of Query 1, without the rownumber column, would be
like this:
1.2.3.4
100.200.100.200
4.6.8.10
100.200.100.202
4.6.9.255
Using the ORDER BY and the @rownumber variable, we get an output that is
like this:
11.2.3.4
24.6.8.10
34.6.9.255
4100.200.100.200
510
what does your rownumber logic actually do? odds are that's probably whats
slowing you down
On Tue, Aug 13, 2019 at 7:46 PM Huji Lee wrote:
> Certainly doable! But I didn't ask this here because of not having a way
> to achieve my goal; I asked it because I am perplexed as to why the query
> nev
Certainly doable! But I didn't ask this here because of not having a way to
achieve my goal; I asked it because I am perplexed as to why the query
never finishes, despite its relatively simple structure and row number of
rows returned.
On Tue, Aug 13, 2019 at 7:43 PM Platonides wrote:
> Why not
Why not simply do the comparison client-side?
___
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud
Amazingly, the problematic query never finishes executing. Still trying to
figure out what is going on here. Any help is appreciated.
On Wed, Aug 7, 2019 at 10:21 PM Maximilian Doerr
wrote:
> Running an EXPLAIN on all three reveal identical indices being used. They
> should theoretically all ru
Running an EXPLAIN on all three reveal identical indices being used. They
should theoretically all run equally fast.
Cyberpower678
English Wikipedia Account Creation Team
English Wikipedia Administrator
Global User Renamer
> On Aug 7, 2019, at 22:15, Huji Lee wrote:
>
> I have a question for
