'a ' = 'a ' by MySQL(Re: [pgsql-advocacy] Oracle buys Innobase)

On Wed, 19 Oct 2005 15:40:44 -0300 (ADT)
"Marc G. Fournier" <scrappy@postgresql.org> wrote:

> On Wed, 19 Oct 2005, Richard_D_Levine@raytheon.com wrote:
>
> > I was referring to trailing blanks, but did not explicitly say it,
> > though showed it in the examples.  I am pretty sure that the SQL
> > standard says that trailing whitespace is insignificant in string
> > comparison.
>
> Then we are broken too :)
>
> # select 'a ' = 'a  ';
>   ?column?
> ----------
>   f
> (1 row)
>
> ----

Here MySQL(4.0.20-Max-log) answer.  I'm not familiar with mysql but the
result was your expect.

--
mysql> select ' a' = '  a';
+--------------+
| ' a' = '  a' |
+--------------+
|            0 |
+--------------+
1 row in set (0.00 sec)

mysql> select ' a' = ' a';
+-------------+
| ' a' = ' a' |
+-------------+
|           1 |
+-------------+
1 row in set (0.00 sec)

mysql> select 'a ' = 'a   ';
+---------------+
| 'a ' = 'a   ' |
+---------------+
|             1 |
+---------------+
1 row in set (0.00 sec)

mysql>
--


==Jun
--
  J.Kuwamura
 rC Cm
   ^
   ~