MySQL Lists: commits: svn commit - mysqldoc@docsrva: r955 - in trunk: . refman-4.1 refman-5.0 refman-5.1

List:	Commits	« Previous Message Next Message »
From:	paul	Date:	January 20 2006 7:42pm
Subject:	svn commit - mysqldoc@docsrva: r955 - in trunk: . refman-4.1 refman-5.0 refman-5.1
View as plain text
Author: paul
Date: 2006-01-20 20:42:09 +0100 (Fri, 20 Jan 2006)
New Revision: 955

Log:
 r2394@kite-hub:  paul | 2006-01-20 13:41:49 -0600
 Fix examples to printed pages.


Modified:
   trunk/
   trunk/refman-4.1/spatial-extensions.xml
   trunk/refman-5.0/spatial-extensions.xml
   trunk/refman-5.1/spatial-extensions.xml


Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6488
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2387
   + b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6488
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2394

Modified: trunk/refman-4.1/spatial-extensions.xml
===================================================================
--- trunk/refman-4.1/spatial-extensions.xml	2006-01-20 19:36:05 UTC (rev 954)
+++ trunk/refman-4.1/spatial-extensions.xml	2006-01-20 19:42:09 UTC (rev 955)
@@ -4989,30 +4989,30 @@
     -&gt; <userinput>'Polygon((30000 15000,31000 15000,31000 16000,30000 16000,30000 15000))';</userinput>
 mysql&gt; <userinput>SELECT fid,AsText(g) FROM geom WHERE</userinput>
     -&gt; <userinput>MBRContains(GeomFromText(@poly),g);</userinput>
-+-----+-----------------------------------------------------------------------------+
-| fid | AsText(g)                                                                   |
-+-----+-----------------------------------------------------------------------------+
-|  21 | LINESTRING(30350.4 15828.8,30350.6 15845,30333.8 15845,30333.8 15828.8)     |
-|  22 | LINESTRING(30350.6 15871.4,30350.6 15887.8,30334 15887.8,30334 15871.4)     |
-|  23 | LINESTRING(30350.6 15914.2,30350.6 15930.4,30334 15930.4,30334 15914.2)     |
-|  24 | LINESTRING(30290.2 15823,30290.2 15839.4,30273.4 15839.4,30273.4 15823)     |
-|  25 | LINESTRING(30291.4 15866.2,30291.6 15882.4,30274.8 15882.4,30274.8 15866.2) |
-|  26 | LINESTRING(30291.6 15918.2,30291.6 15934.4,30275 15934.4,30275 15918.2)     |
-| 249 | LINESTRING(30337.8 15938.6,30337.8 15946.8,30320.4 15946.8,30320.4 15938.4) |
-|   1 | LINESTRING(30250.4 15129.2,30248.8 15138.4,30238.2 15136.4,30240 15127.2)   |
-|   2 | LINESTRING(30220.2 15122.8,30217.2 15137.8,30207.6 15136,30210.4 15121)     |
-|   3 | LINESTRING(30179 15114.4,30176.6 15129.4,30167 15128,30169 15113)           |
-|   4 | LINESTRING(30155.2 15121.4,30140.4 15118.6,30142 15109,30157 15111.6)       |
-|   5 | LINESTRING(30192.4 15085,30177.6 15082.2,30179.2 15072.4,30194.2 15075.2)   |
-|   6 | LINESTRING(30244 15087,30229 15086.2,30229.4 15076.4,30244.6 15077)         |
-|   7 | LINESTRING(30200.6 15059.4,30185.6 15058.6,30186 15048.8,30201.2 15049.4)   |
-|  10 | LINESTRING(30179.6 15017.8,30181 15002.8,30190.8 15003.6,30189.6 15019)     |
-|  11 | LINESTRING(30154.2 15000.4,30168.6 15004.8,30166 15014.2,30151.2 15009.8)   |
-|  13 | LINESTRING(30105 15065.8,30108.4 15050.8,30118 15053,30114.6 15067.8)       |
-| 154 | LINESTRING(30276.2 15143.8,30261.4 15141,30263 15131.4,30278 15134)         |
-| 155 | LINESTRING(30269.8 15084,30269.4 15093.4,30258.6 15093,30259 15083.4)       |
-| 157 | LINESTRING(30128.2 15011,30113.2 15010.2,30113.6 15000.4,30128.8 15001)     |
-+-----+-----------------------------------------------------------------------------+
++-----+---------------------------------------------------------------+
+| fid | AsText(g)                                                     |
++-----+---------------------------------------------------------------+
+|  21 | LINESTRING(30350.4 15828.8,30350.6 15845,30333.8 15845,30 ... |
+|  22 | LINESTRING(30350.6 15871.4,30350.6 15887.8,30334 15887.8, ... |
+|  23 | LINESTRING(30350.6 15914.2,30350.6 15930.4,30334 15930.4, ... |
+|  24 | LINESTRING(30290.2 15823,30290.2 15839.4,30273.4 15839.4, ... |
+|  25 | LINESTRING(30291.4 15866.2,30291.6 15882.4,30274.8 15882. ... |
+|  26 | LINESTRING(30291.6 15918.2,30291.6 15934.4,30275 15934.4, ... |
+| 249 | LINESTRING(30337.8 15938.6,30337.8 15946.8,30320.4 15946. ... |
+|   1 | LINESTRING(30250.4 15129.2,30248.8 15138.4,30238.2 15136. ... |
+|   2 | LINESTRING(30220.2 15122.8,30217.2 15137.8,30207.6 15136, ... |
+|   3 | LINESTRING(30179 15114.4,30176.6 15129.4,30167 15128,3016 ... |
+|   4 | LINESTRING(30155.2 15121.4,30140.4 15118.6,30142 15109,30 ... |
+|   5 | LINESTRING(30192.4 15085,30177.6 15082.2,30179.2 15072.4, ... |
+|   6 | LINESTRING(30244 15087,30229 15086.2,30229.4 15076.4,3024 ... |
+|   7 | LINESTRING(30200.6 15059.4,30185.6 15058.6,30186 15048.8, ... |
+|  10 | LINESTRING(30179.6 15017.8,30181 15002.8,30190.8 15003.6, ... |
+|  11 | LINESTRING(30154.2 15000.4,30168.6 15004.8,30166 15014.2, ... |
+|  13 | LINESTRING(30105 15065.8,30108.4 15050.8,30118 15053,3011 ... |
+| 154 | LINESTRING(30276.2 15143.8,30261.4 15141,30263 15131.4,30 ... |
+| 155 | LINESTRING(30269.8 15084,30269.4 15093.4,30258.6 15093,30 ... |
+| 157 | LINESTRING(30128.2 15011,30113.2 15010.2,30113.6 15000.4, ... |
++-----+---------------------------------------------------------------+
 20 rows in set (0.00 sec)
 </programlisting>
 
@@ -5075,30 +5075,30 @@
     -&gt; <userinput>'Polygon((30000 15000,31000 15000,31000 16000,30000 16000,30000 15000))';</userinput>
 mysql&gt; <userinput>SELECT fid,AsText(g) FROM geom IGNORE INDEX (g) WHERE</userinput>
     -&gt; <userinput>MBRContains(GeomFromText(@poly),g);</userinput>
-+-----+-----------------------------------------------------------------------------+
-| fid | AsText(g)                                                                   |
-+-----+-----------------------------------------------------------------------------+
-|   1 | LINESTRING(30250.4 15129.2,30248.8 15138.4,30238.2 15136.4,30240 15127.2)   |
-|   2 | LINESTRING(30220.2 15122.8,30217.2 15137.8,30207.6 15136,30210.4 15121)     |
-|   3 | LINESTRING(30179 15114.4,30176.6 15129.4,30167 15128,30169 15113)           |
-|   4 | LINESTRING(30155.2 15121.4,30140.4 15118.6,30142 15109,30157 15111.6)       |
-|   5 | LINESTRING(30192.4 15085,30177.6 15082.2,30179.2 15072.4,30194.2 15075.2)   |
-|   6 | LINESTRING(30244 15087,30229 15086.2,30229.4 15076.4,30244.6 15077)         |
-|   7 | LINESTRING(30200.6 15059.4,30185.6 15058.6,30186 15048.8,30201.2 15049.4)   |
-|  10 | LINESTRING(30179.6 15017.8,30181 15002.8,30190.8 15003.6,30189.6 15019)     |
-|  11 | LINESTRING(30154.2 15000.4,30168.6 15004.8,30166 15014.2,30151.2 15009.8)   |
-|  13 | LINESTRING(30105 15065.8,30108.4 15050.8,30118 15053,30114.6 15067.8)       |
-|  21 | LINESTRING(30350.4 15828.8,30350.6 15845,30333.8 15845,30333.8 15828.8)     |
-|  22 | LINESTRING(30350.6 15871.4,30350.6 15887.8,30334 15887.8,30334 15871.4)     |
-|  23 | LINESTRING(30350.6 15914.2,30350.6 15930.4,30334 15930.4,30334 15914.2)     |
-|  24 | LINESTRING(30290.2 15823,30290.2 15839.4,30273.4 15839.4,30273.4 15823)     |
-|  25 | LINESTRING(30291.4 15866.2,30291.6 15882.4,30274.8 15882.4,30274.8 15866.2) |
-|  26 | LINESTRING(30291.6 15918.2,30291.6 15934.4,30275 15934.4,30275 15918.2)     |
-| 154 | LINESTRING(30276.2 15143.8,30261.4 15141,30263 15131.4,30278 15134)         |
-| 155 | LINESTRING(30269.8 15084,30269.4 15093.4,30258.6 15093,30259 15083.4)       |
-| 157 | LINESTRING(30128.2 15011,30113.2 15010.2,30113.6 15000.4,30128.8 15001)     |
-| 249 | LINESTRING(30337.8 15938.6,30337.8 15946.8,30320.4 15946.8,30320.4 15938.4) |
-+-----+-----------------------------------------------------------------------------+
++-----+---------------------------------------------------------------+
+| fid | AsText(g)                                                     |
++-----+---------------------------------------------------------------+
+|   1 | LINESTRING(30250.4 15129.2,30248.8 15138.4,30238.2 15136. ... |
+|   2 | LINESTRING(30220.2 15122.8,30217.2 15137.8,30207.6 15136, ... |
+|   3 | LINESTRING(30179 15114.4,30176.6 15129.4,30167 15128,3016 ... |
+|   4 | LINESTRING(30155.2 15121.4,30140.4 15118.6,30142 15109,30 ... |
+|   5 | LINESTRING(30192.4 15085,30177.6 15082.2,30179.2 15072.4, ... |
+|   6 | LINESTRING(30244 15087,30229 15086.2,30229.4 15076.4,3024 ... |
+|   7 | LINESTRING(30200.6 15059.4,30185.6 15058.6,30186 15048.8, ... |
+|  10 | LINESTRING(30179.6 15017.8,30181 15002.8,30190.8 15003.6, ... |
+|  11 | LINESTRING(30154.2 15000.4,30168.6 15004.8,30166 15014.2, ... |
+|  13 | LINESTRING(30105 15065.8,30108.4 15050.8,30118 15053,3011 ... |
+|  21 | LINESTRING(30350.4 15828.8,30350.6 15845,30333.8 15845,30 ... |
+|  22 | LINESTRING(30350.6 15871.4,30350.6 15887.8,30334 15887.8, ... |
+|  23 | LINESTRING(30350.6 15914.2,30350.6 15930.4,30334 15930.4, ... |
+|  24 | LINESTRING(30290.2 15823,30290.2 15839.4,30273.4 15839.4, ... |
+|  25 | LINESTRING(30291.4 15866.2,30291.6 15882.4,30274.8 15882. ... |
+|  26 | LINESTRING(30291.6 15918.2,30291.6 15934.4,30275 15934.4, ... |
+| 154 | LINESTRING(30276.2 15143.8,30261.4 15141,30263 15131.4,30 ... |
+| 155 | LINESTRING(30269.8 15084,30269.4 15093.4,30258.6 15093,30 ... |
+| 157 | LINESTRING(30128.2 15011,30113.2 15010.2,30113.6 15000.4, ... |
+| 249 | LINESTRING(30337.8 15938.6,30337.8 15946.8,30320.4 15946. ... |
++-----+---------------------------------------------------------------+
 20 rows in set (0.46 sec)
 </programlisting>
 

Modified: trunk/refman-5.0/spatial-extensions.xml
===================================================================
--- trunk/refman-5.0/spatial-extensions.xml	2006-01-20 19:36:05 UTC (rev 954)
+++ trunk/refman-5.0/spatial-extensions.xml	2006-01-20 19:42:09 UTC (rev 955)
@@ -5016,30 +5016,30 @@
     -&gt; <userinput>'Polygon((30000 15000,31000 15000,31000 16000,30000 16000,30000 15000))';</userinput>
 mysql&gt; <userinput>SELECT fid,AsText(g) FROM geom WHERE</userinput>
     -&gt; <userinput>MBRContains(GeomFromText(@poly),g);</userinput>
-+-----+-----------------------------------------------------------------------------+
-| fid | AsText(g)                                                                   |
-+-----+-----------------------------------------------------------------------------+
-|  21 | LINESTRING(30350.4 15828.8,30350.6 15845,30333.8 15845,30333.8 15828.8)     |
-|  22 | LINESTRING(30350.6 15871.4,30350.6 15887.8,30334 15887.8,30334 15871.4)     |
-|  23 | LINESTRING(30350.6 15914.2,30350.6 15930.4,30334 15930.4,30334 15914.2)     |
-|  24 | LINESTRING(30290.2 15823,30290.2 15839.4,30273.4 15839.4,30273.4 15823)     |
-|  25 | LINESTRING(30291.4 15866.2,30291.6 15882.4,30274.8 15882.4,30274.8 15866.2) |
-|  26 | LINESTRING(30291.6 15918.2,30291.6 15934.4,30275 15934.4,30275 15918.2)     |
-| 249 | LINESTRING(30337.8 15938.6,30337.8 15946.8,30320.4 15946.8,30320.4 15938.4) |
-|   1 | LINESTRING(30250.4 15129.2,30248.8 15138.4,30238.2 15136.4,30240 15127.2)   |
-|   2 | LINESTRING(30220.2 15122.8,30217.2 15137.8,30207.6 15136,30210.4 15121)     |
-|   3 | LINESTRING(30179 15114.4,30176.6 15129.4,30167 15128,30169 15113)           |
-|   4 | LINESTRING(30155.2 15121.4,30140.4 15118.6,30142 15109,30157 15111.6)       |
-|   5 | LINESTRING(30192.4 15085,30177.6 15082.2,30179.2 15072.4,30194.2 15075.2)   |
-|   6 | LINESTRING(30244 15087,30229 15086.2,30229.4 15076.4,30244.6 15077)         |
-|   7 | LINESTRING(30200.6 15059.4,30185.6 15058.6,30186 15048.8,30201.2 15049.4)   |
-|  10 | LINESTRING(30179.6 15017.8,30181 15002.8,30190.8 15003.6,30189.6 15019)     |
-|  11 | LINESTRING(30154.2 15000.4,30168.6 15004.8,30166 15014.2,30151.2 15009.8)   |
-|  13 | LINESTRING(30105 15065.8,30108.4 15050.8,30118 15053,30114.6 15067.8)       |
-| 154 | LINESTRING(30276.2 15143.8,30261.4 15141,30263 15131.4,30278 15134)         |
-| 155 | LINESTRING(30269.8 15084,30269.4 15093.4,30258.6 15093,30259 15083.4)       |
-| 157 | LINESTRING(30128.2 15011,30113.2 15010.2,30113.6 15000.4,30128.8 15001)     |
-+-----+-----------------------------------------------------------------------------+
++-----+---------------------------------------------------------------+
+| fid | AsText(g)                                                     |
++-----+---------------------------------------------------------------+
+|  21 | LINESTRING(30350.4 15828.8,30350.6 15845,30333.8 15845,30 ... |
+|  22 | LINESTRING(30350.6 15871.4,30350.6 15887.8,30334 15887.8, ... |
+|  23 | LINESTRING(30350.6 15914.2,30350.6 15930.4,30334 15930.4, ... |
+|  24 | LINESTRING(30290.2 15823,30290.2 15839.4,30273.4 15839.4, ... |
+|  25 | LINESTRING(30291.4 15866.2,30291.6 15882.4,30274.8 15882. ... |
+|  26 | LINESTRING(30291.6 15918.2,30291.6 15934.4,30275 15934.4, ... |
+| 249 | LINESTRING(30337.8 15938.6,30337.8 15946.8,30320.4 15946. ... |
+|   1 | LINESTRING(30250.4 15129.2,30248.8 15138.4,30238.2 15136. ... |
+|   2 | LINESTRING(30220.2 15122.8,30217.2 15137.8,30207.6 15136, ... |
+|   3 | LINESTRING(30179 15114.4,30176.6 15129.4,30167 15128,3016 ... |
+|   4 | LINESTRING(30155.2 15121.4,30140.4 15118.6,30142 15109,30 ... |
+|   5 | LINESTRING(30192.4 15085,30177.6 15082.2,30179.2 15072.4, ... |
+|   6 | LINESTRING(30244 15087,30229 15086.2,30229.4 15076.4,3024 ... |
+|   7 | LINESTRING(30200.6 15059.4,30185.6 15058.6,30186 15048.8, ... |
+|  10 | LINESTRING(30179.6 15017.8,30181 15002.8,30190.8 15003.6, ... |
+|  11 | LINESTRING(30154.2 15000.4,30168.6 15004.8,30166 15014.2, ... |
+|  13 | LINESTRING(30105 15065.8,30108.4 15050.8,30118 15053,3011 ... |
+| 154 | LINESTRING(30276.2 15143.8,30261.4 15141,30263 15131.4,30 ... |
+| 155 | LINESTRING(30269.8 15084,30269.4 15093.4,30258.6 15093,30 ... |
+| 157 | LINESTRING(30128.2 15011,30113.2 15010.2,30113.6 15000.4, ... |
++-----+---------------------------------------------------------------+
 20 rows in set (0.00 sec)
 </programlisting>
 
@@ -5102,30 +5102,30 @@
     -&gt; <userinput>'Polygon((30000 15000,31000 15000,31000 16000,30000 16000,30000 15000))';</userinput>
 mysql&gt; <userinput>SELECT fid,AsText(g) FROM geom IGNORE INDEX (g) WHERE</userinput>
     -&gt; <userinput>MBRContains(GeomFromText(@poly),g);</userinput>
-+-----+-----------------------------------------------------------------------------+
-| fid | AsText(g)                                                                   |
-+-----+-----------------------------------------------------------------------------+
-|   1 | LINESTRING(30250.4 15129.2,30248.8 15138.4,30238.2 15136.4,30240 15127.2)   |
-|   2 | LINESTRING(30220.2 15122.8,30217.2 15137.8,30207.6 15136,30210.4 15121)     |
-|   3 | LINESTRING(30179 15114.4,30176.6 15129.4,30167 15128,30169 15113)           |
-|   4 | LINESTRING(30155.2 15121.4,30140.4 15118.6,30142 15109,30157 15111.6)       |
-|   5 | LINESTRING(30192.4 15085,30177.6 15082.2,30179.2 15072.4,30194.2 15075.2)   |
-|   6 | LINESTRING(30244 15087,30229 15086.2,30229.4 15076.4,30244.6 15077)         |
-|   7 | LINESTRING(30200.6 15059.4,30185.6 15058.6,30186 15048.8,30201.2 15049.4)   |
-|  10 | LINESTRING(30179.6 15017.8,30181 15002.8,30190.8 15003.6,30189.6 15019)     |
-|  11 | LINESTRING(30154.2 15000.4,30168.6 15004.8,30166 15014.2,30151.2 15009.8)   |
-|  13 | LINESTRING(30105 15065.8,30108.4 15050.8,30118 15053,30114.6 15067.8)       |
-|  21 | LINESTRING(30350.4 15828.8,30350.6 15845,30333.8 15845,30333.8 15828.8)     |
-|  22 | LINESTRING(30350.6 15871.4,30350.6 15887.8,30334 15887.8,30334 15871.4)     |
-|  23 | LINESTRING(30350.6 15914.2,30350.6 15930.4,30334 15930.4,30334 15914.2)     |
-|  24 | LINESTRING(30290.2 15823,30290.2 15839.4,30273.4 15839.4,30273.4 15823)     |
-|  25 | LINESTRING(30291.4 15866.2,30291.6 15882.4,30274.8 15882.4,30274.8 15866.2) |
-|  26 | LINESTRING(30291.6 15918.2,30291.6 15934.4,30275 15934.4,30275 15918.2)     |
-| 154 | LINESTRING(30276.2 15143.8,30261.4 15141,30263 15131.4,30278 15134)         |
-| 155 | LINESTRING(30269.8 15084,30269.4 15093.4,30258.6 15093,30259 15083.4)       |
-| 157 | LINESTRING(30128.2 15011,30113.2 15010.2,30113.6 15000.4,30128.8 15001)     |
-| 249 | LINESTRING(30337.8 15938.6,30337.8 15946.8,30320.4 15946.8,30320.4 15938.4) |
-+-----+-----------------------------------------------------------------------------+
++-----+---------------------------------------------------------------+
+| fid | AsText(g)                                                     |
++-----+---------------------------------------------------------------+
+|   1 | LINESTRING(30250.4 15129.2,30248.8 15138.4,30238.2 15136. ... |
+|   2 | LINESTRING(30220.2 15122.8,30217.2 15137.8,30207.6 15136, ... |
+|   3 | LINESTRING(30179 15114.4,30176.6 15129.4,30167 15128,3016 ... |
+|   4 | LINESTRING(30155.2 15121.4,30140.4 15118.6,30142 15109,30 ... |
+|   5 | LINESTRING(30192.4 15085,30177.6 15082.2,30179.2 15072.4, ... |
+|   6 | LINESTRING(30244 15087,30229 15086.2,30229.4 15076.4,3024 ... |
+|   7 | LINESTRING(30200.6 15059.4,30185.6 15058.6,30186 15048.8, ... |
+|  10 | LINESTRING(30179.6 15017.8,30181 15002.8,30190.8 15003.6, ... |
+|  11 | LINESTRING(30154.2 15000.4,30168.6 15004.8,30166 15014.2, ... |
+|  13 | LINESTRING(30105 15065.8,30108.4 15050.8,30118 15053,3011 ... |
+|  21 | LINESTRING(30350.4 15828.8,30350.6 15845,30333.8 15845,30 ... |
+|  22 | LINESTRING(30350.6 15871.4,30350.6 15887.8,30334 15887.8, ... |
+|  23 | LINESTRING(30350.6 15914.2,30350.6 15930.4,30334 15930.4, ... |
+|  24 | LINESTRING(30290.2 15823,30290.2 15839.4,30273.4 15839.4, ... |
+|  25 | LINESTRING(30291.4 15866.2,30291.6 15882.4,30274.8 15882. ... |
+|  26 | LINESTRING(30291.6 15918.2,30291.6 15934.4,30275 15934.4, ... |
+| 154 | LINESTRING(30276.2 15143.8,30261.4 15141,30263 15131.4,30 ... |
+| 155 | LINESTRING(30269.8 15084,30269.4 15093.4,30258.6 15093,30 ... |
+| 157 | LINESTRING(30128.2 15011,30113.2 15010.2,30113.6 15000.4, ... |
+| 249 | LINESTRING(30337.8 15938.6,30337.8 15946.8,30320.4 15946. ... |
++-----+---------------------------------------------------------------+
 20 rows in set (0.46 sec)
 </programlisting>
 

Modified: trunk/refman-5.1/spatial-extensions.xml
===================================================================
--- trunk/refman-5.1/spatial-extensions.xml	2006-01-20 19:36:05 UTC (rev 954)
+++ trunk/refman-5.1/spatial-extensions.xml	2006-01-20 19:42:09 UTC (rev 955)
@@ -5013,30 +5013,30 @@
     -&gt; <userinput>'Polygon((30000 15000,31000 15000,31000 16000,30000 16000,30000 15000))';</userinput>
 mysql&gt; <userinput>SELECT fid,AsText(g) FROM geom WHERE</userinput>
     -&gt; <userinput>MBRContains(GeomFromText(@poly),g);</userinput>
-+-----+-----------------------------------------------------------------------------+
-| fid | AsText(g)                                                                   |
-+-----+-----------------------------------------------------------------------------+
-|  21 | LINESTRING(30350.4 15828.8,30350.6 15845,30333.8 15845,30333.8 15828.8)     |
-|  22 | LINESTRING(30350.6 15871.4,30350.6 15887.8,30334 15887.8,30334 15871.4)     |
-|  23 | LINESTRING(30350.6 15914.2,30350.6 15930.4,30334 15930.4,30334 15914.2)     |
-|  24 | LINESTRING(30290.2 15823,30290.2 15839.4,30273.4 15839.4,30273.4 15823)     |
-|  25 | LINESTRING(30291.4 15866.2,30291.6 15882.4,30274.8 15882.4,30274.8 15866.2) |
-|  26 | LINESTRING(30291.6 15918.2,30291.6 15934.4,30275 15934.4,30275 15918.2)     |
-| 249 | LINESTRING(30337.8 15938.6,30337.8 15946.8,30320.4 15946.8,30320.4 15938.4) |
-|   1 | LINESTRING(30250.4 15129.2,30248.8 15138.4,30238.2 15136.4,30240 15127.2)   |
-|   2 | LINESTRING(30220.2 15122.8,30217.2 15137.8,30207.6 15136,30210.4 15121)     |
-|   3 | LINESTRING(30179 15114.4,30176.6 15129.4,30167 15128,30169 15113)           |
-|   4 | LINESTRING(30155.2 15121.4,30140.4 15118.6,30142 15109,30157 15111.6)       |
-|   5 | LINESTRING(30192.4 15085,30177.6 15082.2,30179.2 15072.4,30194.2 15075.2)   |
-|   6 | LINESTRING(30244 15087,30229 15086.2,30229.4 15076.4,30244.6 15077)         |
-|   7 | LINESTRING(30200.6 15059.4,30185.6 15058.6,30186 15048.8,30201.2 15049.4)   |
-|  10 | LINESTRING(30179.6 15017.8,30181 15002.8,30190.8 15003.6,30189.6 15019)     |
-|  11 | LINESTRING(30154.2 15000.4,30168.6 15004.8,30166 15014.2,30151.2 15009.8)   |
-|  13 | LINESTRING(30105 15065.8,30108.4 15050.8,30118 15053,30114.6 15067.8)       |
-| 154 | LINESTRING(30276.2 15143.8,30261.4 15141,30263 15131.4,30278 15134)         |
-| 155 | LINESTRING(30269.8 15084,30269.4 15093.4,30258.6 15093,30259 15083.4)       |
-| 157 | LINESTRING(30128.2 15011,30113.2 15010.2,30113.6 15000.4,30128.8 15001)     |
-+-----+-----------------------------------------------------------------------------+
++-----+---------------------------------------------------------------+
+| fid | AsText(g)                                                     |
++-----+---------------------------------------------------------------+
+|  21 | LINESTRING(30350.4 15828.8,30350.6 15845,30333.8 15845,30 ... |
+|  22 | LINESTRING(30350.6 15871.4,30350.6 15887.8,30334 15887.8, ... |
+|  23 | LINESTRING(30350.6 15914.2,30350.6 15930.4,30334 15930.4, ... |
+|  24 | LINESTRING(30290.2 15823,30290.2 15839.4,30273.4 15839.4, ... |
+|  25 | LINESTRING(30291.4 15866.2,30291.6 15882.4,30274.8 15882. ... |
+|  26 | LINESTRING(30291.6 15918.2,30291.6 15934.4,30275 15934.4, ... |
+| 249 | LINESTRING(30337.8 15938.6,30337.8 15946.8,30320.4 15946. ... |
+|   1 | LINESTRING(30250.4 15129.2,30248.8 15138.4,30238.2 15136. ... |
+|   2 | LINESTRING(30220.2 15122.8,30217.2 15137.8,30207.6 15136, ... |
+|   3 | LINESTRING(30179 15114.4,30176.6 15129.4,30167 15128,3016 ... |
+|   4 | LINESTRING(30155.2 15121.4,30140.4 15118.6,30142 15109,30 ... |
+|   5 | LINESTRING(30192.4 15085,30177.6 15082.2,30179.2 15072.4, ... |
+|   6 | LINESTRING(30244 15087,30229 15086.2,30229.4 15076.4,3024 ... |
+|   7 | LINESTRING(30200.6 15059.4,30185.6 15058.6,30186 15048.8, ... |
+|  10 | LINESTRING(30179.6 15017.8,30181 15002.8,30190.8 15003.6, ... |
+|  11 | LINESTRING(30154.2 15000.4,30168.6 15004.8,30166 15014.2, ... |
+|  13 | LINESTRING(30105 15065.8,30108.4 15050.8,30118 15053,3011 ... |
+| 154 | LINESTRING(30276.2 15143.8,30261.4 15141,30263 15131.4,30 ... |
+| 155 | LINESTRING(30269.8 15084,30269.4 15093.4,30258.6 15093,30 ... |
+| 157 | LINESTRING(30128.2 15011,30113.2 15010.2,30113.6 15000.4, ... |
++-----+---------------------------------------------------------------+
 20 rows in set (0.00 sec)
 </programlisting>
 
@@ -5099,30 +5099,30 @@
     -&gt; <userinput>'Polygon((30000 15000,31000 15000,31000 16000,30000 16000,30000 15000))';</userinput>
 mysql&gt; <userinput>SELECT fid,AsText(g) FROM geom IGNORE INDEX (g) WHERE</userinput>
     -&gt; <userinput>MBRContains(GeomFromText(@poly),g);</userinput>
-+-----+-----------------------------------------------------------------------------+
-| fid | AsText(g)                                                                   |
-+-----+-----------------------------------------------------------------------------+
-|   1 | LINESTRING(30250.4 15129.2,30248.8 15138.4,30238.2 15136.4,30240 15127.2)   |
-|   2 | LINESTRING(30220.2 15122.8,30217.2 15137.8,30207.6 15136,30210.4 15121)     |
-|   3 | LINESTRING(30179 15114.4,30176.6 15129.4,30167 15128,30169 15113)           |
-|   4 | LINESTRING(30155.2 15121.4,30140.4 15118.6,30142 15109,30157 15111.6)       |
-|   5 | LINESTRING(30192.4 15085,30177.6 15082.2,30179.2 15072.4,30194.2 15075.2)   |
-|   6 | LINESTRING(30244 15087,30229 15086.2,30229.4 15076.4,30244.6 15077)         |
-|   7 | LINESTRING(30200.6 15059.4,30185.6 15058.6,30186 15048.8,30201.2 15049.4)   |
-|  10 | LINESTRING(30179.6 15017.8,30181 15002.8,30190.8 15003.6,30189.6 15019)     |
-|  11 | LINESTRING(30154.2 15000.4,30168.6 15004.8,30166 15014.2,30151.2 15009.8)   |
-|  13 | LINESTRING(30105 15065.8,30108.4 15050.8,30118 15053,30114.6 15067.8)       |
-|  21 | LINESTRING(30350.4 15828.8,30350.6 15845,30333.8 15845,30333.8 15828.8)     |
-|  22 | LINESTRING(30350.6 15871.4,30350.6 15887.8,30334 15887.8,30334 15871.4)     |
-|  23 | LINESTRING(30350.6 15914.2,30350.6 15930.4,30334 15930.4,30334 15914.2)     |
-|  24 | LINESTRING(30290.2 15823,30290.2 15839.4,30273.4 15839.4,30273.4 15823)     |
-|  25 | LINESTRING(30291.4 15866.2,30291.6 15882.4,30274.8 15882.4,30274.8 15866.2) |
-|  26 | LINESTRING(30291.6 15918.2,30291.6 15934.4,30275 15934.4,30275 15918.2)     |
-| 154 | LINESTRING(30276.2 15143.8,30261.4 15141,30263 15131.4,30278 15134)         |
-| 155 | LINESTRING(30269.8 15084,30269.4 15093.4,30258.6 15093,30259 15083.4)       |
-| 157 | LINESTRING(30128.2 15011,30113.2 15010.2,30113.6 15000.4,30128.8 15001)     |
-| 249 | LINESTRING(30337.8 15938.6,30337.8 15946.8,30320.4 15946.8,30320.4 15938.4) |
-+-----+-----------------------------------------------------------------------------+
++-----+---------------------------------------------------------------+
+| fid | AsText(g)                                                     |
++-----+---------------------------------------------------------------+
+|   1 | LINESTRING(30250.4 15129.2,30248.8 15138.4,30238.2 15136. ... |
+|   2 | LINESTRING(30220.2 15122.8,30217.2 15137.8,30207.6 15136, ... |
+|   3 | LINESTRING(30179 15114.4,30176.6 15129.4,30167 15128,3016 ... |
+|   4 | LINESTRING(30155.2 15121.4,30140.4 15118.6,30142 15109,30 ... |
+|   5 | LINESTRING(30192.4 15085,30177.6 15082.2,30179.2 15072.4, ... |
+|   6 | LINESTRING(30244 15087,30229 15086.2,30229.4 15076.4,3024 ... |
+|   7 | LINESTRING(30200.6 15059.4,30185.6 15058.6,30186 15048.8, ... |
+|  10 | LINESTRING(30179.6 15017.8,30181 15002.8,30190.8 15003.6, ... |
+|  11 | LINESTRING(30154.2 15000.4,30168.6 15004.8,30166 15014.2, ... |
+|  13 | LINESTRING(30105 15065.8,30108.4 15050.8,30118 15053,3011 ... |
+|  21 | LINESTRING(30350.4 15828.8,30350.6 15845,30333.8 15845,30 ... |
+|  22 | LINESTRING(30350.6 15871.4,30350.6 15887.8,30334 15887.8, ... |
+|  23 | LINESTRING(30350.6 15914.2,30350.6 15930.4,30334 15930.4, ... |
+|  24 | LINESTRING(30290.2 15823,30290.2 15839.4,30273.4 15839.4, ... |
+|  25 | LINESTRING(30291.4 15866.2,30291.6 15882.4,30274.8 15882. ... |
+|  26 | LINESTRING(30291.6 15918.2,30291.6 15934.4,30275 15934.4, ... |
+| 154 | LINESTRING(30276.2 15143.8,30261.4 15141,30263 15131.4,30 ... |
+| 155 | LINESTRING(30269.8 15084,30269.4 15093.4,30258.6 15093,30 ... |
+| 157 | LINESTRING(30128.2 15011,30113.2 15010.2,30113.6 15000.4, ... |
+| 249 | LINESTRING(30337.8 15938.6,30337.8 15946.8,30320.4 15946. ... |
++-----+---------------------------------------------------------------+
 20 rows in set (0.46 sec)
 </programlisting>
Thread
• svn commit - mysqldoc@docsrva: r955 - in trunk: . refman-4.1 refman-5.0 refman-5.1	paul	20 Jan