This is an automated email from the ASF dual-hosted git repository.
gurwls223 pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/master by this push:
new debae7173e87 [SPARK-50651][SQL][DOCS] Add note about octal
representation for characters
debae7173e87 is described below
commit debae7173e87f55eb30d9ea50eb69fb571157cf3
Author: Kousuke Saruta <[email protected]>
AuthorDate: Tue Dec 24 11:11:48 2024 +0900
[SPARK-50651][SQL][DOCS] Add note about octal representation for characters
### What changes were proposed in this pull request?
This PR modifies `docs/sql-ref-literals.md` to mention about octal
representation for characters.
Currently there is no mention of it anywhere.
This change includes a trivial typo too which is in the same file.
### Why are the changes needed?
It's a public feature.
### Does this PR introduce _any_ user-facing change?
No.
### How was this patch tested?
Built the doc, then confirmed the result.
### Was this patch authored or co-authored using generative AI tooling?
No.
Closes #49273 from sarutak/octal-representation.
Lead-authored-by: Kousuke Saruta <[email protected]>
Co-authored-by: Hyukjin Kwon <[email protected]>
Signed-off-by: Hyukjin Kwon <[email protected]>
---
docs/sql-ref-literals.md | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)
diff --git a/docs/sql-ref-literals.md b/docs/sql-ref-literals.md
index 141f985b0bea..7a10676cce23 100644
--- a/docs/sql-ref-literals.md
+++ b/docs/sql-ref-literals.md
@@ -46,6 +46,7 @@ A string literal is used to specify a character string value.
One character from the character set. Use `\` to escape special characters
(e.g., `'` or `\`).
To represent unicode characters, use 16-bit or 32-bit unicode escape of
the form `\uxxxx` or `\Uxxxxxxxx`,
where xxxx and xxxxxxxx are 16-bit and 32-bit code points in hexadecimal
respectively (e.g., `\u3042` for `あ` and `\U0001F44D` for `👍`).
+ An ASCII character can also be represented as an octal number preceded by
`\` like `\101`, which represents `A`.
* **r**
@@ -78,14 +79,14 @@ SELECT "SPARK SQL" AS col;
+---------+
| col|
+---------+
-|Spark SQL|
+|SPARK SQL|
+---------+
SELECT 'it\'s $10.' AS col;
+---------+
| col|
+---------+
-|It's $10.|
+|it's $10.|
+---------+
SELECT r"'\n' represents newline character." AS col;
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]