bug with isclose() in 4.1

Hi,

how-to-repeat:

mysql> create table a (a blob);
Query OK, 0 rows affected (0.00 sec)

mysql> insert into a values (linestring(point(0,0), point(1,1), point(2,2),
point(3,4), point(0,0)));
Query OK, 1 row affected (0.00 sec)

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

mysql> insert into a values (linestring(point(0,0), point(1,1), point(2,2),
point(3,4), point(0,1)));
Query OK, 1 row affected (0.00 sec)

mysql> select isclosed(a) from a;
+-------------+
| isclosed(a) |
+-------------+
| 0 |
| 0 |
+-------------+
2 rows in set (0.00 sec)

first row is a linearring, second one isn't, but it returns 0 for both.

Regards

Georg

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13518@lists.mysql.com
To unsubscribe, e-mail

Re: bug with isclose() in 4.1

Georg Richter writes:
> On Friday 17 January 2003 23:24, Georg Richter wrote:
>
> Sorry, this report is bogus.
> Table A was still in a merge table union (and it's definition changed).
>
> Regards
>
> Georg
>

OK,

no problem.

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13520@lists.mysql.com
To unsubscribe, e-mail