| 00:16.56 | *** join/#wowuidev Arrowmaster (~Arrowmast@WoWUIDev/WoWAce/ResponsibleForEverythingAndNothing/Arrowmaster) |
| 01:59.40 | *** join/#wowuidev yalb (xsbot@lua/bot/yalb) |
| 02:00.12 | *** join/#wowuidev Seerah (~umsin@2601:3c2:101:320:64f9:56d6:4219:6d7f) |
| 02:00.12 | *** mode/#wowuidev [+o Seerah] by ChanServ |
| 02:11.39 | *** join/#wowuidev Talyrius (uid175475@gateway/web/irccloud.com/x-norbdplzykekynsz) |
| 02:30.48 | *** join/#wowuidev bluspacecow (~bluspacec@121.99.98.200) |
| 02:30.49 | *** mode/#wowuidev [+v bluspacecow] by ChanServ |
| 02:35.24 | *** join/#wowuidev bluspacecowtoo (~bluspacec@121.99.98.200) |
| 02:59.14 | *** join/#wowuidev pompy1 (~Mike@c-73-194-183-217.hsd1.nj.comcast.net) |
| 03:41.36 | *** join/#wowuidev eir (eir@freenode/utility-bot/eir) |
| 05:06.37 | *** part/#wowuidev Seerah (~umsin@2601:3c2:101:320:64f9:56d6:4219:6d7f) |
| 05:24.45 | *** join/#wowuidev bluspacecow (~bluspacec@121.99.98.200) |
| 05:24.45 | *** mode/#wowuidev [+v bluspacecow] by ChanServ |
| 05:25.23 | bluspacecow | https://us.battle.net/forums/en/wow/topic/20759341993?page=3#post-47 |
| 05:25.32 | bluspacecow | i'm not sure Ace was a thing back in Vanilla |
| 05:26.01 | *** join/#wowuidev ShadniX (dagger@p5B3D28EC.dip0.t-ipconnect.de) |
| 05:36.43 | nebula | it was |
| 05:39.55 | fewyn | it was |
| 05:39.57 | fewyn | yes |
| 05:40.00 | fewyn | i remember it vividly |
| 06:45.49 | *** join/#wowuidev bluspacecow (~bluspacec@121.99.98.200) |
| 06:45.50 | *** mode/#wowuidev [+v bluspacecow] by ChanServ |
| 07:29.44 | *** join/#wowuidev karl_w_w (~karl_w_w@110-175-132-56.tpgi.com.au) |
| 08:02.29 | *** join/#wowuidev VIad (~Vlad@cm-84.213.146.58.getinternet.no) |
| 08:42.27 | *** join/#wowuidev modernist (~modernist@2a00:23c5:3483:3500:68aa:62f3:d38f:df52) |
| 08:43.42 | *** join/#wowuidev ls- (~ls@180.183.212.108) |
| 08:47.48 | *** join/#wowuidev Andols2 (~yaaic@m77-218-225-57.cust.tele2.se) |
| 09:15.14 | modernist | https://gist.github.com/obble/17cceca2e9983a8bbaedabd258c317c0 |
| 09:15.29 | modernist | am i misunderstanding the use of UnitIsUnit here? |
| 09:16.04 | modernist | im just trying to clock which nameplate is my target ~ but it always fails |
| 09:17.04 | *** join/#wowuidev Antiarc (~quassel@2600:8800:2a8a:8bd3:225:22ff:fee3:a470) |
| 09:18.55 | nevcairiel | it should do that, assuming namePlateUnitToken contains what it should |
| 09:19.12 | modernist | 'nameplate1', 'nameplate2' etc |
| 09:21.30 | modernist | my woes: http://i.pi.gy/k045v.png |
| 09:28.17 | *** join/#wowuidev modernist (~modernist@212.84.181.70) |
| 10:04.45 | ls- | modernist: why don't you use GetNamePlateForUnit? |
| 10:05.00 | ls- | C_NamePlate.GetNamePlateForUnit("target") |
| 10:07.56 | modernist | yeah i tried that, no dice |
| 10:09.09 | modernist | i also tried wrapping it in a C_Timer.After function thinking it might be an issue with the unit not being "cached" or whatever at the time of the script being run |
| 10:09.13 | modernist | also no dice |
| 10:09.17 | modernist | https://gist.github.com/obble/d54d8c3a500aa73d6bdf835f837b7630 |
| 10:10.50 | modernist | having added a qualifier to my original script that checks for whether "frame.namePlateUnitToken" exists ~ it _does_ pass sometimes but it is very incosistent |
| 10:15.17 | ls- | eh? I just tested it, GetNamePlateForUnit works fine... |
| 10:15.49 | ls- | copy-pasted your code, removed timer and works w/o issues... |
| 10:16.45 | modernist | weird |
| 10:28.51 | ls- | modernist: your code in action https://i.imgur.com/OrUq964.gif |
| 10:29.00 | ls- | w/o timer |
| 10:29.39 | modernist | well i can only assume some other bit of my code is messing up unit attribution then |
| 10:29.44 | modernist | oh well ill fix it after the pub |
| 10:29.51 | modernist | cheers for the testing |
| 10:30.36 | ls- | yw |
| 10:33.52 | *** join/#wowuidev brykrys (~chatzilla@cpc104562-craw8-2-0-cust239.16-3.cable.virginm.net) |
| 10:33.52 | *** join/#wowuidev brykrys (~chatzilla@WoWUIDev/Norganna/Dev/Brykrys) |
| 10:41.48 | *** join/#wowuidev stolenlegacy (~stolenleg@213-47-49-27.cable.dynamic.surfer.at) |
| 10:41.48 | *** join/#wowuidev stolenlegacy (~stolenleg@unaffiliated/stolenlegacy) |
| 10:49.07 | *** join/#wowuidev Exality (~Exality@85.15.215.13) |
| 12:16.32 | *** join/#wowuidev Andols (~yaaic@m77-218-230-124.cust.tele2.se) |
| 12:44.13 | *** join/#wowuidev pnorman (~pnorman@d205-250-46-76.bchsia.telus.net) |
| 13:01.30 | *** join/#wowuidev Tentacled (~sinus@xdsl-5221.wroclaw.dialog.net.pl) |
| 13:38.05 | *** join/#wowuidev pompy (~Mike@c-73-194-183-217.hsd1.nj.comcast.net) |
| 13:55.51 | *** join/#wowuidev pompy (~Mike@c-73-194-183-217.hsd1.nj.comcast.net) |
| 14:01.38 | *** join/#wowuidev Andols (~yaaic@62-20-145-33-no170.tbcn.telia.com) |
| 14:40.40 | *** join/#wowuidev ikcerog (~ikcerog@2601:40f:c101:d190:d9ee:97fc:234c:cc37) |
| 15:04.50 | foxlit | SELECT a FROM b WHERE b.c = ? AND (SELECT d FROM e WHERE e.f = ?) BETWEEN b.f AND b.g << the query plan for this seems to look rather terrible :( |
| 15:23.03 | Fisker | hey foxlit |
| 15:23.19 | foxlit | hey Fisker |
| 15:23.24 | Fisker | Fight? |
| 15:27.27 | foxlit | only on sanctioned warfronts. |
| 15:27.43 | Fisker | alright |
| 15:27.48 | Fisker | But this better be Warcraft 4 then |
| 15:29.07 | foxlit | warcraft in space, imo. |
| 15:29.31 | Fisker | Starcraft? |
| 15:29.51 | karl_w_w | Warspace |
| 16:08.45 | *** join/#wowuidev Andols (~Andols@62-20-145-33-no170.tbcn.telia.com) |
| 16:48.58 | *** join/#wowuidev Dragnog (~Dragnog@cpc113770-lea23-2-0-cust627.6-3.cable.virginm.net) |
| 17:10.48 | *** join/#wowuidev stolenlegacy (~stolenleg@213-47-49-27.cable.dynamic.surfer.at) |
| 17:10.48 | *** join/#wowuidev stolenlegacy (~stolenleg@unaffiliated/stolenlegacy) |
| 18:19.20 | *** join/#wowuidev modernist (~modernist@212.84.181.70) |
| 18:21.56 | *** join/#wowuidev modernist (~modernist@212.84.181.70) |
| 18:24.30 | *** join/#wowuidev modernist (~modernist@212.84.181.70) |
| 18:29.10 | *** join/#wowuidev modernist (~modernist@212.84.181.70) |
| 18:50.34 | *** join/#wowuidev schlumpf (~schlumpf@2a02:810b:c53f:b33c:cd06:2779:1cbc:9c30) |
| 18:50.54 | *** join/#wowuidev Ssateneth (~ident@unaffiliated/ssateneth) |
| 19:02.17 | *** join/#wowuidev ls- (~ls@180.183.212.108) |
| 19:29.19 | *** join/#wowuidev ikcerog (~ikcerog@2601:400:8:811e:cd11:55f1:519:2b12) |
| 19:37.32 | foxlit | Wish the Legion app wouldnât duck audio even when all of its sound effects are turned off. |
| 19:40.51 | Fisker | Maybe it's born with it |
| 20:07.59 | *** join/#wowuidev pompy (~Mike@c-73-194-183-217.hsd1.nj.comcast.net) |
| 20:48.36 | Gnarfoz | at least it only does it once when you start it |
| 20:48.47 | Gnarfoz | it's still a ridiculous thing to not be fixed by now :p |
| 20:50.04 | Gnarfoz | also, your query could probably use a with-query |
| 20:50.12 | Gnarfoz | (or two, even) |
| 20:52.19 | Gnarfoz | (obviously the plan you see depends heavily on what DBMS you're even using, and indexes, constraints, or lack thereof) |
| 21:01.17 | *** join/#wowuidev MentalPower (~textual@2604:4080:115e:8670:2ca4:f263:e666:d467) |
| 21:25.27 | Iriel | Gnarfoz: not to mention (depending on DBMS) what statistics have been gathered and how they are configured and how up to date they are relative to the data. |
| 21:26.17 | Gnarfoz | indeed |
| 21:26.20 | Iriel | Depending on how b is structured, an index on b.c might help quite a bit, and if it's really wide, an index on b.c, b.f, b.g may help too. |
| 21:26.44 | Gnarfoz | My little Database: Optimizers are Magic |
| 21:26.57 | Thunder_Child | ~lart Gnarfoz |
| 21:26.57 | purl | grabs a large, mis-shapened log, with squirrels, and beats Gnarfoz until only the nuts remain ... which the squirrels run off with |
| 21:27.01 | Iriel | mutters darkly about oracle optimizers |
| 21:27.29 | Gnarfoz | at times, I get the impression they are sentient |
| 21:27.39 | Gnarfoz | (and mean-spirited) |
| 21:28.23 | Iriel | "today your job will take 20 minutes, tomorrow 3 1/2 days" |
| 21:28.33 | *** join/#wowuidev Seerah (~umsin@2601:3c2:101:320:64f9:56d6:4219:6d7f) |
| 21:28.33 | *** mode/#wowuidev [+o Seerah] by ChanServ |
| 21:28.49 | Gnarfoz | sadly, that usually means you did something wrong, but who knows what |
| 21:29.20 | Iriel | something == using oracle, sometimes. |
| 21:29.21 | Gnarfoz | and thus... optimizer hints, a perfect example of "fighting the symptoms" |
| 21:35.41 | foxlit | the subexpression is essentially independent of the outer query, so I would've wanted it to run first and transition to a simple "SELECT a FROM b WHERE b.c = ? AND ? BETWEEN b.f AND b.g" plan from that point forward. |
| 21:38.35 | foxlit | (but perhaps that's semantically different, since I'm not sure what it thinks it's supposed to do if the subquery returns multiple rows) |
| 21:41.11 | *** join/#wowuidev MentalPower (~textual@2604:4080:115e:8670:2ca4:f263:e666:d467) |
| 21:55.28 | Iriel | foxlit: I think you'd get two rows, one for each matching value from the 2nd table |
| 21:55.48 | Iriel | foxlit: Is there a primary key constraint or similar on the 2nd table that lets the DB know there could not possibly BE a second row? |
| 21:56.30 | foxlit | yes |
| 22:07.04 | Iriel | Hm, i wouldn't expect the explain plan to be horrible for that piece then. |
| 22:07.29 | foxlit | it comes up with these https://pastebin.com/aA56miRh (top for the original query, bottom for the WITH rephrasing) |
| 22:12.04 | Iriel | Maybe SQLITE just has a very simplistic query engine that more or less takes things as you give it them? |
| 22:18.24 | foxlit | I think there's supposed to be some query planner logic there that goes beyond "we just run what you tell us to run" |
| 22:19.49 | foxlit | executing the subquery for BETWEEN twice just seems weird :/ |
| 22:20.09 | Iriel | My guess is it turns the between into the two comparisons |
| 22:20.16 | Iriel | and doesn't optimize the common sub-expression |
| 22:20.51 | nevcairiel | honestly sqlite isnt the smartest dbms, in my experience it always suffered from mildly complex statements |
| 22:22.59 | Mr_Rabies | man i hope they do something to make trinkets easier to determine if they're an upgrade or not in 8.x :( |
| 22:23.10 | nevcairiel | maybe you can trick it somehow by doing something like SELECT b.a, (SELECT d FROM e WHERE e.f = ?) AS foo WHERE b.c = ? AND foo BETWEEN .... |
| 22:23.29 | nevcairiel | add missing FROM as appropriate |
| 22:24.35 | foxlit | that seems like inviting it to perform the subquery for each row :P |
| 22:24.53 | nevcairiel | the query as-is seems a bit weird anyway, w hat exactly is the subquery doing, it seems otherwise unrelated =p |
| 22:29.12 | foxlit | saving a database roundtrip; it looks up a numeric value by name and then finds the corresponding data row |
| 22:45.36 | *** join/#wowuidev Andols (~yaaic@62-20-145-33-no170.tbcn.telia.com) |
| 22:49.30 | *** join/#wowuidev ikcerog (~ikcerog@2601:400:6:286b:5551:ffd3:c0e0:8f5a) |
| 22:50.21 | *** join/#wowuidev ikcerog_ (~ikcerog@2601:40f:c101:d190:85c5:4fdf:3ae6:ebda) |
| 23:21.53 | *** join/#wowuidev modernist (~modernist@212.84.181.70) |
| 23:28.05 | *** join/#wowuidev MentalPower (~textual@2604:4080:115e:8670:95d4:45ab:990:842f) |
| 23:40.17 | *** join/#wowuidev modernist (~modernist@212.84.181.70) |
| 23:58.56 | *** join/#wowuidev dani_elle (~d@anon-35-156.vpn.ipredator.se) |
