Hi,
I've ran mysql tests on nvb79, and i got on test failed (archive_gis)
The test is very simple, here the command to have a failure :
SET storage_engine=archive;
CREATE TABLE gis_point (fid INTEGER, g POINT);
INSERT INTO gis_point VALUES
(101, PointFromText('POINT(10 10)')),
(102, PointFromText('POINT(20 10)')),
(103, PointFromText('POINT(20 20)')),
(104, PointFromWKB(AsWKB(PointFromText('POINT(10 20)'))));
SELECT fid, AsText(g) FROM gis_point ORDER by fid;
The select command doesn't show any output.
An other one shows the correct output.
mysql> SELECT fid, AsText(g) FROM gis_point ;
+------+--------------+
| fid | AsText(g) |
+------+--------------+
| 101 | POINT(10 10) |
| 102 | POINT(20 10) |
| 103 | POINT(20 20) |
| 104 | POINT(10 20) |
+------+--------------+
4 rows in set (0.00 sec)
That means it's the ORDER command which creates problem for this test.
Also, if i use the same database but with the mysqld coming from the
coolstack distribution, i can read the content :
(/opt/coolstack/mysql_32bit/bin/mysqld --user=mysql
--datadir=/var/mysql/5.0/data)
mysql> SELECT fid, AsText(g) FROM gis_point ORDER by fid;
+------+--------------+
| fid | AsText(g) |
+------+--------------+
| 101 | POINT(10 10) |
| 102 | POINT(20 10) |
| 103 | POINT(20 20) |
| 104 | POINT(10 20) |
+------+--------------+
4 rows in set (0.00 sec)
I've searched on configure/compilation options for mysqld on nvb79 but i
don't find any script doing it in the webstack source entry in
opensolaris.org.
Is somebody can compare the configuration of webstack and coolstack
environment ?
Thanks
Eric
