| 00:00.19 | *** join/#storm wallflower (n=wallflow@ip-205-246-113-216.pool.grokthis.net) |
| 01:05.09 | jml | hi |
| 01:05.28 | jml | why doesn't count() inherit the distinct value from the result set by default? |
| 01:07.01 | jml | oh, it's considered a bug. yay. (bug 217644) |
| 01:07.02 | mup | Bug #217644: ResultSet aggregates do not respect distinct option <Storm:In Progress> <https://launchpad.net/bugs/217644> |
| 01:13.21 | *** join/#storm artista_frustrad (n=artista_@201-25-141-174.ctame704.dsl.brasiltelecom.net.br) |
| 02:29.20 | jml | is there a way to get at the column object that Asc or Desc wraps? |
| 03:10.23 | jml | what about a way to get at the FROM clause inference stuff? |
| 04:04.16 | *** part/#storm spats (n=spats@mail.fitness2live.com.au) |
| 04:19.20 | *** join/#storm mwhudson (n=mwh@canonical/launchpad/mwhudson) |
| 04:19.24 | jml | so |
| 04:19.56 | jamesh | jml: a Desc object has a .expr member which holds the subexpression |
| 04:20.06 | jamesh | I am not quite sure what you're trying to do though. |
| 04:20.27 | jml | jamesh: I've shelved that tangent for a while |
| 04:20.32 | jamesh | as for count + distinct, a fix was included in the 0.14 release but backed out right after because it broke some stuff |
| 04:21.35 | jml | *nod* |
| 04:21.49 | jml | the more interesting problem is related to the FROM clause inference question |
| 04:22.00 | jml | I'm just figuring out how to phrase it succinctly |
| 04:22.44 | jamesh | what are you trying to do exactly? |
| 04:22.44 | jml | I have a table, Foo. I have some arbitrary-ish storm expressions to filter Foo. I want to make sure that the result set is filtered by Bar.name, where Bar is left joined to Foo. |
| 04:22.59 | jml | change that last 'filtered' to 'sorted' |
| 04:24.03 | jml | AIUI, I have to use 'using' to left join |
| 04:24.18 | jml | which means I have to specify *all* the tables to use in the query |
| 04:24.29 | jamesh | if you want to do a left join, yes you have to use store.using() |
| 04:24.39 | jamesh | do you really have to specify them all? |
| 04:25.11 | jamesh | it's been a while since I checked how it worked exactly |
| 04:25.25 | jml | I have trouble following the code in store.py myself. |
| 04:25.54 | jml | but my tests raise errors about tables not being in from clauses when I fail to specify all tables. |
| 04:28.33 | jml | so, I'd like to avoid explicitly listing tables where I can. |
| 04:29.37 | jamesh | okay. Looks like using() overrides the automatically gathered tables found during compilation |
| 04:31.11 | jml | is there something I can do to get at those automatically gathered tables and thus append them to my using() arguments? |
| 04:31.40 | jamesh | the automatic where clause generation happens during statement compilation: As it sees column objects in the expression tree, it records the associated tables. The compiler for the Select() object use this automatically gathered tables list if an explicit list hasn't been specified. |
| 04:31.48 | jamesh | let me check. |
| 04:38.27 | jml | thanks |
| 04:38.47 | jamesh | jml: http://paste.ubuntu.com/118711/ <- that's a basic example of how the automatic where clause generation works |
| 04:39.28 | jml | jamesh: rockin' |
| 04:40.07 | jamesh | that Select() compile function will compile all the other clauses before doing FROM, so picks up stuff from WHERE, ORDER BY, GROUP BY, etc |
| 04:40.47 | jamesh | there is also some logic to handle sub-selects in the expression compiler so things don't leak |
| 06:02.07 | *** join/#storm jukart (n=jukart@d91-128-122-97.cust.tele2.at) |
| 06:34.11 | *** join/#storm jukart (i=lovely@81.189.156.94) |
| 08:42.31 | *** join/#storm goschtl (n=goschtl@p5B0BC76B.dip.t-dialin.net) |
| 08:56.20 | *** join/#storm sidnei (n=sidnei@plone/dreamcatcher) |
| 09:07.36 | *** join/#storm oubiwann (n=oubiwann@host217-45-210-54.in-addr.btopenworld.com) |
| 09:08.09 | *** join/#storm jkakar (n=jkakar@host217-45-210-54.in-addr.btopenworld.com) |
| 09:19.27 | *** join/#storm niemeyer (n=niemeyer@host217-45-210-54.in-addr.btopenworld.com) |
| 09:42.31 | *** join/#storm mcella (n=mcella@ip-142-248.sn3.eutelia.it) |
| 10:57.42 | mup | storm/trunk r292 committed by gustavo@niemeyer.net |
| 10:57.42 | mup | Added the new GenerationalCache with a faster implementation of |
| 10:57.42 | mup | the caching API (by Jeroen Vermeulen). [r=radix,sidnei,niemeyer] |
| 11:20.56 | *** part/#storm mcella (n=mcella@ip-142-248.sn3.eutelia.it) |
| 12:27.10 | *** join/#storm andrea-bs (n=andrea-b@ubuntu/member/beeseek.developer.andrea-bs) |
| 12:59.53 | *** part/#storm kripken (n=alon@89-139-154-186.bb.netvision.net.il) |
| 13:58.22 | *** join/#storm andrea-bs (n=andrea-b@ubuntu/member/beeseek.developer.andrea-bs) |
| 14:34.55 | *** part/#storm bigdog (n=scmikes@72-197-8-8-arpa.cust.cinci.current.net) |
| 14:37.47 | *** join/#storm thumper (n=tim@canonical/launchpad/thumper) |
| 14:45.10 | *** join/#storm thumper (n=tim@canonical/launchpad/thumper) |
| 14:45.29 | *** join/#storm bigdog (n=scmikes@72-197-8-8-arpa.cust.cinci.current.net) |
| 15:14.56 | *** join/#storm goschtl (n=goschtl@p5B0BC76B.dip.t-dialin.net) |
| 15:29.19 | *** join/#storm andrea-bs (n=andrea-b@ubuntu/member/beeseek.developer.andrea-bs) |
| 15:44.10 | *** join/#storm goschtl (n=goschtl@p5B0BC76B.dip.t-dialin.net) |
| 16:20.26 | *** join/#storm niemeyer_ (n=niemeyer@host217-45-210-54.in-addr.btopenworld.com) |
| 16:38.02 | *** join/#storm jukart (i=lovely@81.189.156.94) |
| 17:09.08 | *** join/#storm mwhudson (n=mwh@canonical/launchpad/mwhudson) |
| 17:42.03 | *** join/#storm jukart (n=jukart@d91-128-122-97.cust.tele2.at) |
| 18:17.47 | *** join/#storm shaunm (n=shaunm@proxyserver.wolfram.com) |
| 18:27.57 | *** join/#storm thumper_laptop (n=tim@canonical/launchpad/thumper) |
| 18:42.27 | *** join/#storm _thumper_ (n=tim@canonical/launchpad/thumper) |
| 19:02.29 | *** join/#storm vvinet (n=vince@132.210.76.204) |
| 19:30.13 | *** join/#storm bac (n=bac@cpe-065-190-187-178.nc.res.rr.com) |
| 21:14.09 | *** join/#storm sidnei (n=sidnei@plone/dreamcatcher) |
| 21:29.39 | *** join/#storm tlynn (n=tlynn@212.44.6.81) |
| 22:38.48 | *** join/#storm bsdemon (n=bsdemon@89.112.49.75) |