Re: [GENERAL] joined tables with USING and GROUPBY on the USING() column

2016-09-07 Thread Geoff Winkless
Thanks for the suggestions. Turns out I was right: I _was_ missing something obvious - results had token as char(4), tokens had token as varchar(4). Because the columns aren't the same they aren't treated as identical so the query builder won't accept the unqualified name. Next task is to work out

Re: [GENERAL] joined tables with USING and GROUPBY on the USING() column

2016-09-07 Thread Adrian Klaver
On 09/07/2016 01:11 PM, Geoff Winkless wrote: On 7 Sep 2016 9:01 p.m., "Adrian Klaver" mailto:adrian.kla...@aklaver.com>> wrote: What happens if you table qualify all the references to token? Oh it definitely fixes it; I was more confused why it works on one server and not another. I thought p

Re: [GENERAL] joined tables with USING and GROUPBY on the USING() column

2016-09-07 Thread Geoff Winkless
On 7 Sep 2016 9:01 p.m., "Adrian Klaver" wrote: > What happens if you table qualify all the references to token? Oh it definitely fixes it; I was more confused why it works on one server and not another. I thought perhaps there was a config option to allow more lax naming in this way. If not I'll

Re: [GENERAL] joined tables with USING and GROUPBY on the USING() column

2016-09-07 Thread John R Pierce
On 9/7/2016 12:53 PM, Geoff Winkless wrote: I'll start by saying that I'm sure I'm missing something obvious... I have a query that is working fine on all my servers except one. The only obvious difference is that the failing one is running 9.5.3, while most are running 9.5.4, but since the quer

Re: [GENERAL] joined tables with USING and GROUPBY on the USING() column

2016-09-07 Thread Adrian Klaver
On 09/07/2016 12:53 PM, Geoff Winkless wrote: I'll start by saying that I'm sure I'm missing something obvious... I have a query that is working fine on all my servers except one. The only obvious difference is that the failing one is running 9.5.3, while most are running 9.5.4, but since the qu

[GENERAL] joined tables with USING and GROUPBY on the USING() column

2016-09-07 Thread Geoff Winkless
I'll start by saying that I'm sure I'm missing something obvious... I have a query that is working fine on all my servers except one. The only obvious difference is that the failing one is running 9.5.3, while most are running 9.5.4, but since the query works on a 9.5.1 box I also have I can't ima