common table expression, which is what kepstin is talking about
2012-10-31 30555, 2012
ocharles
(that WITH stuff)
2012-10-31 30523, 2012
ocharles
WITH outer AS (SELECT foo, bar FROM sometable WHERE ...) UPDATE somecolumn = foo USING outer WHERE someothercolumn = bar;
2012-10-31 30527, 2012
ocharles
I think that's right
2012-10-31 30553, 2012
ocharles
I don't think you need a CTE actually, UPDATE ... USING (SELECT ) WHERE blah; should work, no?
2012-10-31 30547, 2012
nikki
using using just gives me syntax errors :/
2012-10-31 30558, 2012
ocharles
it might be FROM then
2012-10-31 30511, 2012
kepstin-work
yeah... update ... using isn't syntax supported in postgresql
2012-10-31 30513, 2012
ocharles
yea, it's FROM, sorry
2012-10-31 30515, 2012
voiceinsideyou joined the channel
2012-10-31 30523, 2012
nikki
what I don't get is that I must have done this before, yet this time it totally stumped me :/
2012-10-31 30510, 2012
ocharles
UPDATE somecolumn = foo FROM (SELECT foo, bar FROM sometable where ..) WHERE someothercolumn = bar;
2012-10-31 30511, 2012
nikki
wooo finally
2012-10-31 30529, 2012
nikki
thanks :D
2012-10-31 30533, 2012
Freso joined the channel
2012-10-31 30509, 2012
Mineo
is there a hidden setting to make jira subscribe me automatically to issues I comment on?
2012-10-31 30552, 2012
nikki
probably not :/
2012-10-31 30506, 2012
reoafk joined the channel
2012-10-31 30513, 2012
Freso
Is there a reason STYLE-* isn't sent to mb-bugs?
2012-10-31 30550, 2012
kepstin-work
or for that matter, to mb-style ;)
2012-10-31 30547, 2012
Freso
Well, about everything else going on in JIRA is sent to mb-bugs, so I'd find it more natural to see them there.
2012-10-31 30559, 2012
nikki
everything else in jira is developer stuff :P
2012-10-31 30530, 2012
kepstin-work
hmm. actually, sending them to -style would probably be a good idea.
2012-10-31 30500, 2012
Freso
Developers know how to set up filters for "Subject: .*(STYLE-.*)" > /dev/null.
2012-10-31 30511, 2012
Freso
If they don't want to read them.
2012-10-31 30558, 2012
hawke_1
But they shouldn’t have to.
2012-10-31 30511, 2012
hawke_1
Unless there’s a good reason that developers should see STYLE bugs
2012-10-31 30519, 2012
hawke_1
but I can’t see one
2012-10-31 30551, 2012
nikki
somewhat relevant to this discussion: I was discussing with reoafk yesterday whether instrument requests should be style tickets rather than trying to track them on a big long wiki page
2012-10-31 30516, 2012
hawke_1
Hmm…that would make some sense, I think
2012-10-31 30523, 2012
hawke_1
Though it would be a lot of tickets
2012-10-31 30548, 2012
hawke_1
Actually, instruments should be entities. ;-)
2012-10-31 30554, 2012
Freso
"This list is a read-only automated notification of changes in our bug tracking system. This list is quite high traffic as an email is sent to this list whenever someone enters or changes a bug. " - doesn't mention anything about mb-bugs being only for devs.
2012-10-31 30557, 2012
nikki already entered the ticket for that :P
2012-10-31 30530, 2012
Freso
On the contrary, "This list is a read-only automated notification of changes in our bug tracking system." would suggest all change notifications, not a subset of it only relevant for devs.
2012-10-31 30508, 2012
hawke_1
In that case, I agree.
2012-10-31 30526, 2012
nikki
the big advantage is that people would be able to watch tickets for instruments they want added, so they'll know when it does get added
2012-10-31 30542, 2012
nikki
and jira has a full content view which displays tickets with all the comments on a big long page, if people want a big long page to look at like we have now :P
2012-10-31 30512, 2012
kurtjx joined the channel
2012-10-31 30530, 2012
ocharles
SELECT * FROM revision_path a, revision_path b WHERE a.parent_revision_id = b.parent_revision_id AND a.revision_id = 12 AND b.revision_id = 13 ORDER BY a.distance asc, b.distance asc LIMIT 1; -- find a common ancestor between revisions
2012-10-31 30531, 2012
ocharles
<3 NES
2012-10-31 30532, 2012
mb-chat-logger
♥
2012-10-31 30559, 2012
CatCat
<3
2012-10-31 30500, 2012
mb-chat-logger
♥
2012-10-31 30502, 2012
CatCat
huh
2012-10-31 30548, 2012
nikki
are we going to get rid of that or should I just block the damn thing already?
2012-10-31 30518, 2012
CatCat
c|~
2012-10-31 30522, 2012
CatCat
what no ♪?
2012-10-31 30527, 2012
CatCat
probably block it nikki
2012-10-31 30545, 2012
ianmcorvidae
warp: yes, it should be 16 in DBDefs.pm.default, nobody updated that at the schema change
2012-10-31 30549, 2012
reosarevok joined the channel
2012-10-31 30549, 2012
nikki
I don't even know why it was added
2012-10-31 30559, 2012
CatCat is a bit confused why à is up but ~ isn't
2012-10-31 30527, 2012
nikki
hm?
2012-10-31 30531, 2012
CatCat
i man i press alt ¨ a and i get ã but i press just alt ¨i get ~
2012-10-31 30550, 2012
CatCat
why isn't ~ higher up
2012-10-31 30558, 2012
hawke_1
Ooh, ♩
2012-10-31 30505, 2012
hawke_1 learns some new compose shortcuts
2012-10-31 30508, 2012
kepstin-work
the vertical position of the ~ character depends on the font.
2012-10-31 30513, 2012
CatCat
ah
2012-10-31 30530, 2012
CatCat
💝 what do you guys see?
2012-10-31 30535, 2012
hawke_1
♪♩♮♬
2012-10-31 30541, 2012
hawke_1
I see a square with 0419fd in it
2012-10-31 30554, 2012
Zaphodbeeblebrox
huh it works here
2012-10-31 30557, 2012
Zaphodbeeblebrox
but not an image
2012-10-31 30557, 2012
nikki
I see lion's scary emoji stuff
2012-10-31 30505, 2012
CatCat
yea
2012-10-31 30512, 2012
CatCat
I don't get the emoji stuff
2012-10-31 30524, 2012
CatCat
💝 aha! can ciscumvent
2012-10-31 30526, 2012
CatCat
no!
2012-10-31 30536, 2012
CatCat
i chose to circumvent it!
2012-10-31 30539, 2012
CatCat
:(
2012-10-31 30515, 2012
CatCat
many of these plain text ones are better than the image/icon/emoji
2012-10-31 30523, 2012
CatCat
like 💖
2012-10-31 30530, 2012
CatCat
it's black font thing is awesome
2012-10-31 30517, 2012
CatCat
"SMILING CAT FACE WITH HEART-SHAPED EYES"
2012-10-31 30520, 2012
CatCat
seriously?
2012-10-31 30507, 2012
CatCat
🇯🇵
2012-10-31 30522, 2012
Zaphodbeeblebrox
hehe that can't see a japanese flag
2012-10-31 30508, 2012
CatCat
骁 should i be amused that catq there is ma-yao
2012-10-31 30529, 2012
hawke_1 joined the channel
2012-10-31 30519, 2012
CatCat
hey cool i can disable it
2012-10-31 30529, 2012
CatCat
by putting it IN THE TRASH
2012-10-31 30520, 2012
CatCat
natta has mb- d- evel
2012-10-31 30524, 2012
CatCat
hash*
2012-10-31 30555, 2012
reosarevok
warp, nikki: so, should I ask something to the IA people about CAA-47 or is something we can do from our side with this CORS stuff?
(as in, should I ask what happened and why it wasn't a 503)
2012-10-31 30519, 2012
nikki
I guess so
2012-10-31 30541, 2012
reosarevok
Ok
2012-10-31 30533, 2012
ianmcorvidae
ianmcorvidae has changed the topic to: tropical week! | http://musicbrainz.org/#devel | Next meeting: reviews, decoupling search server from web service (ocharles), log analysis project (ocharles), MBS-3665 (ian)
2012-10-31 30541, 2012
bitmap
reosarevok: I'm not sure what you mean on MBS-5476...I thought that ticket was for it (wrongly) selecting an instrument, but there's no instrument field when editing a work…
