List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 21 1999 4:00am
Subject:Re: join + group by + concat(INT,...) Problem! (3.22.26a)
View as plain text  
On Tue, 1999-09-21 05:49:59 +0200, Benjamin Pflugmann wrote:
> > I don't know, what the "standard" behaviour than should be ...?
> 
> Hm. IMHO, the dashes should be there, since int(1) should only
> affect the size of the column 'i1', not the size of the expression
> concat(...).

Yep, this sounds very reasonable.

> So I think, it should be "---100---" in the result.

Seconded!

Andrew, it's time for a bug report, using mysqlbug, of course ... ;-)

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
join + group by + concat(INT,...) Problem! (3.22.26a)Andrew Shirrayev21 Sep
  • Re: join + group by + concat(INT,...) Problem! (3.22.26a)Benjamin Pflugmann21 Sep
    • Re: join + group by + concat(INT,...) Problem! (3.22.26a)Martin Ramsch21 Sep
      • Re: join + group by + concat(INT,...) Problem! (3.22.26a)Bob Kline21 Sep
        • Re: join + group by + concat(INT,...) Problem! (3.22.26a)Michael Widenius22 Sep
          • Re: join + group by + concat(INT,...) Problem! (3.22.26a)Bob Kline22 Sep
      • Re: join + group by + concat(INT,...) Problem! (3.22.26a)Benjamin Pflugmann21 Sep
        • Re: join + group by + concat(INT,...) Problem! (3.22.26a)Martin Ramsch21 Sep
      • Re: join + group by + concat(INT,...) Problem! (3.22.26a)Michael Widenius22 Sep
    • Re: join + group by + concat(INT,...) Problem! (3.22.26a)Andrew Shirrayev21 Sep