| --- Log opened Wed Jul 25 00:00:08 2007 |
| 02:32 | | ChalcyLaptop [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has quit [Ping Timeout] |
| 02:33 | | gnolam [lenin@Nightstar-13557.8.5.253.se.wasadata.net] has quit [Quit: Z?] |
| 02:34 | | Forjadon [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has joined #code |
| 02:34 | | mode/#code [+o Forjadon] by ChanServ |
| 02:54 | | Forjadon is now known as ChalcyLaptop |
| 03:15 | | Vornicus is now known as Vornicus-Latens |
| 03:51 | | Reiver is now known as ReivClass |
| 05:19 | | Forj [~Forj@Nightstar-17168.ue.woosh.co.nz] has joined #code |
| 05:42 | | Serah [~Z@87.72.35.ns-3885] has quit [Connection reset by peer] |
| 05:42 | | KarmaBot [~fark.off@87.72.35.ns-3885] has quit [Connection reset by peer] |
| 05:44 | | KarmaBot [~fark.off@87.72.35.ns-3885] has joined #Code |
| 05:44 | | mode/#code [+v KarmaBot] by ChanServ |
| 05:44 | | Serah [~Z@87.72.35.ns-3885] has joined #Code |
| 05:44 | | mode/#code [+o Serah] by ChanServ |
| 05:49 | | Serah [~Z@87.72.35.ns-3885] has quit [Connection reset by peer] |
| 05:49 | | Serah [~Z@87.72.35.ns-3885] has joined #Code |
| 05:50 | | mode/#code [+o Serah] by ChanServ |
| 06:06 | | ReivClass is now known as Reiver |
| 06:18 | | ChalcyLaptop [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has quit [Ping Timeout] |
| 06:19 | | Forjadon [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has joined #code |
| 06:19 | | mode/#code [+o Forjadon] by ChanServ |
| 06:19 | | Forjadon is now known as ChalcyLaptop |
| 07:02 | | Forjadon [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has joined #code |
| 07:02 | | mode/#code [+o Forjadon] by ChanServ |
| 07:03 | | ChalcyLaptop [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has quit [Ping Timeout] |
| 07:03 | | Forjadon is now known as ChalcyLaptop |
| 10:03 | | You're now known as TheWatcher |
| 10:09 | | ChalcyLaptop [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has quit [Ping Timeout] |
| 10:18 | | Forjadon [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has joined #code |
| 10:18 | | mode/#code [+o Forjadon] by ChanServ |
| 10:19 | | Forjadon is now known as ChalcyLaptop |
| 10:36 | | Forjadon [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has joined #code |
| 10:36 | | mode/#code [+o Forjadon] by ChanServ |
| 10:37 | | ChalcyLaptop [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has quit [Ping Timeout] |
| 10:37 | | Forjadon is now known as ChalcyLaptop |
| 10:47 | | ChalcyLaptop [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has quit [Quit: slep] |
| 10:50 | | Forj [~Forj@Nightstar-17168.ue.woosh.co.nz] has quit [Quit: Gone] |
| 12:28 | | Forjadon [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has joined #code |
| 12:28 | | mode/#code [+o Forjadon] by ChanServ |
| 12:36 | | MyCatVerbs [~rb6822@Nightstar-23335.cs.bris.ac.uk] has joined #code |
| 12:40 | | Forjadon [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has quit [Ping Timeout] |
| 12:47 | | Forjadon [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has joined #code |
| 12:47 | | mode/#code [+o Forjadon] by ChanServ |
| 12:57 | | Forjadon [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has quit [Ping Timeout] |
| 12:59 | | Forjadon [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has joined #code |
| 12:59 | | mode/#code [+o Forjadon] by ChanServ |
| 13:21 | | Forjadon [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has quit [Quit: Leaving] |
| 13:37 | | gnolam [lenin@Nightstar-13557.8.5.253.se.wasadata.net] has joined #Code |
| 13:37 | | mode/#code [+o gnolam] by ChanServ |
| 14:28 | | MyCatVerbs [~rb6822@Nightstar-23335.cs.bris.ac.uk] has quit [Quit: Swim, swim, hungry!] |
| 14:38 | | MyCatVerbs [~rb6822@Nightstar-23335.cs.bris.ac.uk] has joined #code |
| 15:03 | < jerith> | SQLmeisters, I have a question. |
| 15:04 | | * Vornicus-Latens is a SQLmonger. |
| 15:19 | | * ToxicFrog has some small familiarity with it. |
| 15:19 | | * ToxicFrog has also LJposted his util.lua, at long last |
| 15:20 | <@ToxicFrog> | (it has come to my awareness that everyone in #lua has one, and they're all named util.lua for reason.) |
| 15:20 | <@ToxicFrog> | *for some reason. |
| 15:20 | <@ToxicFrog> | ("I'm putting that in my util.lua" is commonly heard.) |
| 15:22 | < jerith> | Sorry, sudden meeting came up. |
| 15:22 | | Reiver is now known as ReivZzz |
| 15:23 | < jerith> | I have a table that has two notable fields and a timestamp. |
| 15:23 | < jerith> | 'Night Reiv. |
| 15:23 | < jerith> | One of the fields is unique, the other is not. |
| 15:23 | < jerith> | There are some situations where I want to find the most recent versions of the second notable field. |
| 15:24 | | * ToxicFrog hands you over to Vorn >.> |
| 15:24 | < jerith> | For example: |
| 15:25 | < jerith> | foo1 bar1 12h30 |
| 15:25 | < jerith> | foo2 bar1 13h15 |
| 15:25 | < jerith> | foo3 bar2 11H45 |
| 15:25 | < Vornicus-Latens> | ok. |
| 15:26 | < jerith> | I want a query that returns the last two rows there. |
| 15:26 | < Vornicus-Latens> | not too hard, let me see if I can remember. |
| 15:27 | < jerith> | The real situation is a little more complex in that there are creation and update timestamps, but I can get a single canonical timestamp out of that. |
| 15:28 | < Vornicus-Latens> | Do I get subqueries? |
| 15:28 | < jerith> | You do. |
| 15:28 | < jerith> | (This is actually a subquery in something bigger.) |
| 15:28 | < Vornicus-Latens> | ok. |
| 15:29 | < jerith> | We want to try to minimise them, though. |
| 15:29 | < jerith> | Nesting them too big in a table that grows linearly with... well, something that's growing... |
| 15:32 | < Vornicus-Latens> | right. |
| 15:36 | < Vornicus-Latens> | SELECT * FROM footab WHERE (bar, time) IN (SELECT bar, max(time) FROM footab GROUP BY bar); <--- I think that does it. |
| 15:46 | < jerith> | Unless I'm messign something up, that only gives me one result. |
| 15:48 | < jerith> | The subquery seems fine. |
| 16:00 | | Vornotron [~vorn@64.252.101.ns-10959] has joined #code |
| 16:01 | | Vornicus-Latens [~vorn@Admin.Nightstar.Net] has quit [Ping Timeout] |
| 16:10 | < jerith> | Vorn: Did you get my two responses to your SQL? |
| 16:35 | < Vornotron> | I got them, yes. |
| 16:36 | < Vornotron> | The subquery seems fine, but you're only getting one response. |
| 16:36 | < Vornotron> | hm. |
| 16:36 | | Vornotron [~vorn@Admin.Nightstar.Net] has quit [Connection reset by peer] |
| 16:37 | < jerith> | The subquery gives me what I expect. |
| 16:38 | | Vornotron [~vorn@64.252.96.ns-12308] has joined #code |
| 16:38 | | Vornotron is now known as Vornicus |
| 16:39 | < Vornicus> | I say, "hm." |
| 16:43 | < jerith> | I'm guessing MySQL doesn't do the IN as expected. |
| 16:45 | < Vornicus> | posibly |
| 16:47 | | MyCatVerbs [~rb6822@Nightstar-23335.cs.bris.ac.uk] has quit [Quit: Swim, swim, hungry!] |
| 17:01 | < jerith> | Ah well, I'll think about it some more tomorrow. |
| 17:01 | < jerith> | Thanks for your help. |
| 17:11 | | Otto_Flick [lenin@Nightstar-13557.8.5.253.se.wasadata.net] has joined #Code |
| 17:11 | | gnolam [lenin@Nightstar-13557.8.5.253.se.wasadata.net] has quit [Ping Timeout] |
| 17:11 | | Otto_Flick is now known as gnolam |
| 17:18 | | gnolam [lenin@Nightstar-13557.8.5.253.se.wasadata.net] has quit [Ping Timeout] |
| 17:35 | | gnolam [lenin@Nightstar-13557.8.5.253.se.wasadata.net] has joined #Code |
| 17:35 | | mode/#code [+o gnolam] by ChanServ |
| 17:46 | | Otto_Flick [lenin@Nightstar-13557.8.5.253.se.wasadata.net] has joined #Code |
| 17:46 | | gnolam [lenin@Nightstar-13557.8.5.253.se.wasadata.net] has quit [Ping Timeout] |
| 17:49 | | Otto_Flick is now known as gnolam |
| 18:12 | | gnolam [lenin@Nightstar-13557.8.5.253.se.wasadata.net] has quit [Ping Timeout] |
| 18:12 | | gnolam [lenin@Nightstar-13557.8.5.253.se.wasadata.net] has joined #Code |
| 18:12 | | mode/#code [+o gnolam] by ChanServ |
| 18:57 | | gnolam [lenin@Nightstar-13557.8.5.253.se.wasadata.net] has quit [Ping Timeout] |
| 19:23 | | Forj [~Forj@Nightstar-17168.ue.woosh.co.nz] has joined #code |
| 19:32 | | AnnoDomini [~farkoff@Nightstar-29480.neoplus.adsl.tpnet.pl] has joined #Code |
| 19:32 | | mode/#code [+o AnnoDomini] by ChanServ |
| 20:00 | | Forj [~Forj@Nightstar-17168.ue.woosh.co.nz] has quit [Quit: Gone] |
| 20:02 | | Forjadon [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has joined #code |
| 20:02 | | mode/#code [+o Forjadon] by ChanServ |
| 20:05 | | Forjadon is now known as ChalcyLaptop |
| 20:28 | | gnolam [lenin@Nightstar-13557.8.5.253.se.wasadata.net] has joined #Code |
| 20:28 | | mode/#code [+o gnolam] by ChanServ |
| 21:15 | | ChalcyLaptop [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has quit [Ping Timeout] |
| 21:44 | | Forjadon [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has joined #code |
| 21:44 | | mode/#code [+o Forjadon] by ChanServ |
| 21:59 | | You're now known as TheWatcher[T-2] |
| 22:03 | | You're now known as TheWatcher[zZzZ] |
| 22:42 | | Forjadon [~Forjadon@Nightstar-17168.ue.woosh.co.nz] has quit [Ping Timeout] |
| 23:29 | | Thaqui [~Thaqui@Nightstar-17986.jetstream.xtra.co.nz] has joined #code |
| 23:29 | | mode/#code [+o Thaqui] by ChanServ |
| --- Log closed Thu Jul 26 00:00:14 2007 |