This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new f042acb76a5 [fix] correct numeric, spatial, and quantile function doc
errors (#3713)
f042acb76a5 is described below
commit f042acb76a591fd70d59d8b47bbbaecb7873bf72
Author: boluor <[email protected]>
AuthorDate: Wed May 20 08:59:48 2026 -0700
[fix] correct numeric, spatial, and quantile function doc errors (#3713)
## Summary
Fixes 25 small documentation issues across the numeric, spatial, and
quantile function references. Each item below is independent.
### numeric-functions
- **gcd.md** — result-table header showed `gcd(17,31)` while the query
was `gcd(-17, 31)`. Header now matches the query (table widened by 1
character to fit).
- **ln.md** — special-case note said `+inf` returns NULL, but the
example with `+inf` returns `Infinity`. Note updated to reflect actual
behavior.
- **random.md** — parameter description said the upper bound `<b>` must
be "less than the lower bound"; corrected to "greater than".
- **log10.md / log2.md** — description called these the "natural
logarithm"; they are not (natural log is `LN`/`LOG` with one arg).
Dropped "natural".
- **log.md** — Syntax was `LOG(<b>[, <x>])`, but `log(3)` actually
returns `ln(3)`. Rewrote Syntax as `LOG([<b>, ]<x>)` and clarified
parameter semantics: 1-arg form = natural log; 2-arg form = log base `b`
of `x`.
- **asinh.md** — six result-table blocks were fenced as ```sql instead
of ```text; corrected so they render as plain monospaced output.
- **even.md / lcm.md** — misaligned result-table borders aligned.
- **signbit.md** — one example showed `0`/`1` while the others showed
`false`/`true`; unified to boolean.
- **xor.md** — frontmatter title was `"XOR | Numeric Functions"`
(siblings use just the function name); changed to `"XOR"`. The example's
SQL and result table were inside the same ```sql fence; split into
```sql + ```text fences.
- **truncate.md** — typo `litera` → `literal`.
### spatial-functions
- Spatial docs had `## Sytax` (instead of `Syntax`) and `## Retuen
Value` (instead of `Return Value`) in roughly 18 files; corrected. (The
same typo `## Sytax` also appeared in
`date-time-functions/unix-timestamp.md` — fixed there as well.)
- **st-angle-sphere.md** — Chinese heading `## 参数` in an English doc →
`## Parameters`. Parameter rows were ordered `x_lng, y_lng, x_lat,
y_lat`; reordered to match the Syntax `x_lng, x_lat, y_lng, y_lat`.
- **st-astext.md** — section heading `# Parameters` (H1) → `##
Parameters` (H2).
- **st-area-square-km.md** — result-table headers had
`st_area_square_Km` (capital K); changed to lowercase. Type list typos
`Geopolygon,GeoCircle,GeoMuitiPolygon` and `GeoMultiCircle` corrected to
`GeoPolygon, GeoCircle, GeoMultiPolygon`.
- **st-circle.md** — `<center_lat>` valid range was given as `[-180,
180]`; corrected to `[-90, 90]`.
- **st-distance-sphere.md** — parameter rows had mismatched
name/description (`y_lng` was described as "Latitude of X", etc.);
descriptions now match the canonical `x_lng / x_lat / y_lng / y_lat`
order. One example labeled "Two identical points (returns 0)" actually
used different coordinates and returned a non-zero distance; relabeled.
- **st-distance.md** — result-table header showed
`ST_Distance(ST_Point(0,0), ST_Point(1,0))` while the query used
`ST_GeometryFromText(...)`; header now matches.
- **st-linefromtext.md** — WKT keyword `LINE` → `LINESTRING` in the
parameter description. The "multiple vertices" example showed raw binary
geometry output; wrapped with `ST_AsText(...)` so the result displays
human-readable WKT (consistent with the convention used in Apache Sedona
and similar to what PostGIS shows except more readable). Mislabeled
example caption corrected.
- **st-touches.md / st-contains.md / st-intersects.md / st-point.md /
st-asbinary.md** — full-width punctuation (`。`, `)`) inside English text
replaced with ASCII.
- **st-disjoint.md** — result block was missing its closing table
border; added.
### quantile-functions
- **to-quantile-state.md** — Syntax `TO_QUANTILE_STATE(<raw_data>
<compression>)` was missing the comma between args.
## Test plan
- [ ] CI doc build passes
- [ ] Spot-check the affected pages render correctly (table alignment,
Syntax/Return-Value headings, `LOG` syntax, `ST_LineFromText` result now
readable WKT, spatial parameter rows in canonical order)
---
.../scalar-functions/numeric-functions/asinh.md | 12 +++++------
.../scalar-functions/numeric-functions/even.md | 24 +++++++++++-----------
.../scalar-functions/numeric-functions/gcd.md | 10 ++++-----
.../scalar-functions/numeric-functions/lcm.md | 10 ++++-----
.../scalar-functions/numeric-functions/ln.md | 2 +-
.../scalar-functions/numeric-functions/log.md | 6 +++---
.../scalar-functions/numeric-functions/log10.md | 4 ++--
.../scalar-functions/numeric-functions/log2.md | 4 ++--
.../scalar-functions/numeric-functions/random.md | 2 +-
.../scalar-functions/numeric-functions/signbit.md | 2 +-
.../scalar-functions/numeric-functions/truncate.md | 2 +-
.../scalar-functions/numeric-functions/xor.md | 8 +++++---
.../quantile-functions/to-quantile-state.md | 2 +-
.../spatial-functions/st-angle-sphere.md | 8 ++++----
.../scalar-functions/spatial-functions/st-angle.md | 4 ++--
.../spatial-functions/st-area-square-km.md | 12 +++++------
.../spatial-functions/st-area-square-meters.md | 2 +-
.../spatial-functions/st-asbinary.md | 6 +++---
.../spatial-functions/st-astext.md | 4 ++--
.../spatial-functions/st-azimuth.md | 4 ++--
.../spatial-functions/st-circle.md | 6 +++---
.../spatial-functions/st-contains.md | 6 +++---
.../spatial-functions/st-disjoint.md | 3 ++-
.../spatial-functions/st-distance-sphere.md | 12 +++++------
.../spatial-functions/st-distance.md | 10 ++++-----
.../spatial-functions/st-intersects.md | 6 +++---
.../spatial-functions/st-linefromtext.md | 21 +++++++++----------
.../scalar-functions/spatial-functions/st-point.md | 4 ++--
.../spatial-functions/st-polygon.md | 2 +-
.../spatial-functions/st-touches.md | 4 ++--
.../scalar-functions/spatial-functions/st-x.md | 4 ++--
.../scalar-functions/spatial-functions/st-y.md | 4 ++--
.../scalar-functions/numeric-functions/asinh.md | 12 +++++------
.../scalar-functions/numeric-functions/gcd.md | 10 ++++-----
.../scalar-functions/numeric-functions/signbit.md | 2 +-
.../scalar-functions/numeric-functions/xor.md | 2 +-
.../quantile-functions/to-quantile-state.md | 2 +-
.../spatial-functions/st-area-square-km.md | 4 ++--
.../spatial-functions/st-distance.md | 10 ++++-----
.../quantile-functions/to-quantile-state.md | 2 +-
.../scalar-functions/numeric-functions/xor.md | 2 +-
.../quantile-functions/to-quantile-state.md | 2 +-
.../spatial-functions/st-area-square-km.md | 4 ++--
.../scalar-functions/numeric-functions/asinh.md | 12 +++++------
.../scalar-functions/numeric-functions/gcd.md | 10 ++++-----
.../scalar-functions/numeric-functions/signbit.md | 2 +-
.../scalar-functions/numeric-functions/xor.md | 2 +-
.../quantile-functions/to-quantile-state.md | 2 +-
.../spatial-functions/st-area-square-km.md | 4 ++--
.../spatial-functions/st-distance.md | 10 ++++-----
.../date-time-functions/unix-timestamp.md | 2 +-
.../scalar-functions/numeric-functions/log10.md | 4 ++--
.../scalar-functions/numeric-functions/log2.md | 4 ++--
.../scalar-functions/numeric-functions/random.md | 2 +-
.../scalar-functions/numeric-functions/truncate.md | 2 +-
.../quantile-functions/to-quantile-state.md | 2 +-
.../date-time-functions/unix-timestamp.md | 2 +-
.../scalar-functions/numeric-functions/log.md | 6 +++---
.../scalar-functions/numeric-functions/log10.md | 4 ++--
.../scalar-functions/numeric-functions/log2.md | 4 ++--
.../scalar-functions/numeric-functions/random.md | 2 +-
.../scalar-functions/numeric-functions/truncate.md | 2 +-
.../scalar-functions/numeric-functions/xor.md | 8 +++++---
.../quantile-functions/to-quantile-state.md | 2 +-
.../spatial-functions/st-angle-sphere.md | 8 ++++----
.../scalar-functions/spatial-functions/st-angle.md | 4 ++--
.../spatial-functions/st-area-square-km.md | 12 +++++------
.../spatial-functions/st-area-square-meters.md | 2 +-
.../spatial-functions/st-asbinary.md | 6 +++---
.../spatial-functions/st-astext.md | 4 ++--
.../spatial-functions/st-azimuth.md | 4 ++--
.../spatial-functions/st-circle.md | 6 +++---
.../spatial-functions/st-contains.md | 6 +++---
.../spatial-functions/st-disjoint.md | 3 ++-
.../spatial-functions/st-distance-sphere.md | 12 +++++------
.../spatial-functions/st-intersects.md | 6 +++---
.../spatial-functions/st-linefromtext.md | 21 +++++++++----------
.../scalar-functions/spatial-functions/st-point.md | 4 ++--
.../spatial-functions/st-polygon.md | 2 +-
.../spatial-functions/st-touches.md | 4 ++--
.../scalar-functions/spatial-functions/st-x.md | 4 ++--
.../scalar-functions/spatial-functions/st-y.md | 4 ++--
.../scalar-functions/numeric-functions/asinh.md | 12 +++++------
.../scalar-functions/numeric-functions/even.md | 24 +++++++++++-----------
.../scalar-functions/numeric-functions/gcd.md | 10 ++++-----
.../scalar-functions/numeric-functions/lcm.md | 10 ++++-----
.../scalar-functions/numeric-functions/ln.md | 2 +-
.../scalar-functions/numeric-functions/log.md | 6 +++---
.../scalar-functions/numeric-functions/log10.md | 4 ++--
.../scalar-functions/numeric-functions/log2.md | 4 ++--
.../scalar-functions/numeric-functions/random.md | 2 +-
.../scalar-functions/numeric-functions/signbit.md | 2 +-
.../scalar-functions/numeric-functions/truncate.md | 2 +-
.../scalar-functions/numeric-functions/xor.md | 8 +++++---
.../quantile-functions/to-quantile-state.md | 2 +-
.../spatial-functions/st-angle-sphere.md | 8 ++++----
.../scalar-functions/spatial-functions/st-angle.md | 4 ++--
.../spatial-functions/st-area-square-km.md | 12 +++++------
.../spatial-functions/st-area-square-meters.md | 2 +-
.../spatial-functions/st-asbinary.md | 6 +++---
.../spatial-functions/st-astext.md | 4 ++--
.../spatial-functions/st-azimuth.md | 4 ++--
.../spatial-functions/st-circle.md | 6 +++---
.../spatial-functions/st-contains.md | 6 +++---
.../spatial-functions/st-disjoint.md | 3 ++-
.../spatial-functions/st-distance-sphere.md | 12 +++++------
.../spatial-functions/st-distance.md | 10 ++++-----
.../spatial-functions/st-intersects.md | 6 +++---
.../spatial-functions/st-linefromtext.md | 21 +++++++++----------
.../scalar-functions/spatial-functions/st-point.md | 4 ++--
.../spatial-functions/st-polygon.md | 2 +-
.../spatial-functions/st-touches.md | 4 ++--
.../scalar-functions/spatial-functions/st-x.md | 4 ++--
.../scalar-functions/spatial-functions/st-y.md | 4 ++--
114 files changed, 339 insertions(+), 333 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
index f57da2a3292..f4e9c9bd8cb 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
@@ -41,7 +41,7 @@ The asinh value of parameter `x`.
select asinh(0.0);
```
-```sql
+```text
+------------+
| asinh(0.0) |
+------------+
@@ -53,7 +53,7 @@ select asinh(0.0);
select asinh(1.0);
```
-```sql
+```text
+-------------------+
| asinh(1.0) |
+-------------------+
@@ -65,7 +65,7 @@ select asinh(1.0);
select asinh(-1.0);
```
-```sql
+```text
+--------------------+
| asinh(-1.0) |
+--------------------+
@@ -77,7 +77,7 @@ select asinh(-1.0);
select asinh(cast('nan' as double));
```
-```sql
+```text
+------------------------------+
| asinh(cast('nan' AS DOUBLE)) |
+------------------------------+
@@ -89,7 +89,7 @@ select asinh(cast('nan' as double));
select asinh(cast('inf' as double));
```
-```sql
+```text
+------------------------------+
| asinh(cast('inf' AS DOUBLE)) |
+------------------------------+
@@ -101,7 +101,7 @@ select asinh(cast('inf' as double));
select asinh(cast('-inf' as double));
```
-```sql
+```text
+-------------------------------+
| asinh(cast('-inf' AS DOUBLE)) |
+-------------------------------+
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/even.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/even.md
index fbde1fb6980..5cda06950eb 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/even.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/even.md
@@ -58,11 +58,11 @@ select even(2.9);
```
```text
-+----------+
++-----------+
| even(2.9) |
-+----------+
-| 4 |
-+----------+
++-----------+
+| 4 |
++-----------+
```
```sql
@@ -70,11 +70,11 @@ select even(-2.9);
```
```text
-+-----------+
++------------+
| even(-2.9) |
-+-----------+
-| -4 |
-+-----------+
++------------+
+| -4 |
++------------+
```
```sql
@@ -82,11 +82,11 @@ select even(4);
```
```text
-+--------+
++---------+
| even(4) |
-+--------+
-| 4 |
-+--------+
++---------+
+| 4 |
++---------+
```
```sql
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
index 4cd1b30a3e9..9bda011df8c 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
@@ -67,11 +67,11 @@ select gcd(-17, 31);
```
```text
-+-------------+
-| gcd(17,31) |
-+-------------+
-| 1 |
-+-------------+
++--------------+
+| gcd(-17,31) |
++--------------+
+| 1 |
++--------------+
```
```sql
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/lcm.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/lcm.md
index cda84aa799e..f80bfb31450 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/lcm.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/lcm.md
@@ -79,11 +79,11 @@ select lcm(-4, 6);
```
```text
-+------------+
-| lcm(-4,6) |
-+------------+
-| 12|
-+------------+
++-----------+
+| lcm(-4,6) |
++-----------+
+| 12 |
++-----------+
```
```sql
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/ln.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/ln.md
index 06179dbcaf8..1a63204b52b 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/ln.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/ln.md
@@ -32,7 +32,7 @@ Return a float-point number. Special cases:
- If x IS NULL, return NULL
- If x IS NaN, return NaN
-- If x is positive infinity or negative infinity, return NULL
+- If x is positive infinity, return Infinity
## Example
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/log.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/log.md
index 1909f9f106a..47ce08b90bb 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/log.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/log.md
@@ -13,15 +13,15 @@ Returns the logarithm of `x` based on base `b`.
## Syntax
```sql
-LOG(<b>[, <x>])
+LOG([<b>, ]<x>)
```
## Parameters
| Parameter | Description |
|-----------|------------|
-| `<b>` | Base should be greater than 0 and not be exactly 1.0 |
-| `<x>` | optional, Antilogarithm should be greater than 0, default value
is e |
+| `<b>` | Optional. Base should be greater than 0 and not be exactly 1.0.
If omitted, the natural logarithm (base e) is computed. |
+| `<x>` | Antilogarithm should be greater than 0 |
## Return value
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
index 9a94b6a69ee..9bfc7d71bff 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
@@ -2,13 +2,13 @@
{
"title": "LOG10",
"language": "en",
- "description": "Returns the natural logarithm of x to base 10."
+ "description": "Returns the logarithm of x to base 10."
}
---
## Description
-Returns the natural logarithm of `x` to base `10`.
+Returns the logarithm of `x` to base `10`.
## Alias
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
index 09032f5ae94..3c54ab0d8ab 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
@@ -2,13 +2,13 @@
{
"title": "LOG2",
"language": "en",
- "description": "Returns the natural logarithm of x to base 2."
+ "description": "Returns the logarithm of x to base 2."
}
---
## Description
-Returns the natural logarithm of `x` to base `2`.
+Returns the logarithm of `x` to base `2`.
## Syntax
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
index 210c3580b99..ee759b25cf2 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
@@ -32,7 +32,7 @@ RANDOM(<a> , <b>) -- Generates a random number between a and b
|-----------|------------|
| `<seed>` | random number generator seed. Returns a fixed sequence of random
numbers between 0 and 1. |
| `<a>` | The lower bound of a random number. |
-| `<b>` | The upper bound of a random number. It must be less than the lower
bound. |
+| `<b>` | The upper bound of a random number. It must be greater than the
lower bound. |
## Return value
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
index 00e52bae911..253d79e0146 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
@@ -92,6 +92,6 @@ select signbit(cast('+0.0' as double)) , signbit(cast('-0.0'
as double));
+---------------------------------+---------------------------------+
| signbit(cast('+0.0' as double)) | signbit(cast('-0.0' as double)) |
+---------------------------------+---------------------------------+
-| 0 | 1 |
+| false | true |
+---------------------------------+---------------------------------+
```
\ No newline at end of file
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
index 6821e966fbb..4640241e034 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
@@ -37,7 +37,7 @@ If d is a column, and the first argument is of type Decimal,
then the resulting
## Example
- d is a litera
+ d is a literal
```sql
select truncate(124.3867, 2),truncate(124.3867, 0),truncate(124.3867, -2);
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
index c06787546ae..27ea25ac769 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
@@ -1,6 +1,6 @@
---
{
- "title": "XOR | Numeric Functions",
+ "title": "XOR",
"language": "en",
"description": "Return the XOR value of two numbers.",
"sidebar_label": "XOR"
@@ -19,13 +19,15 @@ Return the XOR value of two numbers.
## Example
```sql
-mysql >select true xor false,true xor true;
+mysql> select true xor false, true xor true;
+```
+
+```text
+------------------+-----------------+
| (TRUE XOR FALSE) | (TRUE XOR TRUE) |
+------------------+-----------------+
| 1 | 0 |
+------------------+-----------------+
-
```
## Keywords
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
b/docs/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
index ec5038f6c7b..92c61ddefee 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
@@ -13,7 +13,7 @@ This function converts numeric types to `QUANTILE_STATE`
type. The compression p
## Syntax
```sql
-TO_QUANTILE_STATE(<raw_data> <compression>)
+TO_QUANTILE_STATE(<raw_data>, <compression>)
```
## Parameters
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle-sphere.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle-sphere.md
index aee211f7880..1ce6579de3d 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle-sphere.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle-sphere.md
@@ -12,22 +12,22 @@ Calculates the central angle (in degrees) between two
points on the Earth's surf
The central angle refers to the angle at the center of the Earth subtended by
the arc connecting the two points.
-## Sytax
+## Syntax
```sql
ST_ANGLE_SPHERE( <x_lng>, <x_lat>, <y_lng>, <y_lat>)
```
-## 参数
+## Parameters
| parameters | description |
| -- | -- |
| `<x_lng>` | Longitude of point X, of type `DOUBLE`, with a valid range of
[-180, 180] |
-| `<y_lng>` | Longitude of point Y, of type `DOUBLE`, with a valid range of
[-180, 180] |
| `<x_lat>` | Latitude of point X, of type `DOUBLE`, with a valid range of
[-90, 90] |
+| `<y_lng>` | Longitude of point Y, of type `DOUBLE`, with a valid range of
[-180, 180] |
| `<y_lat>` | Latitude of point Y, of type `DOUBLE`, with a valid range of
[-90, 90] |
-## Retuen Value
+## Return Value
Returns the central angle between the two points in degrees, of type DOUBLE,
with a range of [0, 180].
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle.md
index 9e35fdac568..a57bf98a042 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle.md
@@ -10,7 +10,7 @@
Input three points. The first line is the straight line connecting point1
(first endpoint) and point2 (second endpoint). The second line is the straight
line connecting point2 (first endpoint) and point3 (second endpoint). These two
lines intersect at point2. The function returns the angle from the first line
to the second line in the clockwise direction. For each endpoint coordinate,
the x value (longitude) must be in the range [-180, 180], and the y value
(latitude) must be in the rang [...]
-## Sytax
+## Syntax
```sql
ST_ANGLE( <point1>, <point2>, <point3>)
@@ -24,7 +24,7 @@ ST_ANGLE( <point1>, <point2>, <point3>)
| `<point2>` | The second endpoint of the first line and the first endpoint of
the second line, of type `GeoPoint` |
| `<point3>` | The second endpoint of the second line, of type `GeoPoint` |
-## Retuen Value
+## Return Value
Returns the angle between the two lines in radians, as a double-precision
floating-point number, with a range of [0, 2π). The angle is measured clockwise
from the first line to the second line.
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
index 9db059ab0f8..77f65d22bea 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
@@ -8,11 +8,11 @@
## Description
-Calculates the area of a closed region on the Earth's surface in square
kilometers. The input parameter is a geometric object (such as a
Geopolygon,GeoCircle,GeoMuitiPolygon ) representing a region on the Earth's
surface.
+Calculates the area of a closed region on the Earth's surface in square
kilometers. The input parameter is a geometric object (such as a GeoPolygon,
GeoCircle, GeoMultiPolygon) representing a region on the Earth's surface.
-## Sytax
+## Syntax
```sql
ST_AREA_SQUARE_KM( <geo>)
@@ -21,9 +21,9 @@ ST_AREA_SQUARE_KM( <geo>)
| Parameters | Description |
| -- |--------|
-| `<geo>` | A geometric object on the Earth's surface, of type
GeoPolygon,GeoCircle,GeoMultiCircle, must form a closed region.|
+| `<geo>` | A geometric object on the Earth's surface, of type GeoPolygon,
GeoCircle, GeoMultiPolygon, must form a closed region.|
-## Retuen value
+## Return Value
Returns the area of the region in square kilometers, as a DOUBLE type.
@@ -149,7 +149,7 @@ SELECT ST_Area_Square_Km(ST_Point(0, 1));
```text
+-------------------------------------------+
-| st_area_square_Km(st_point(0.0, 1.0)) |
+| st_area_square_km(st_point(0.0, 1.0)) |
+-------------------------------------------+
| 0 |
+-------------------------------------------+
@@ -163,7 +163,7 @@ SELECT ST_Area_Square_Km(ST_LineFromText("LINESTRING (1 1,
2 2)"));
```text
+-----------------------------------------------------------------+
-| st_area_square_Km(st_linefromtext('LINESTRING (1 1, 2 2)')) |
+| st_area_square_km(st_linefromtext('LINESTRING (1 1, 2 2)')) |
+-----------------------------------------------------------------+
| 0 |
+-----------------------------------------------------------------+
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-meters.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-meters.md
index fda801f47a5..95acdc97ac2 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-meters.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-meters.md
@@ -13,7 +13,7 @@ Calculates the area of a closed region on the Earth's surface
in square meters.
For non-closed geometric objects (such as points, line segments), their area
is 0; for invalid geometric objects (such as self-intersecting polygons),
returns NULL.
-## Sytax
+## Syntax
```sql
ST_AREA_SQUARE_METERS( <geo>)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-asbinary.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-asbinary.md
index 25fb99ad2d6..6d64406f9be 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-asbinary.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-asbinary.md
@@ -30,7 +30,7 @@ under the License.
Converts a geometric object into a standard WKB (Well-Known Binary) binary
representation. WKB is a binary format for representing geospatial data, widely
used in Geographic Information Systems (GIS).
Currently supported geometric types include: Point, LineString, and Polygon.
-## Sytax
+## Syntax
```sql
ST_ASBINARY( <geo>)
@@ -40,9 +40,9 @@ ST_ASBINARY( <geo>)
| Parameter | Description |
| -- |----------|
-| `<geo>` | The geometric object to be converted to WKB format, including:
Point, LineString, Polygon.) |
+| `<geo>` | The geometric object to be converted to WKB format, including:
Point, LineString, Polygon. |
-## Retuen value
+## Return Value
Returns the WKB binary representation of the geometric object, displayed as a
hexadecimal string (e.g., \x01010000...).
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-astext.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-astext.md
index ea4ffd19698..1536994fd02 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-astext.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-astext.md
@@ -16,13 +16,13 @@ Currently supported geometric types include: Point,
LineString, Polygon, MultiPo
- ST_ASWKT
-## Sytax
+## Syntax
```sql
ST_ASTEXT( <geo>)
```
-# Parameters
+## Parameters
| Parameter | Description |
| -- |----------|
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-azimuth.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-azimuth.md
index 30dc3e08c48..29b33a81f21 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-azimuth.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-azimuth.md
@@ -12,7 +12,7 @@ Calculates the azimuth (in radians) between two points on the
Earth's surface. T
Azimuth is widely used in navigation and geographic information systems (GIS)
to represent the direction from one point to another.
-## Sytax
+## Syntax
```sql
ST_AZIMUTH( <point1>, <point2>)
@@ -24,7 +24,7 @@ ST_AZIMUTH( <point1>, <point2>)
| `<point1>` | The starting point, of type GeoPoint, serving as the reference
point for azimuth calculation. |
| `<point2>` | The ending point, of type GeoPoint, for which the direction
relative to the starting point is calculated. |
-## Retuen value
+## Return Value
Returns the azimuth between the two points in radians, with a range of [0,
2π). The azimuth is measured clockwise from true north, with specific direction
correspondences:
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-circle.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-circle.md
index bcf1a95fa33..734829b739d 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-circle.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-circle.md
@@ -10,7 +10,7 @@
Converts a WKT (Well-Known Text) into a circle on the Earth's spherical
surface.
-## Sytax
+## Syntax
```sql
ST_CIRCLE( <center_lng>, <center_lat>, <radius>)
@@ -20,11 +20,11 @@ ST_CIRCLE( <center_lng>, <center_lat>, <radius>)
| Parameter | Description |
| -- | -- |
| `<center_lng>` | Longitude of the circle's center, of type DOUBLE, with
a valid range of [-180, 180] |
-| `<center_lat>` | Latitude of the circle's center, of type DOUBLE, with a
valid range of [-180, 180] |
+| `<center_lat>` | Latitude of the circle's center, of type DOUBLE, with a
valid range of [-90, 90] |
| `<radius>` | Radius of the circle, of type DOUBLE, in meters
|
-## Retuen value
+## Return Value
Returns a circle on the Earth's spherical surface, of type GeoCircle. Its WKT
representation is CIRCLE ((<center_lng> <center_lat>), <radius>), which
contains the center coordinates and radius information.
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-contains.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-contains.md
index 41c0208aa92..b2930546ebf 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-contains.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-contains.md
@@ -13,7 +13,7 @@ Determines whether one geometric shape (shape1) completely
contains another geom
- For points: The point must lie inside or on the boundary of the polygon.
- For lines: All points of the line must lie inside or on the boundary of the
polygon.
- For polygons: The contained polygon must be entirely inside the outer
polygon (boundaries can overlap).
-## Sytax
+## Syntax
```sql
ST_CONTAINS( <shape1>, <shape2>)
@@ -23,10 +23,10 @@ ST_CONTAINS( <shape1>, <shape2>)
| Parameters | Description |
|----------|------------------------|
-| `<shape1>` | The geometric shape used to check if it contains another shape,
supporting the Polygon type.。 |
+| `<shape1>` | The geometric shape used to check if it contains another shape,
supporting the Polygon type. |
| `<shape2>` | The geometric shape used to check if it is contained,
supporting types such as Point, Line, Polygon, etc. |
-## Retuen value
+## Return Value
- 1: Indicates that shape1 completely contains shape2.
- 0: Indicates that shape1 does not contain shape2.
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-disjoint.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-disjoint.md
index a04e67f4e6c..bf43c6c1f46 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-disjoint.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-disjoint.md
@@ -14,7 +14,7 @@ Determines whether two geometric shapes are completely
disjoint (i.e., have no c
Supported since Apache Doris 3.0.6.
:::
-## Sytax
+## Syntax
```sql
ST_DISJOINT( <shape1>, <shape2> )
@@ -76,6 +76,7 @@ mysql> SELECT ST_Disjoint(ST_Linefromtext("LINESTRING (0 0,
10 10)"), ST_Point(1
| ST_Disjoint(ST_Linefromtext("LINESTRING (0 0, 10 10)"), ST_Point(1, 2)) |
+-------------------------------------------------------------------------+
| 1 |
++-------------------------------------------------------------------------+
```
Point and line intersect (point is on the line)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance-sphere.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance-sphere.md
index b2df281b9f3..7d100349ee4 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance-sphere.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance-sphere.md
@@ -10,7 +10,7 @@
Calculate the spherical distance between two points on the Earth, in meters.
The input parameters are the longitude of point X, latitude of point X,
longitude of point Y, and latitude of point Y respectively.
-## Sytax
+## Syntax
```sql
ST_DISTANCE_SPHERE( <x_lng>, <x_lat>, <y_lng>, <y_lat>)
@@ -20,12 +20,12 @@ ST_DISTANCE_SPHERE( <x_lng>, <x_lat>, <y_lng>, <y_lat>)
| Parameter | Description |
| -- | -- |
-| `<x_lng>` | Longitude of point X, of type DOUBLE, with a valid range of
[-180, 180] (returns NULL if out of range).|
-| `<y_lng>` | Latitude of point X, of type DOUBLE, with a valid range of [-90,
90] (returns NULL if out of range). |
-| `<x_lat>` | Longitude of point Y, of type DOUBLE, with a valid range of
[-180, 180] (returns NULL if out of range). |
+| `<x_lng>` | Longitude of point X, of type DOUBLE, with a valid range of
[-180, 180] (returns NULL if out of range). |
+| `<x_lat>` | Latitude of point X, of type DOUBLE, with a valid range of [-90,
90] (returns NULL if out of range). |
+| `<y_lng>` | Longitude of point Y, of type DOUBLE, with a valid range of
[-180, 180] (returns NULL if out of range). |
| `<y_lat>` | Latitude of point Y, of type DOUBLE, with a valid range of [-90,
90] (returns NULL if out of range). |
-## Retuen value
+## Return Value
Returns the shortest spherical distance between the two points, in meters (of
type DOUBLE).
@@ -36,7 +36,7 @@ ST_DISTANCE_SPHERE has the following edge cases:
- If the two points are completely identical (with the same longitude and
latitude values), returns 0 (distance is 0).
## Example
-Two identical points (returns 0)
+Two nearby points on Earth
```sql
select st_distance_sphere(116.35620117, 39.939093, 116.4274406433,
39.9020987219);
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
index 96a58377c9b..85740d7a190 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
@@ -43,11 +43,11 @@ Returns the shortest spherical distance between the
boundaries of the two geomet
SELECT ST_DISTANCE(ST_GeometryFromText('POINT(0 0)'),
ST_GeometryFromText('POINT(1 0)'));
```
```text
-+---------------------------------------------+
-| ST_Distance(ST_Point(0, 0), ST_Point(1, 0)) |
-+---------------------------------------------+
-| 111195.1011774839 |
-+---------------------------------------------+
++------------------------------------------------------------------------------------+
+| ST_DISTANCE(ST_GeometryFromText('POINT(0 0)'), ST_GeometryFromText('POINT(1
0)')) |
++------------------------------------------------------------------------------------+
+|
111195.1011774839 |
++------------------------------------------------------------------------------------+
```
**Distance Between a Point and a Line**
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-intersects.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-intersects.md
index 1dbe256fd61..0760a850a77 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-intersects.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-intersects.md
@@ -14,7 +14,7 @@ Determine whether two geometric shapes intersect, i.e., there
is at least one co
Supported since Apache Doris 3.0.6.
:::
-## Sytax
+## Syntax
```sql
ST_INTERSECTS( <shape1>, <shape2>)
@@ -24,8 +24,8 @@ ST_INTERSECTS( <shape1>, <shape2>)
| Parameter | Description |
|----------|------------------------|
-| `<shape1>` | The first geometric shape used to determine if it intersects
with another, supporting types such as Point, Line, Polygon, Circle。 |
-| `<shape2>` | The second geometric shape used to determine if it
intersects with another, supporting types such as Point, Line, Polygon, Circle。
|
+| `<shape1>` | The first geometric shape used to determine if it intersects
with another, supporting types such as Point, Line, Polygon, Circle. |
+| `<shape2>` | The second geometric shape used to determine if it
intersects with another, supporting types such as Point, Line, Polygon, Circle.
|
## Return value
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-linefromtext.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-linefromtext.md
index 234c2a57a7f..0781a8b0dd7 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-linefromtext.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-linefromtext.md
@@ -14,7 +14,7 @@ Converts a WKT (Well Known Text) string into an in-memory
representation of a Li
- ST_LINESTRINGFROMTEXT
-## Sytax
+## Syntax
```sql
ST_LINEFROMTEXT( <wkt>)
@@ -24,8 +24,8 @@ ST_LINEFROMTEXT( <wkt>)
| Parameters | Description |
|-----|------------|
-| `<wkt>` | A WKT string conforming to the LINE type, formatted as:
-"LINE (x1 y1, x2 y2)"
+| `<wkt>` | A WKT string conforming to the LINESTRING type, formatted as:
+"LINESTRING (x1 y1, x2 y2)"
Where (x1 y1), (x2 y2) are the vertex coordinates of the line segment.
Coordinate values are numeric (integers or decimals). |
## Return value
@@ -71,16 +71,15 @@ mysql> SELECT ST_LineFromText("LINESTRING (1 1, 2 2");
+-----------------------------------------+
```
-Invalid WKT (too many vertices)
+LineString with multiple vertices
```sql
-mysql> SELECT ST_LineFromText("LINESTRING (1 1,2 2,3 3)");
-+---------------------------------------------------------------------------------+
-| ST_LineFromText("LINESTRING (1 1,2 2,3 3)")
|
-+---------------------------------------------------------------------------------+
-| ��_<���?'���Xޑ?݉+
- ߑ?�����?(Qjm�ۡ?'���Xޡ?�3|ʏ��?lW<�`ª?��H�˪? |
-+---------------------------------------------------------------------------------+
+mysql> SELECT ST_AsText(ST_LineFromText('LINESTRING (1 1, 2 2)'));
++-----------------------------------------------------+
+| ST_AsText(ST_LineFromText('LINESTRING (1 1, 2 2)')) |
++-----------------------------------------------------+
+| LINESTRING (1 1, 2 2) |
++-----------------------------------------------------+
```
Input NULL
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-point.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-point.md
index 4537c86de4a..8d91bb62e73 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-point.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-point.md
@@ -11,7 +11,7 @@
Creates a Point geometry object from the given X and Y coordinates.
In geospatial contexts, X/Y typically represent longitude and latitude
respectively,
-## Sytax
+## Syntax
```sql
ST_POINT( <x>, <y>)
@@ -21,7 +21,7 @@ ST_POINT( <x>, <y>)
| Parameter | Description |
|-----|-----|
| `<x>` | X-coordinate (longitude) of the point, range: -180.0 to 180.0
(degrees) |
-| `<y>` | Y-coordinate (latitude) of the point, range: -90.0 to 90.0
(degrees)) |
+| `<y>` | Y-coordinate (latitude) of the point, range: -90.0 to 90.0 (degrees)
|
## Return value
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-polygon.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-polygon.md
index b1fdf1fef49..490f1b99b85 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-polygon.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-polygon.md
@@ -35,7 +35,7 @@ Converts a string in WKT (Well-Known Text) format into an
in-memory Polygon geom
- st_polygonfromtext
- st_polyfromtext
-## Sytax
+## Syntax
```sql
ST_POLYGON( <wkt>)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-touches.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-touches.md
index dc9fea4d51c..882e4ace2ca 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-touches.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-touches.md
@@ -15,7 +15,7 @@ Returns 0 if there are no common points on the boundaries, or
if there is an int
This function is used to distinguish between "boundary-only contact" and
"internal intersection" scenarios, such as shared edges of adjacent polygons
(boundary-only contact) or tangent points between a line and a polygon
(boundary-only contact).
-## Sytax
+## Syntax
```sql
ST_TOUCHES( <shape1>, <shape2>)
@@ -39,7 +39,7 @@ ST_TOUCHES has the following edge cases:
- If the input geometric shape is invalid, returns NULL.
- If the input is an empty geometric object (e.g., POINT EMPTY), returns NULL.
- If one shape is completely contained within another (with internal
intersection), returns 0 even if their boundaries are in contact.
-- When a point is in contact with the boundary of a shape (a point has no
interior), returns 1 (the "boundary" of a point is itself, which coincides with
the shape's boundary with no internal intersection).。
+- When a point is in contact with the boundary of a shape (a point has no
interior), returns 1 (the "boundary" of a point is itself, which coincides with
the shape's boundary with no internal intersection).
## Example
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-x.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-x.md
index 02432575f3a..e2271486cf5 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-x.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-x.md
@@ -10,7 +10,7 @@
When the point is a valid POINT type, returns the corresponding X coordinate
value.
-## Sytax
+## Syntax
```sql
ST_X( <point>)
@@ -22,7 +22,7 @@ ST_X( <point>)
|------|----------|
| `<point>` | The geometric object from which to extract the X coordinate. It
must be a valid POINT type (2D point), where the X (longitude) range is [-180,
180] and the Y (latitude) range is [-90, 90].|
-## Retuen value
+## Return Value
The X value in the geometric coordinates, of type double-precision
floating-point number (Double).
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-y.md
b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-y.md
index 1b650f6de63..6ed58bbdc15 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-y.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/spatial-functions/st-y.md
@@ -10,7 +10,7 @@
Returns the Y coordinate of a valid POINT geometry. In geospatial contexts,
the Y coordinate typically corresponds to Latitude, ranging from [-90.0, 90.0]
(in degrees).
-## Sytax
+## Syntax
```sql
ST_Y( <point>)
@@ -22,7 +22,7 @@ ST_Y( <point>)
|------|----------|
| `<point>` | A valid 2D POINT geometry from which to extract the Y
coordinate. The Y value (latitude) must be within [-90.0, 90.0], and the X
value (longitude) must be within [-180.0, 180.0]. |
-## Retuen value
+## Return Value
The Y coordinate of the input POINT, returned as a DOUBLE PRECISION FLOAT.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
index 799ec15b880..8b00ddcc1b9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
@@ -40,7 +40,7 @@ ASINH(<x>)
select asinh(0.0);
```
-```sql
+```text
+------------+
| asinh(0.0) |
+------------+
@@ -52,7 +52,7 @@ select asinh(0.0);
select asinh(1.0);
```
-```sql
+```text
+-------------------+
| asinh(1.0) |
+-------------------+
@@ -64,7 +64,7 @@ select asinh(1.0);
select asinh(-1.0);
```
-```sql
+```text
+--------------------+
| asinh(-1.0) |
+--------------------+
@@ -76,7 +76,7 @@ select asinh(-1.0);
select asinh(cast('nan' as double));
```
-```sql
+```text
+------------------------------+
| asinh(cast('nan' AS DOUBLE)) |
+------------------------------+
@@ -88,7 +88,7 @@ select asinh(cast('nan' as double));
select asinh(cast('inf' as double));
```
-```sql
+```text
+------------------------------+
| asinh(cast('inf' AS DOUBLE)) |
+------------------------------+
@@ -100,7 +100,7 @@ select asinh(cast('inf' as double));
select asinh(cast('-inf' as double));
```
-```sql
+```text
+-------------------------------+
| asinh(cast('-inf' AS DOUBLE)) |
+-------------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
index 99d0989dd2f..72efd5c7ce1 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
@@ -67,11 +67,11 @@ select gcd(-17, 31);
```
```text
-+-------------+
-| gcd(17,31) |
-+-------------+
-| 1 |
-+-------------+
++--------------+
+| gcd(-17,31) |
++--------------+
+| 1 |
++--------------+
```
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
index 35e0b9b6ae1..cb4a6bcac4a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
@@ -92,6 +92,6 @@ select signbit(cast('+0.0' as double)) , signbit(cast('-0.0'
as double));
+---------------------------------+---------------------------------+
| signbit(cast('+0.0' as double)) | signbit(cast('-0.0' as double)) |
+---------------------------------+---------------------------------+
-| 0 | 1 |
+| false | true |
+---------------------------------+---------------------------------+
```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
index fcb3e6e65e1..85c7572b26a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
@@ -1,6 +1,6 @@
---
{
- "title": "XOR | Numeric Functions",
+ "title": "XOR",
"language": "zh-CN",
"description": "Return the XOR value of two numbers.",
"sidebar_label": "XOR"
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
index 705ed23177b..02f8b063299 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
@@ -13,7 +13,7 @@
## Syntax
```sql
-TO_QUANTILE_STATE(<raw_data> <compression>)
+TO_QUANTILE_STATE(<raw_data>, <compression>)
```
## Parameters
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
index 70d5d70f443..c3f6528d1e9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
@@ -148,7 +148,7 @@ SELECT ST_Area_Square_Km(ST_Point(0, 1));
```text
+-------------------------------------------+
-| st_area_square_Km(st_point(0.0, 1.0)) |
+| st_area_square_km(st_point(0.0, 1.0)) |
+-------------------------------------------+
| 0 |
+-------------------------------------------+
@@ -162,7 +162,7 @@ SELECT ST_Area_Square_Km(ST_LineFromText("LINESTRING (1 1,
2 2)"));
```text
+-----------------------------------------------------------------+
-| st_area_square_Km(st_linefromtext('LINESTRING (1 1, 2 2)')) |
+| st_area_square_km(st_linefromtext('LINESTRING (1 1, 2 2)')) |
+-----------------------------------------------------------------+
| 0 |
+-----------------------------------------------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
index 701d737ab7b..e08cd5dab48 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
@@ -43,11 +43,11 @@ ST_DISTANCE( <shape1>, <shape2> )
SELECT ST_DISTANCE(ST_GeometryFromText('POINT(0 0)'),
ST_GeometryFromText('POINT(1 0)'));
```
```text
-+---------------------------------------------+
-| ST_Distance(ST_Point(0, 0), ST_Point(1, 0)) |
-+---------------------------------------------+
-| 111195.1011774839 |
-+---------------------------------------------+
++------------------------------------------------------------------------------------+
+| ST_DISTANCE(ST_GeometryFromText('POINT(0 0)'), ST_GeometryFromText('POINT(1
0)')) |
++------------------------------------------------------------------------------------+
+|
111195.1011774839 |
++------------------------------------------------------------------------------------+
```
**点与线之间的距离**
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
index 705ed23177b..02f8b063299 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
@@ -13,7 +13,7 @@
## Syntax
```sql
-TO_QUANTILE_STATE(<raw_data> <compression>)
+TO_QUANTILE_STATE(<raw_data>, <compression>)
```
## Parameters
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
index fcb3e6e65e1..85c7572b26a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
@@ -1,6 +1,6 @@
---
{
- "title": "XOR | Numeric Functions",
+ "title": "XOR",
"language": "zh-CN",
"description": "Return the XOR value of two numbers.",
"sidebar_label": "XOR"
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
index 705ed23177b..02f8b063299 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
@@ -13,7 +13,7 @@
## Syntax
```sql
-TO_QUANTILE_STATE(<raw_data> <compression>)
+TO_QUANTILE_STATE(<raw_data>, <compression>)
```
## Parameters
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
index 70d5d70f443..c3f6528d1e9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
@@ -148,7 +148,7 @@ SELECT ST_Area_Square_Km(ST_Point(0, 1));
```text
+-------------------------------------------+
-| st_area_square_Km(st_point(0.0, 1.0)) |
+| st_area_square_km(st_point(0.0, 1.0)) |
+-------------------------------------------+
| 0 |
+-------------------------------------------+
@@ -162,7 +162,7 @@ SELECT ST_Area_Square_Km(ST_LineFromText("LINESTRING (1 1,
2 2)"));
```text
+-----------------------------------------------------------------+
-| st_area_square_Km(st_linefromtext('LINESTRING (1 1, 2 2)')) |
+| st_area_square_km(st_linefromtext('LINESTRING (1 1, 2 2)')) |
+-----------------------------------------------------------------+
| 0 |
+-----------------------------------------------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
index 799ec15b880..8b00ddcc1b9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
@@ -40,7 +40,7 @@ ASINH(<x>)
select asinh(0.0);
```
-```sql
+```text
+------------+
| asinh(0.0) |
+------------+
@@ -52,7 +52,7 @@ select asinh(0.0);
select asinh(1.0);
```
-```sql
+```text
+-------------------+
| asinh(1.0) |
+-------------------+
@@ -64,7 +64,7 @@ select asinh(1.0);
select asinh(-1.0);
```
-```sql
+```text
+--------------------+
| asinh(-1.0) |
+--------------------+
@@ -76,7 +76,7 @@ select asinh(-1.0);
select asinh(cast('nan' as double));
```
-```sql
+```text
+------------------------------+
| asinh(cast('nan' AS DOUBLE)) |
+------------------------------+
@@ -88,7 +88,7 @@ select asinh(cast('nan' as double));
select asinh(cast('inf' as double));
```
-```sql
+```text
+------------------------------+
| asinh(cast('inf' AS DOUBLE)) |
+------------------------------+
@@ -100,7 +100,7 @@ select asinh(cast('inf' as double));
select asinh(cast('-inf' as double));
```
-```sql
+```text
+-------------------------------+
| asinh(cast('-inf' AS DOUBLE)) |
+-------------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
index 99d0989dd2f..72efd5c7ce1 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
@@ -67,11 +67,11 @@ select gcd(-17, 31);
```
```text
-+-------------+
-| gcd(17,31) |
-+-------------+
-| 1 |
-+-------------+
++--------------+
+| gcd(-17,31) |
++--------------+
+| 1 |
++--------------+
```
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
index 35e0b9b6ae1..cb4a6bcac4a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
@@ -92,6 +92,6 @@ select signbit(cast('+0.0' as double)) , signbit(cast('-0.0'
as double));
+---------------------------------+---------------------------------+
| signbit(cast('+0.0' as double)) | signbit(cast('-0.0' as double)) |
+---------------------------------+---------------------------------+
-| 0 | 1 |
+| false | true |
+---------------------------------+---------------------------------+
```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
index fcb3e6e65e1..85c7572b26a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
@@ -1,6 +1,6 @@
---
{
- "title": "XOR | Numeric Functions",
+ "title": "XOR",
"language": "zh-CN",
"description": "Return the XOR value of two numbers.",
"sidebar_label": "XOR"
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
index 705ed23177b..02f8b063299 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
@@ -13,7 +13,7 @@
## Syntax
```sql
-TO_QUANTILE_STATE(<raw_data> <compression>)
+TO_QUANTILE_STATE(<raw_data>, <compression>)
```
## Parameters
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
index 70d5d70f443..c3f6528d1e9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
@@ -148,7 +148,7 @@ SELECT ST_Area_Square_Km(ST_Point(0, 1));
```text
+-------------------------------------------+
-| st_area_square_Km(st_point(0.0, 1.0)) |
+| st_area_square_km(st_point(0.0, 1.0)) |
+-------------------------------------------+
| 0 |
+-------------------------------------------+
@@ -162,7 +162,7 @@ SELECT ST_Area_Square_Km(ST_LineFromText("LINESTRING (1 1,
2 2)"));
```text
+-----------------------------------------------------------------+
-| st_area_square_Km(st_linefromtext('LINESTRING (1 1, 2 2)')) |
+| st_area_square_km(st_linefromtext('LINESTRING (1 1, 2 2)')) |
+-----------------------------------------------------------------+
| 0 |
+-----------------------------------------------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
index 701d737ab7b..e08cd5dab48 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
@@ -43,11 +43,11 @@ ST_DISTANCE( <shape1>, <shape2> )
SELECT ST_DISTANCE(ST_GeometryFromText('POINT(0 0)'),
ST_GeometryFromText('POINT(1 0)'));
```
```text
-+---------------------------------------------+
-| ST_Distance(ST_Point(0, 0), ST_Point(1, 0)) |
-+---------------------------------------------+
-| 111195.1011774839 |
-+---------------------------------------------+
++------------------------------------------------------------------------------------+
+| ST_DISTANCE(ST_GeometryFromText('POINT(0 0)'), ST_GeometryFromText('POINT(1
0)')) |
++------------------------------------------------------------------------------------+
+|
111195.1011774839 |
++------------------------------------------------------------------------------------+
```
**点与线之间的距离**
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
index 8b4ea4cf1ad..c60012244ff 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
@@ -18,7 +18,7 @@ For the format specification, refer to the format description
of the date_format
This function is affected by the time zone.
-## Sytax
+## Syntax
```sql
UNIX_TIMESTAMP([DATETIME date[, STRING fmt]])
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
index e40d096f718..cea75839024 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
@@ -2,13 +2,13 @@
{
"title": "LOG10",
"language": "en",
- "description": "Returns the natural logarithm of x to base 10."
+ "description": "Returns the logarithm of x to base 10."
}
---
## Description
-Returns the natural logarithm of `x` to base `10`.
+Returns the logarithm of `x` to base `10`.
## Alias
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
index 70cf8d95dea..bfd8b05ba6c 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
@@ -2,13 +2,13 @@
{
"title": "LOG2",
"language": "en",
- "description": "Returns the natural logarithm of x to base 2."
+ "description": "Returns the logarithm of x to base 2."
}
---
## Description
-Returns the natural logarithm of `x` to base `2`.
+Returns the logarithm of `x` to base `2`.
## Syntax
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
index 210c3580b99..ee759b25cf2 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
@@ -32,7 +32,7 @@ RANDOM(<a> , <b>) -- Generates a random number between a and b
|-----------|------------|
| `<seed>` | random number generator seed. Returns a fixed sequence of random
numbers between 0 and 1. |
| `<a>` | The lower bound of a random number. |
-| `<b>` | The upper bound of a random number. It must be less than the lower
bound. |
+| `<b>` | The upper bound of a random number. It must be greater than the
lower bound. |
## Return value
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
index 6821e966fbb..4640241e034 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
@@ -37,7 +37,7 @@ If d is a column, and the first argument is of type Decimal,
then the resulting
## Example
- d is a litera
+ d is a literal
```sql
select truncate(124.3867, 2),truncate(124.3867, 0),truncate(124.3867, -2);
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
index ec5038f6c7b..92c61ddefee 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
@@ -13,7 +13,7 @@ This function converts numeric types to `QUANTILE_STATE`
type. The compression p
## Syntax
```sql
-TO_QUANTILE_STATE(<raw_data> <compression>)
+TO_QUANTILE_STATE(<raw_data>, <compression>)
```
## Parameters
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
index cb79b11494a..3466c79cab3 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
@@ -18,7 +18,7 @@ For the format specification, refer to the format description
of the date_format
This function is affected by the time zone.
-## Sytax
+## Syntax
```sql
UNIX_TIMESTAMP([DATETIME date[, STRING fmt]])
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log.md
index 2785c23f801..4c9bea8c850 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log.md
@@ -13,15 +13,15 @@ Returns the logarithm of `x` based on base `b`.
## Syntax
```sql
-LOG(<b>[, <x>])
+LOG([<b>, ]<x>)
```
## Parameters
| Parameter | Description |
|-----------|------------|
-| `<b>` | Base should be greater than 0 and not be exactly 1.0 |
-| `<x>` | optional, Antilogarithm should be greater than 0, default value
is e |
+| `<b>` | Optional. Base should be greater than 0 and not be exactly 1.0.
If omitted, the natural logarithm (base e) is computed. |
+| `<x>` | Antilogarithm should be greater than 0 |
## Return value
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
index e40d096f718..cea75839024 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
@@ -2,13 +2,13 @@
{
"title": "LOG10",
"language": "en",
- "description": "Returns the natural logarithm of x to base 10."
+ "description": "Returns the logarithm of x to base 10."
}
---
## Description
-Returns the natural logarithm of `x` to base `10`.
+Returns the logarithm of `x` to base `10`.
## Alias
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
index 70cf8d95dea..bfd8b05ba6c 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
@@ -2,13 +2,13 @@
{
"title": "LOG2",
"language": "en",
- "description": "Returns the natural logarithm of x to base 2."
+ "description": "Returns the logarithm of x to base 2."
}
---
## Description
-Returns the natural logarithm of `x` to base `2`.
+Returns the logarithm of `x` to base `2`.
## Syntax
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
index 210c3580b99..ee759b25cf2 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
@@ -32,7 +32,7 @@ RANDOM(<a> , <b>) -- Generates a random number between a and b
|-----------|------------|
| `<seed>` | random number generator seed. Returns a fixed sequence of random
numbers between 0 and 1. |
| `<a>` | The lower bound of a random number. |
-| `<b>` | The upper bound of a random number. It must be less than the lower
bound. |
+| `<b>` | The upper bound of a random number. It must be greater than the
lower bound. |
## Return value
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
index 6821e966fbb..4640241e034 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
@@ -37,7 +37,7 @@ If d is a column, and the first argument is of type Decimal,
then the resulting
## Example
- d is a litera
+ d is a literal
```sql
select truncate(124.3867, 2),truncate(124.3867, 0),truncate(124.3867, -2);
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
index c06787546ae..27ea25ac769 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
@@ -1,6 +1,6 @@
---
{
- "title": "XOR | Numeric Functions",
+ "title": "XOR",
"language": "en",
"description": "Return the XOR value of two numbers.",
"sidebar_label": "XOR"
@@ -19,13 +19,15 @@ Return the XOR value of two numbers.
## Example
```sql
-mysql >select true xor false,true xor true;
+mysql> select true xor false, true xor true;
+```
+
+```text
+------------------+-----------------+
| (TRUE XOR FALSE) | (TRUE XOR TRUE) |
+------------------+-----------------+
| 1 | 0 |
+------------------+-----------------+
-
```
## Keywords
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
index ec5038f6c7b..92c61ddefee 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
@@ -13,7 +13,7 @@ This function converts numeric types to `QUANTILE_STATE`
type. The compression p
## Syntax
```sql
-TO_QUANTILE_STATE(<raw_data> <compression>)
+TO_QUANTILE_STATE(<raw_data>, <compression>)
```
## Parameters
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle-sphere.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle-sphere.md
index aee211f7880..1ce6579de3d 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle-sphere.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle-sphere.md
@@ -12,22 +12,22 @@ Calculates the central angle (in degrees) between two
points on the Earth's surf
The central angle refers to the angle at the center of the Earth subtended by
the arc connecting the two points.
-## Sytax
+## Syntax
```sql
ST_ANGLE_SPHERE( <x_lng>, <x_lat>, <y_lng>, <y_lat>)
```
-## 参数
+## Parameters
| parameters | description |
| -- | -- |
| `<x_lng>` | Longitude of point X, of type `DOUBLE`, with a valid range of
[-180, 180] |
-| `<y_lng>` | Longitude of point Y, of type `DOUBLE`, with a valid range of
[-180, 180] |
| `<x_lat>` | Latitude of point X, of type `DOUBLE`, with a valid range of
[-90, 90] |
+| `<y_lng>` | Longitude of point Y, of type `DOUBLE`, with a valid range of
[-180, 180] |
| `<y_lat>` | Latitude of point Y, of type `DOUBLE`, with a valid range of
[-90, 90] |
-## Retuen Value
+## Return Value
Returns the central angle between the two points in degrees, of type DOUBLE,
with a range of [0, 180].
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle.md
index 6cbd9c150cf..285851ac154 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle.md
@@ -10,7 +10,7 @@
Input three points. The first line is the straight line connecting point1
(first endpoint) and point2 (second endpoint). The second line is the straight
line connecting point2 (first endpoint) and point3 (second endpoint). These two
lines intersect at point2. The function returns the angle from the first line
to the second line in the clockwise direction. For each endpoint coordinate,
the x value (longitude) must be in the range [-180, 180], and the y value
(latitude) must be in the rang [...]
-## Sytax
+## Syntax
```sql
ST_ANGLE( <point1>, <point2>, <point3>)
@@ -24,7 +24,7 @@ ST_ANGLE( <point1>, <point2>, <point3>)
| `<point2>` | The second endpoint of the first line and the first endpoint of
the second line, of type `GeoPoint` |
| `<point3>` | The second endpoint of the second line, of type `GeoPint` |
-## Retuen Value
+## Return Value
Returns the angle between the two lines in radians, as a double-precision
floating-point number, with a range of [0, 2π). The angle is measured clockwise
from the first line to the second line.
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
index 9db059ab0f8..77f65d22bea 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
@@ -8,11 +8,11 @@
## Description
-Calculates the area of a closed region on the Earth's surface in square
kilometers. The input parameter is a geometric object (such as a
Geopolygon,GeoCircle,GeoMuitiPolygon ) representing a region on the Earth's
surface.
+Calculates the area of a closed region on the Earth's surface in square
kilometers. The input parameter is a geometric object (such as a GeoPolygon,
GeoCircle, GeoMultiPolygon) representing a region on the Earth's surface.
-## Sytax
+## Syntax
```sql
ST_AREA_SQUARE_KM( <geo>)
@@ -21,9 +21,9 @@ ST_AREA_SQUARE_KM( <geo>)
| Parameters | Description |
| -- |--------|
-| `<geo>` | A geometric object on the Earth's surface, of type
GeoPolygon,GeoCircle,GeoMultiCircle, must form a closed region.|
+| `<geo>` | A geometric object on the Earth's surface, of type GeoPolygon,
GeoCircle, GeoMultiPolygon, must form a closed region.|
-## Retuen value
+## Return Value
Returns the area of the region in square kilometers, as a DOUBLE type.
@@ -149,7 +149,7 @@ SELECT ST_Area_Square_Km(ST_Point(0, 1));
```text
+-------------------------------------------+
-| st_area_square_Km(st_point(0.0, 1.0)) |
+| st_area_square_km(st_point(0.0, 1.0)) |
+-------------------------------------------+
| 0 |
+-------------------------------------------+
@@ -163,7 +163,7 @@ SELECT ST_Area_Square_Km(ST_LineFromText("LINESTRING (1 1,
2 2)"));
```text
+-----------------------------------------------------------------+
-| st_area_square_Km(st_linefromtext('LINESTRING (1 1, 2 2)')) |
+| st_area_square_km(st_linefromtext('LINESTRING (1 1, 2 2)')) |
+-----------------------------------------------------------------+
| 0 |
+-----------------------------------------------------------------+
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-meters.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-meters.md
index fda801f47a5..95acdc97ac2 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-meters.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-meters.md
@@ -13,7 +13,7 @@ Calculates the area of a closed region on the Earth's surface
in square meters.
For non-closed geometric objects (such as points, line segments), their area
is 0; for invalid geometric objects (such as self-intersecting polygons),
returns NULL.
-## Sytax
+## Syntax
```sql
ST_AREA_SQUARE_METERS( <geo>)
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-asbinary.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-asbinary.md
index 25fb99ad2d6..6d64406f9be 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-asbinary.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-asbinary.md
@@ -30,7 +30,7 @@ under the License.
Converts a geometric object into a standard WKB (Well-Known Binary) binary
representation. WKB is a binary format for representing geospatial data, widely
used in Geographic Information Systems (GIS).
Currently supported geometric types include: Point, LineString, and Polygon.
-## Sytax
+## Syntax
```sql
ST_ASBINARY( <geo>)
@@ -40,9 +40,9 @@ ST_ASBINARY( <geo>)
| Parameter | Description |
| -- |----------|
-| `<geo>` | The geometric object to be converted to WKB format, including:
Point, LineString, Polygon.) |
+| `<geo>` | The geometric object to be converted to WKB format, including:
Point, LineString, Polygon. |
-## Retuen value
+## Return Value
Returns the WKB binary representation of the geometric object, displayed as a
hexadecimal string (e.g., \x01010000...).
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-astext.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-astext.md
index ea4ffd19698..1536994fd02 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-astext.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-astext.md
@@ -16,13 +16,13 @@ Currently supported geometric types include: Point,
LineString, Polygon, MultiPo
- ST_ASWKT
-## Sytax
+## Syntax
```sql
ST_ASTEXT( <geo>)
```
-# Parameters
+## Parameters
| Parameter | Description |
| -- |----------|
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-azimuth.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-azimuth.md
index 30dc3e08c48..29b33a81f21 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-azimuth.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-azimuth.md
@@ -12,7 +12,7 @@ Calculates the azimuth (in radians) between two points on the
Earth's surface. T
Azimuth is widely used in navigation and geographic information systems (GIS)
to represent the direction from one point to another.
-## Sytax
+## Syntax
```sql
ST_AZIMUTH( <point1>, <point2>)
@@ -24,7 +24,7 @@ ST_AZIMUTH( <point1>, <point2>)
| `<point1>` | The starting point, of type GeoPoint, serving as the reference
point for azimuth calculation. |
| `<point2>` | The ending point, of type GeoPoint, for which the direction
relative to the starting point is calculated. |
-## Retuen value
+## Return Value
Returns the azimuth between the two points in radians, with a range of [0,
2π). The azimuth is measured clockwise from true north, with specific direction
correspondences:
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-circle.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-circle.md
index bcf1a95fa33..734829b739d 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-circle.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-circle.md
@@ -10,7 +10,7 @@
Converts a WKT (Well-Known Text) into a circle on the Earth's spherical
surface.
-## Sytax
+## Syntax
```sql
ST_CIRCLE( <center_lng>, <center_lat>, <radius>)
@@ -20,11 +20,11 @@ ST_CIRCLE( <center_lng>, <center_lat>, <radius>)
| Parameter | Description |
| -- | -- |
| `<center_lng>` | Longitude of the circle's center, of type DOUBLE, with
a valid range of [-180, 180] |
-| `<center_lat>` | Latitude of the circle's center, of type DOUBLE, with a
valid range of [-180, 180] |
+| `<center_lat>` | Latitude of the circle's center, of type DOUBLE, with a
valid range of [-90, 90] |
| `<radius>` | Radius of the circle, of type DOUBLE, in meters
|
-## Retuen value
+## Return Value
Returns a circle on the Earth's spherical surface, of type GeoCircle. Its WKT
representation is CIRCLE ((<center_lng> <center_lat>), <radius>), which
contains the center coordinates and radius information.
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-contains.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-contains.md
index 41c0208aa92..b2930546ebf 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-contains.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-contains.md
@@ -13,7 +13,7 @@ Determines whether one geometric shape (shape1) completely
contains another geom
- For points: The point must lie inside or on the boundary of the polygon.
- For lines: All points of the line must lie inside or on the boundary of the
polygon.
- For polygons: The contained polygon must be entirely inside the outer
polygon (boundaries can overlap).
-## Sytax
+## Syntax
```sql
ST_CONTAINS( <shape1>, <shape2>)
@@ -23,10 +23,10 @@ ST_CONTAINS( <shape1>, <shape2>)
| Parameters | Description |
|----------|------------------------|
-| `<shape1>` | The geometric shape used to check if it contains another shape,
supporting the Polygon type.。 |
+| `<shape1>` | The geometric shape used to check if it contains another shape,
supporting the Polygon type. |
| `<shape2>` | The geometric shape used to check if it is contained,
supporting types such as Point, Line, Polygon, etc. |
-## Retuen value
+## Return Value
- 1: Indicates that shape1 completely contains shape2.
- 0: Indicates that shape1 does not contain shape2.
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-disjoint.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-disjoint.md
index a04e67f4e6c..bf43c6c1f46 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-disjoint.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-disjoint.md
@@ -14,7 +14,7 @@ Determines whether two geometric shapes are completely
disjoint (i.e., have no c
Supported since Apache Doris 3.0.6.
:::
-## Sytax
+## Syntax
```sql
ST_DISJOINT( <shape1>, <shape2> )
@@ -76,6 +76,7 @@ mysql> SELECT ST_Disjoint(ST_Linefromtext("LINESTRING (0 0,
10 10)"), ST_Point(1
| ST_Disjoint(ST_Linefromtext("LINESTRING (0 0, 10 10)"), ST_Point(1, 2)) |
+-------------------------------------------------------------------------+
| 1 |
++-------------------------------------------------------------------------+
```
Point and line intersect (point is on the line)
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance-sphere.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance-sphere.md
index b2df281b9f3..7d100349ee4 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance-sphere.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance-sphere.md
@@ -10,7 +10,7 @@
Calculate the spherical distance between two points on the Earth, in meters.
The input parameters are the longitude of point X, latitude of point X,
longitude of point Y, and latitude of point Y respectively.
-## Sytax
+## Syntax
```sql
ST_DISTANCE_SPHERE( <x_lng>, <x_lat>, <y_lng>, <y_lat>)
@@ -20,12 +20,12 @@ ST_DISTANCE_SPHERE( <x_lng>, <x_lat>, <y_lng>, <y_lat>)
| Parameter | Description |
| -- | -- |
-| `<x_lng>` | Longitude of point X, of type DOUBLE, with a valid range of
[-180, 180] (returns NULL if out of range).|
-| `<y_lng>` | Latitude of point X, of type DOUBLE, with a valid range of [-90,
90] (returns NULL if out of range). |
-| `<x_lat>` | Longitude of point Y, of type DOUBLE, with a valid range of
[-180, 180] (returns NULL if out of range). |
+| `<x_lng>` | Longitude of point X, of type DOUBLE, with a valid range of
[-180, 180] (returns NULL if out of range). |
+| `<x_lat>` | Latitude of point X, of type DOUBLE, with a valid range of [-90,
90] (returns NULL if out of range). |
+| `<y_lng>` | Longitude of point Y, of type DOUBLE, with a valid range of
[-180, 180] (returns NULL if out of range). |
| `<y_lat>` | Latitude of point Y, of type DOUBLE, with a valid range of [-90,
90] (returns NULL if out of range). |
-## Retuen value
+## Return Value
Returns the shortest spherical distance between the two points, in meters (of
type DOUBLE).
@@ -36,7 +36,7 @@ ST_DISTANCE_SPHERE has the following edge cases:
- If the two points are completely identical (with the same longitude and
latitude values), returns 0 (distance is 0).
## Example
-Two identical points (returns 0)
+Two nearby points on Earth
```sql
select st_distance_sphere(116.35620117, 39.939093, 116.4274406433,
39.9020987219);
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-intersects.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-intersects.md
index 1dbe256fd61..0760a850a77 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-intersects.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-intersects.md
@@ -14,7 +14,7 @@ Determine whether two geometric shapes intersect, i.e., there
is at least one co
Supported since Apache Doris 3.0.6.
:::
-## Sytax
+## Syntax
```sql
ST_INTERSECTS( <shape1>, <shape2>)
@@ -24,8 +24,8 @@ ST_INTERSECTS( <shape1>, <shape2>)
| Parameter | Description |
|----------|------------------------|
-| `<shape1>` | The first geometric shape used to determine if it intersects
with another, supporting types such as Point, Line, Polygon, Circle。 |
-| `<shape2>` | The second geometric shape used to determine if it
intersects with another, supporting types such as Point, Line, Polygon, Circle。
|
+| `<shape1>` | The first geometric shape used to determine if it intersects
with another, supporting types such as Point, Line, Polygon, Circle. |
+| `<shape2>` | The second geometric shape used to determine if it
intersects with another, supporting types such as Point, Line, Polygon, Circle.
|
## Return value
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-linefromtext.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-linefromtext.md
index 234c2a57a7f..0781a8b0dd7 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-linefromtext.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-linefromtext.md
@@ -14,7 +14,7 @@ Converts a WKT (Well Known Text) string into an in-memory
representation of a Li
- ST_LINESTRINGFROMTEXT
-## Sytax
+## Syntax
```sql
ST_LINEFROMTEXT( <wkt>)
@@ -24,8 +24,8 @@ ST_LINEFROMTEXT( <wkt>)
| Parameters | Description |
|-----|------------|
-| `<wkt>` | A WKT string conforming to the LINE type, formatted as:
-"LINE (x1 y1, x2 y2)"
+| `<wkt>` | A WKT string conforming to the LINESTRING type, formatted as:
+"LINESTRING (x1 y1, x2 y2)"
Where (x1 y1), (x2 y2) are the vertex coordinates of the line segment.
Coordinate values are numeric (integers or decimals). |
## Return value
@@ -71,16 +71,15 @@ mysql> SELECT ST_LineFromText("LINESTRING (1 1, 2 2");
+-----------------------------------------+
```
-Invalid WKT (too many vertices)
+LineString with multiple vertices
```sql
-mysql> SELECT ST_LineFromText("LINESTRING (1 1,2 2,3 3)");
-+---------------------------------------------------------------------------------+
-| ST_LineFromText("LINESTRING (1 1,2 2,3 3)")
|
-+---------------------------------------------------------------------------------+
-| ��_<���?'���Xޑ?݉+
- ߑ?�����?(Qjm�ۡ?'���Xޡ?�3|ʏ��?lW<�`ª?��H�˪? |
-+---------------------------------------------------------------------------------+
+mysql> SELECT ST_AsText(ST_LineFromText('LINESTRING (1 1, 2 2)'));
++-----------------------------------------------------+
+| ST_AsText(ST_LineFromText('LINESTRING (1 1, 2 2)')) |
++-----------------------------------------------------+
+| LINESTRING (1 1, 2 2) |
++-----------------------------------------------------+
```
Input NULL
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-point.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-point.md
index 4537c86de4a..8d91bb62e73 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-point.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-point.md
@@ -11,7 +11,7 @@
Creates a Point geometry object from the given X and Y coordinates.
In geospatial contexts, X/Y typically represent longitude and latitude
respectively,
-## Sytax
+## Syntax
```sql
ST_POINT( <x>, <y>)
@@ -21,7 +21,7 @@ ST_POINT( <x>, <y>)
| Parameter | Description |
|-----|-----|
| `<x>` | X-coordinate (longitude) of the point, range: -180.0 to 180.0
(degrees) |
-| `<y>` | Y-coordinate (latitude) of the point, range: -90.0 to 90.0
(degrees)) |
+| `<y>` | Y-coordinate (latitude) of the point, range: -90.0 to 90.0 (degrees)
|
## Return value
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-polygon.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-polygon.md
index b1fdf1fef49..490f1b99b85 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-polygon.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-polygon.md
@@ -35,7 +35,7 @@ Converts a string in WKT (Well-Known Text) format into an
in-memory Polygon geom
- st_polygonfromtext
- st_polyfromtext
-## Sytax
+## Syntax
```sql
ST_POLYGON( <wkt>)
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-touches.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-touches.md
index dc9fea4d51c..882e4ace2ca 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-touches.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-touches.md
@@ -15,7 +15,7 @@ Returns 0 if there are no common points on the boundaries, or
if there is an int
This function is used to distinguish between "boundary-only contact" and
"internal intersection" scenarios, such as shared edges of adjacent polygons
(boundary-only contact) or tangent points between a line and a polygon
(boundary-only contact).
-## Sytax
+## Syntax
```sql
ST_TOUCHES( <shape1>, <shape2>)
@@ -39,7 +39,7 @@ ST_TOUCHES has the following edge cases:
- If the input geometric shape is invalid, returns NULL.
- If the input is an empty geometric object (e.g., POINT EMPTY), returns NULL.
- If one shape is completely contained within another (with internal
intersection), returns 0 even if their boundaries are in contact.
-- When a point is in contact with the boundary of a shape (a point has no
interior), returns 1 (the "boundary" of a point is itself, which coincides with
the shape's boundary with no internal intersection).。
+- When a point is in contact with the boundary of a shape (a point has no
interior), returns 1 (the "boundary" of a point is itself, which coincides with
the shape's boundary with no internal intersection).
## Example
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-x.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-x.md
index 02432575f3a..e2271486cf5 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-x.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-x.md
@@ -10,7 +10,7 @@
When the point is a valid POINT type, returns the corresponding X coordinate
value.
-## Sytax
+## Syntax
```sql
ST_X( <point>)
@@ -22,7 +22,7 @@ ST_X( <point>)
|------|----------|
| `<point>` | The geometric object from which to extract the X coordinate. It
must be a valid POINT type (2D point), where the X (longitude) range is [-180,
180] and the Y (latitude) range is [-90, 90].|
-## Retuen value
+## Return Value
The X value in the geometric coordinates, of type double-precision
floating-point number (Double).
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-y.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-y.md
index 1b650f6de63..6ed58bbdc15 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-y.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-y.md
@@ -10,7 +10,7 @@
Returns the Y coordinate of a valid POINT geometry. In geospatial contexts,
the Y coordinate typically corresponds to Latitude, ranging from [-90.0, 90.0]
(in degrees).
-## Sytax
+## Syntax
```sql
ST_Y( <point>)
@@ -22,7 +22,7 @@ ST_Y( <point>)
|------|----------|
| `<point>` | A valid 2D POINT geometry from which to extract the Y
coordinate. The Y value (latitude) must be within [-90.0, 90.0], and the X
value (longitude) must be within [-180.0, 180.0]. |
-## Retuen value
+## Return Value
The Y coordinate of the input POINT, returned as a DOUBLE PRECISION FLOAT.
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
index f57da2a3292..f4e9c9bd8cb 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/asinh.md
@@ -41,7 +41,7 @@ The asinh value of parameter `x`.
select asinh(0.0);
```
-```sql
+```text
+------------+
| asinh(0.0) |
+------------+
@@ -53,7 +53,7 @@ select asinh(0.0);
select asinh(1.0);
```
-```sql
+```text
+-------------------+
| asinh(1.0) |
+-------------------+
@@ -65,7 +65,7 @@ select asinh(1.0);
select asinh(-1.0);
```
-```sql
+```text
+--------------------+
| asinh(-1.0) |
+--------------------+
@@ -77,7 +77,7 @@ select asinh(-1.0);
select asinh(cast('nan' as double));
```
-```sql
+```text
+------------------------------+
| asinh(cast('nan' AS DOUBLE)) |
+------------------------------+
@@ -89,7 +89,7 @@ select asinh(cast('nan' as double));
select asinh(cast('inf' as double));
```
-```sql
+```text
+------------------------------+
| asinh(cast('inf' AS DOUBLE)) |
+------------------------------+
@@ -101,7 +101,7 @@ select asinh(cast('inf' as double));
select asinh(cast('-inf' as double));
```
-```sql
+```text
+-------------------------------+
| asinh(cast('-inf' AS DOUBLE)) |
+-------------------------------+
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/even.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/even.md
index fbde1fb6980..5cda06950eb 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/even.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/even.md
@@ -58,11 +58,11 @@ select even(2.9);
```
```text
-+----------+
++-----------+
| even(2.9) |
-+----------+
-| 4 |
-+----------+
++-----------+
+| 4 |
++-----------+
```
```sql
@@ -70,11 +70,11 @@ select even(-2.9);
```
```text
-+-----------+
++------------+
| even(-2.9) |
-+-----------+
-| -4 |
-+-----------+
++------------+
+| -4 |
++------------+
```
```sql
@@ -82,11 +82,11 @@ select even(4);
```
```text
-+--------+
++---------+
| even(4) |
-+--------+
-| 4 |
-+--------+
++---------+
+| 4 |
++---------+
```
```sql
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
index 4cd1b30a3e9..9bda011df8c 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/gcd.md
@@ -67,11 +67,11 @@ select gcd(-17, 31);
```
```text
-+-------------+
-| gcd(17,31) |
-+-------------+
-| 1 |
-+-------------+
++--------------+
+| gcd(-17,31) |
++--------------+
+| 1 |
++--------------+
```
```sql
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/lcm.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/lcm.md
index cda84aa799e..f80bfb31450 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/lcm.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/lcm.md
@@ -79,11 +79,11 @@ select lcm(-4, 6);
```
```text
-+------------+
-| lcm(-4,6) |
-+------------+
-| 12|
-+------------+
++-----------+
+| lcm(-4,6) |
++-----------+
+| 12 |
++-----------+
```
```sql
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/ln.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/ln.md
index 06179dbcaf8..1a63204b52b 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/ln.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/ln.md
@@ -32,7 +32,7 @@ Return a float-point number. Special cases:
- If x IS NULL, return NULL
- If x IS NaN, return NaN
-- If x is positive infinity or negative infinity, return NULL
+- If x is positive infinity, return Infinity
## Example
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log.md
index 1909f9f106a..47ce08b90bb 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log.md
@@ -13,15 +13,15 @@ Returns the logarithm of `x` based on base `b`.
## Syntax
```sql
-LOG(<b>[, <x>])
+LOG([<b>, ]<x>)
```
## Parameters
| Parameter | Description |
|-----------|------------|
-| `<b>` | Base should be greater than 0 and not be exactly 1.0 |
-| `<x>` | optional, Antilogarithm should be greater than 0, default value
is e |
+| `<b>` | Optional. Base should be greater than 0 and not be exactly 1.0.
If omitted, the natural logarithm (base e) is computed. |
+| `<x>` | Antilogarithm should be greater than 0 |
## Return value
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
index 9a94b6a69ee..9bfc7d71bff 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log10.md
@@ -2,13 +2,13 @@
{
"title": "LOG10",
"language": "en",
- "description": "Returns the natural logarithm of x to base 10."
+ "description": "Returns the logarithm of x to base 10."
}
---
## Description
-Returns the natural logarithm of `x` to base `10`.
+Returns the logarithm of `x` to base `10`.
## Alias
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
index 09032f5ae94..3c54ab0d8ab 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/log2.md
@@ -2,13 +2,13 @@
{
"title": "LOG2",
"language": "en",
- "description": "Returns the natural logarithm of x to base 2."
+ "description": "Returns the logarithm of x to base 2."
}
---
## Description
-Returns the natural logarithm of `x` to base `2`.
+Returns the logarithm of `x` to base `2`.
## Syntax
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
index 210c3580b99..ee759b25cf2 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/random.md
@@ -32,7 +32,7 @@ RANDOM(<a> , <b>) -- Generates a random number between a and b
|-----------|------------|
| `<seed>` | random number generator seed. Returns a fixed sequence of random
numbers between 0 and 1. |
| `<a>` | The lower bound of a random number. |
-| `<b>` | The upper bound of a random number. It must be less than the lower
bound. |
+| `<b>` | The upper bound of a random number. It must be greater than the
lower bound. |
## Return value
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
index 00e52bae911..253d79e0146 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
@@ -92,6 +92,6 @@ select signbit(cast('+0.0' as double)) , signbit(cast('-0.0'
as double));
+---------------------------------+---------------------------------+
| signbit(cast('+0.0' as double)) | signbit(cast('-0.0' as double)) |
+---------------------------------+---------------------------------+
-| 0 | 1 |
+| false | true |
+---------------------------------+---------------------------------+
```
\ No newline at end of file
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
index 6821e966fbb..4640241e034 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/truncate.md
@@ -37,7 +37,7 @@ If d is a column, and the first argument is of type Decimal,
then the resulting
## Example
- d is a litera
+ d is a literal
```sql
select truncate(124.3867, 2),truncate(124.3867, 0),truncate(124.3867, -2);
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
index c06787546ae..27ea25ac769 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/xor.md
@@ -1,6 +1,6 @@
---
{
- "title": "XOR | Numeric Functions",
+ "title": "XOR",
"language": "en",
"description": "Return the XOR value of two numbers.",
"sidebar_label": "XOR"
@@ -19,13 +19,15 @@ Return the XOR value of two numbers.
## Example
```sql
-mysql >select true xor false,true xor true;
+mysql> select true xor false, true xor true;
+```
+
+```text
+------------------+-----------------+
| (TRUE XOR FALSE) | (TRUE XOR TRUE) |
+------------------+-----------------+
| 1 | 0 |
+------------------+-----------------+
-
```
## Keywords
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
index ec5038f6c7b..92c61ddefee 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
@@ -13,7 +13,7 @@ This function converts numeric types to `QUANTILE_STATE`
type. The compression p
## Syntax
```sql
-TO_QUANTILE_STATE(<raw_data> <compression>)
+TO_QUANTILE_STATE(<raw_data>, <compression>)
```
## Parameters
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle-sphere.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle-sphere.md
index aee211f7880..1ce6579de3d 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle-sphere.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle-sphere.md
@@ -12,22 +12,22 @@ Calculates the central angle (in degrees) between two
points on the Earth's surf
The central angle refers to the angle at the center of the Earth subtended by
the arc connecting the two points.
-## Sytax
+## Syntax
```sql
ST_ANGLE_SPHERE( <x_lng>, <x_lat>, <y_lng>, <y_lat>)
```
-## 参数
+## Parameters
| parameters | description |
| -- | -- |
| `<x_lng>` | Longitude of point X, of type `DOUBLE`, with a valid range of
[-180, 180] |
-| `<y_lng>` | Longitude of point Y, of type `DOUBLE`, with a valid range of
[-180, 180] |
| `<x_lat>` | Latitude of point X, of type `DOUBLE`, with a valid range of
[-90, 90] |
+| `<y_lng>` | Longitude of point Y, of type `DOUBLE`, with a valid range of
[-180, 180] |
| `<y_lat>` | Latitude of point Y, of type `DOUBLE`, with a valid range of
[-90, 90] |
-## Retuen Value
+## Return Value
Returns the central angle between the two points in degrees, of type DOUBLE,
with a range of [0, 180].
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle.md
index 9e35fdac568..a57bf98a042 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle.md
@@ -10,7 +10,7 @@
Input three points. The first line is the straight line connecting point1
(first endpoint) and point2 (second endpoint). The second line is the straight
line connecting point2 (first endpoint) and point3 (second endpoint). These two
lines intersect at point2. The function returns the angle from the first line
to the second line in the clockwise direction. For each endpoint coordinate,
the x value (longitude) must be in the range [-180, 180], and the y value
(latitude) must be in the rang [...]
-## Sytax
+## Syntax
```sql
ST_ANGLE( <point1>, <point2>, <point3>)
@@ -24,7 +24,7 @@ ST_ANGLE( <point1>, <point2>, <point3>)
| `<point2>` | The second endpoint of the first line and the first endpoint of
the second line, of type `GeoPoint` |
| `<point3>` | The second endpoint of the second line, of type `GeoPoint` |
-## Retuen Value
+## Return Value
Returns the angle between the two lines in radians, as a double-precision
floating-point number, with a range of [0, 2π). The angle is measured clockwise
from the first line to the second line.
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
index 9db059ab0f8..77f65d22bea 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km.md
@@ -8,11 +8,11 @@
## Description
-Calculates the area of a closed region on the Earth's surface in square
kilometers. The input parameter is a geometric object (such as a
Geopolygon,GeoCircle,GeoMuitiPolygon ) representing a region on the Earth's
surface.
+Calculates the area of a closed region on the Earth's surface in square
kilometers. The input parameter is a geometric object (such as a GeoPolygon,
GeoCircle, GeoMultiPolygon) representing a region on the Earth's surface.
-## Sytax
+## Syntax
```sql
ST_AREA_SQUARE_KM( <geo>)
@@ -21,9 +21,9 @@ ST_AREA_SQUARE_KM( <geo>)
| Parameters | Description |
| -- |--------|
-| `<geo>` | A geometric object on the Earth's surface, of type
GeoPolygon,GeoCircle,GeoMultiCircle, must form a closed region.|
+| `<geo>` | A geometric object on the Earth's surface, of type GeoPolygon,
GeoCircle, GeoMultiPolygon, must form a closed region.|
-## Retuen value
+## Return Value
Returns the area of the region in square kilometers, as a DOUBLE type.
@@ -149,7 +149,7 @@ SELECT ST_Area_Square_Km(ST_Point(0, 1));
```text
+-------------------------------------------+
-| st_area_square_Km(st_point(0.0, 1.0)) |
+| st_area_square_km(st_point(0.0, 1.0)) |
+-------------------------------------------+
| 0 |
+-------------------------------------------+
@@ -163,7 +163,7 @@ SELECT ST_Area_Square_Km(ST_LineFromText("LINESTRING (1 1,
2 2)"));
```text
+-----------------------------------------------------------------+
-| st_area_square_Km(st_linefromtext('LINESTRING (1 1, 2 2)')) |
+| st_area_square_km(st_linefromtext('LINESTRING (1 1, 2 2)')) |
+-----------------------------------------------------------------+
| 0 |
+-----------------------------------------------------------------+
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-meters.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-meters.md
index fda801f47a5..95acdc97ac2 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-meters.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-meters.md
@@ -13,7 +13,7 @@ Calculates the area of a closed region on the Earth's surface
in square meters.
For non-closed geometric objects (such as points, line segments), their area
is 0; for invalid geometric objects (such as self-intersecting polygons),
returns NULL.
-## Sytax
+## Syntax
```sql
ST_AREA_SQUARE_METERS( <geo>)
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-asbinary.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-asbinary.md
index 25fb99ad2d6..6d64406f9be 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-asbinary.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-asbinary.md
@@ -30,7 +30,7 @@ under the License.
Converts a geometric object into a standard WKB (Well-Known Binary) binary
representation. WKB is a binary format for representing geospatial data, widely
used in Geographic Information Systems (GIS).
Currently supported geometric types include: Point, LineString, and Polygon.
-## Sytax
+## Syntax
```sql
ST_ASBINARY( <geo>)
@@ -40,9 +40,9 @@ ST_ASBINARY( <geo>)
| Parameter | Description |
| -- |----------|
-| `<geo>` | The geometric object to be converted to WKB format, including:
Point, LineString, Polygon.) |
+| `<geo>` | The geometric object to be converted to WKB format, including:
Point, LineString, Polygon. |
-## Retuen value
+## Return Value
Returns the WKB binary representation of the geometric object, displayed as a
hexadecimal string (e.g., \x01010000...).
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-astext.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-astext.md
index ea4ffd19698..1536994fd02 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-astext.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-astext.md
@@ -16,13 +16,13 @@ Currently supported geometric types include: Point,
LineString, Polygon, MultiPo
- ST_ASWKT
-## Sytax
+## Syntax
```sql
ST_ASTEXT( <geo>)
```
-# Parameters
+## Parameters
| Parameter | Description |
| -- |----------|
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-azimuth.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-azimuth.md
index 30dc3e08c48..29b33a81f21 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-azimuth.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-azimuth.md
@@ -12,7 +12,7 @@ Calculates the azimuth (in radians) between two points on the
Earth's surface. T
Azimuth is widely used in navigation and geographic information systems (GIS)
to represent the direction from one point to another.
-## Sytax
+## Syntax
```sql
ST_AZIMUTH( <point1>, <point2>)
@@ -24,7 +24,7 @@ ST_AZIMUTH( <point1>, <point2>)
| `<point1>` | The starting point, of type GeoPoint, serving as the reference
point for azimuth calculation. |
| `<point2>` | The ending point, of type GeoPoint, for which the direction
relative to the starting point is calculated. |
-## Retuen value
+## Return Value
Returns the azimuth between the two points in radians, with a range of [0,
2π). The azimuth is measured clockwise from true north, with specific direction
correspondences:
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-circle.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-circle.md
index bcf1a95fa33..734829b739d 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-circle.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-circle.md
@@ -10,7 +10,7 @@
Converts a WKT (Well-Known Text) into a circle on the Earth's spherical
surface.
-## Sytax
+## Syntax
```sql
ST_CIRCLE( <center_lng>, <center_lat>, <radius>)
@@ -20,11 +20,11 @@ ST_CIRCLE( <center_lng>, <center_lat>, <radius>)
| Parameter | Description |
| -- | -- |
| `<center_lng>` | Longitude of the circle's center, of type DOUBLE, with
a valid range of [-180, 180] |
-| `<center_lat>` | Latitude of the circle's center, of type DOUBLE, with a
valid range of [-180, 180] |
+| `<center_lat>` | Latitude of the circle's center, of type DOUBLE, with a
valid range of [-90, 90] |
| `<radius>` | Radius of the circle, of type DOUBLE, in meters
|
-## Retuen value
+## Return Value
Returns a circle on the Earth's spherical surface, of type GeoCircle. Its WKT
representation is CIRCLE ((<center_lng> <center_lat>), <radius>), which
contains the center coordinates and radius information.
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-contains.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-contains.md
index 41c0208aa92..b2930546ebf 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-contains.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-contains.md
@@ -13,7 +13,7 @@ Determines whether one geometric shape (shape1) completely
contains another geom
- For points: The point must lie inside or on the boundary of the polygon.
- For lines: All points of the line must lie inside or on the boundary of the
polygon.
- For polygons: The contained polygon must be entirely inside the outer
polygon (boundaries can overlap).
-## Sytax
+## Syntax
```sql
ST_CONTAINS( <shape1>, <shape2>)
@@ -23,10 +23,10 @@ ST_CONTAINS( <shape1>, <shape2>)
| Parameters | Description |
|----------|------------------------|
-| `<shape1>` | The geometric shape used to check if it contains another shape,
supporting the Polygon type.。 |
+| `<shape1>` | The geometric shape used to check if it contains another shape,
supporting the Polygon type. |
| `<shape2>` | The geometric shape used to check if it is contained,
supporting types such as Point, Line, Polygon, etc. |
-## Retuen value
+## Return Value
- 1: Indicates that shape1 completely contains shape2.
- 0: Indicates that shape1 does not contain shape2.
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-disjoint.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-disjoint.md
index a04e67f4e6c..bf43c6c1f46 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-disjoint.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-disjoint.md
@@ -14,7 +14,7 @@ Determines whether two geometric shapes are completely
disjoint (i.e., have no c
Supported since Apache Doris 3.0.6.
:::
-## Sytax
+## Syntax
```sql
ST_DISJOINT( <shape1>, <shape2> )
@@ -76,6 +76,7 @@ mysql> SELECT ST_Disjoint(ST_Linefromtext("LINESTRING (0 0,
10 10)"), ST_Point(1
| ST_Disjoint(ST_Linefromtext("LINESTRING (0 0, 10 10)"), ST_Point(1, 2)) |
+-------------------------------------------------------------------------+
| 1 |
++-------------------------------------------------------------------------+
```
Point and line intersect (point is on the line)
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance-sphere.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance-sphere.md
index b2df281b9f3..7d100349ee4 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance-sphere.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance-sphere.md
@@ -10,7 +10,7 @@
Calculate the spherical distance between two points on the Earth, in meters.
The input parameters are the longitude of point X, latitude of point X,
longitude of point Y, and latitude of point Y respectively.
-## Sytax
+## Syntax
```sql
ST_DISTANCE_SPHERE( <x_lng>, <x_lat>, <y_lng>, <y_lat>)
@@ -20,12 +20,12 @@ ST_DISTANCE_SPHERE( <x_lng>, <x_lat>, <y_lng>, <y_lat>)
| Parameter | Description |
| -- | -- |
-| `<x_lng>` | Longitude of point X, of type DOUBLE, with a valid range of
[-180, 180] (returns NULL if out of range).|
-| `<y_lng>` | Latitude of point X, of type DOUBLE, with a valid range of [-90,
90] (returns NULL if out of range). |
-| `<x_lat>` | Longitude of point Y, of type DOUBLE, with a valid range of
[-180, 180] (returns NULL if out of range). |
+| `<x_lng>` | Longitude of point X, of type DOUBLE, with a valid range of
[-180, 180] (returns NULL if out of range). |
+| `<x_lat>` | Latitude of point X, of type DOUBLE, with a valid range of [-90,
90] (returns NULL if out of range). |
+| `<y_lng>` | Longitude of point Y, of type DOUBLE, with a valid range of
[-180, 180] (returns NULL if out of range). |
| `<y_lat>` | Latitude of point Y, of type DOUBLE, with a valid range of [-90,
90] (returns NULL if out of range). |
-## Retuen value
+## Return Value
Returns the shortest spherical distance between the two points, in meters (of
type DOUBLE).
@@ -36,7 +36,7 @@ ST_DISTANCE_SPHERE has the following edge cases:
- If the two points are completely identical (with the same longitude and
latitude values), returns 0 (distance is 0).
## Example
-Two identical points (returns 0)
+Two nearby points on Earth
```sql
select st_distance_sphere(116.35620117, 39.939093, 116.4274406433,
39.9020987219);
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
index 96a58377c9b..85740d7a190 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance.md
@@ -43,11 +43,11 @@ Returns the shortest spherical distance between the
boundaries of the two geomet
SELECT ST_DISTANCE(ST_GeometryFromText('POINT(0 0)'),
ST_GeometryFromText('POINT(1 0)'));
```
```text
-+---------------------------------------------+
-| ST_Distance(ST_Point(0, 0), ST_Point(1, 0)) |
-+---------------------------------------------+
-| 111195.1011774839 |
-+---------------------------------------------+
++------------------------------------------------------------------------------------+
+| ST_DISTANCE(ST_GeometryFromText('POINT(0 0)'), ST_GeometryFromText('POINT(1
0)')) |
++------------------------------------------------------------------------------------+
+|
111195.1011774839 |
++------------------------------------------------------------------------------------+
```
**Distance Between a Point and a Line**
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-intersects.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-intersects.md
index 1dbe256fd61..0760a850a77 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-intersects.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-intersects.md
@@ -14,7 +14,7 @@ Determine whether two geometric shapes intersect, i.e., there
is at least one co
Supported since Apache Doris 3.0.6.
:::
-## Sytax
+## Syntax
```sql
ST_INTERSECTS( <shape1>, <shape2>)
@@ -24,8 +24,8 @@ ST_INTERSECTS( <shape1>, <shape2>)
| Parameter | Description |
|----------|------------------------|
-| `<shape1>` | The first geometric shape used to determine if it intersects
with another, supporting types such as Point, Line, Polygon, Circle。 |
-| `<shape2>` | The second geometric shape used to determine if it
intersects with another, supporting types such as Point, Line, Polygon, Circle。
|
+| `<shape1>` | The first geometric shape used to determine if it intersects
with another, supporting types such as Point, Line, Polygon, Circle. |
+| `<shape2>` | The second geometric shape used to determine if it
intersects with another, supporting types such as Point, Line, Polygon, Circle.
|
## Return value
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-linefromtext.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-linefromtext.md
index 234c2a57a7f..0781a8b0dd7 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-linefromtext.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-linefromtext.md
@@ -14,7 +14,7 @@ Converts a WKT (Well Known Text) string into an in-memory
representation of a Li
- ST_LINESTRINGFROMTEXT
-## Sytax
+## Syntax
```sql
ST_LINEFROMTEXT( <wkt>)
@@ -24,8 +24,8 @@ ST_LINEFROMTEXT( <wkt>)
| Parameters | Description |
|-----|------------|
-| `<wkt>` | A WKT string conforming to the LINE type, formatted as:
-"LINE (x1 y1, x2 y2)"
+| `<wkt>` | A WKT string conforming to the LINESTRING type, formatted as:
+"LINESTRING (x1 y1, x2 y2)"
Where (x1 y1), (x2 y2) are the vertex coordinates of the line segment.
Coordinate values are numeric (integers or decimals). |
## Return value
@@ -71,16 +71,15 @@ mysql> SELECT ST_LineFromText("LINESTRING (1 1, 2 2");
+-----------------------------------------+
```
-Invalid WKT (too many vertices)
+LineString with multiple vertices
```sql
-mysql> SELECT ST_LineFromText("LINESTRING (1 1,2 2,3 3)");
-+---------------------------------------------------------------------------------+
-| ST_LineFromText("LINESTRING (1 1,2 2,3 3)")
|
-+---------------------------------------------------------------------------------+
-| ��_<���?'���Xޑ?݉+
- ߑ?�����?(Qjm�ۡ?'���Xޡ?�3|ʏ��?lW<�`ª?��H�˪? |
-+---------------------------------------------------------------------------------+
+mysql> SELECT ST_AsText(ST_LineFromText('LINESTRING (1 1, 2 2)'));
++-----------------------------------------------------+
+| ST_AsText(ST_LineFromText('LINESTRING (1 1, 2 2)')) |
++-----------------------------------------------------+
+| LINESTRING (1 1, 2 2) |
++-----------------------------------------------------+
```
Input NULL
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-point.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-point.md
index 4537c86de4a..8d91bb62e73 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-point.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-point.md
@@ -11,7 +11,7 @@
Creates a Point geometry object from the given X and Y coordinates.
In geospatial contexts, X/Y typically represent longitude and latitude
respectively,
-## Sytax
+## Syntax
```sql
ST_POINT( <x>, <y>)
@@ -21,7 +21,7 @@ ST_POINT( <x>, <y>)
| Parameter | Description |
|-----|-----|
| `<x>` | X-coordinate (longitude) of the point, range: -180.0 to 180.0
(degrees) |
-| `<y>` | Y-coordinate (latitude) of the point, range: -90.0 to 90.0
(degrees)) |
+| `<y>` | Y-coordinate (latitude) of the point, range: -90.0 to 90.0 (degrees)
|
## Return value
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-polygon.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-polygon.md
index b1fdf1fef49..490f1b99b85 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-polygon.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-polygon.md
@@ -35,7 +35,7 @@ Converts a string in WKT (Well-Known Text) format into an
in-memory Polygon geom
- st_polygonfromtext
- st_polyfromtext
-## Sytax
+## Syntax
```sql
ST_POLYGON( <wkt>)
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-touches.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-touches.md
index dc9fea4d51c..882e4ace2ca 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-touches.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-touches.md
@@ -15,7 +15,7 @@ Returns 0 if there are no common points on the boundaries, or
if there is an int
This function is used to distinguish between "boundary-only contact" and
"internal intersection" scenarios, such as shared edges of adjacent polygons
(boundary-only contact) or tangent points between a line and a polygon
(boundary-only contact).
-## Sytax
+## Syntax
```sql
ST_TOUCHES( <shape1>, <shape2>)
@@ -39,7 +39,7 @@ ST_TOUCHES has the following edge cases:
- If the input geometric shape is invalid, returns NULL.
- If the input is an empty geometric object (e.g., POINT EMPTY), returns NULL.
- If one shape is completely contained within another (with internal
intersection), returns 0 even if their boundaries are in contact.
-- When a point is in contact with the boundary of a shape (a point has no
interior), returns 1 (the "boundary" of a point is itself, which coincides with
the shape's boundary with no internal intersection).。
+- When a point is in contact with the boundary of a shape (a point has no
interior), returns 1 (the "boundary" of a point is itself, which coincides with
the shape's boundary with no internal intersection).
## Example
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-x.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-x.md
index 02432575f3a..e2271486cf5 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-x.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-x.md
@@ -10,7 +10,7 @@
When the point is a valid POINT type, returns the corresponding X coordinate
value.
-## Sytax
+## Syntax
```sql
ST_X( <point>)
@@ -22,7 +22,7 @@ ST_X( <point>)
|------|----------|
| `<point>` | The geometric object from which to extract the X coordinate. It
must be a valid POINT type (2D point), where the X (longitude) range is [-180,
180] and the Y (latitude) range is [-90, 90].|
-## Retuen value
+## Return Value
The X value in the geometric coordinates, of type double-precision
floating-point number (Double).
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-y.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-y.md
index 1b650f6de63..6ed58bbdc15 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-y.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/spatial-functions/st-y.md
@@ -10,7 +10,7 @@
Returns the Y coordinate of a valid POINT geometry. In geospatial contexts,
the Y coordinate typically corresponds to Latitude, ranging from [-90.0, 90.0]
(in degrees).
-## Sytax
+## Syntax
```sql
ST_Y( <point>)
@@ -22,7 +22,7 @@ ST_Y( <point>)
|------|----------|
| `<point>` | A valid 2D POINT geometry from which to extract the Y
coordinate. The Y value (latitude) must be within [-90.0, 90.0], and the X
value (longitude) must be within [-180.0, 180.0]. |
-## Retuen value
+## Return Value
The Y coordinate of the input POINT, returned as a DOUBLE PRECISION FLOAT.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]