kiszk commented on a change in pull request #28451: URL: https://github.com/apache/spark/pull/28451#discussion_r420182915
########## File path: docs/sql-ref-literals.md ########## @@ -71,128 +68,114 @@ SELECT 'it\'s $10.' AS col; +---------+ |It's $10.| +---------+ -{% endhighlight %} +``` ### Binary Literal A binary literal is used to specify a byte sequence value. #### Syntax -{% highlight sql %} -X { 'c [ ... ]' | "c [ ... ]" } -{% endhighlight %} +```sql +X { 'num [ ... ]' | "num [ ... ]" } +``` + +#### Parameters -#### <em>Parameters</em> +* **num** -<dl> - <dt><code><em>c</em></code></dt> - <dd> - One character from the character set. - </dd> -</dl> + Any hexadecimal number from 0 to F. -#### <em>Examples</em> +#### Examples -{% highlight sql %} +```sql SELECT X'123456' AS col; +----------+ | col| +----------+ |[12 34 56]| +----------+ -{% endhighlight %} +``` ### Null Literal A null literal is used to specify a null value. #### Syntax -{% highlight sql %} +```sql NULL -{% endhighlight %} +``` #### Examples -{% highlight sql %} +```sql SELECT NULL AS col; +----+ | col| +----+ |NULL| +----+ -{% endhighlight %} +``` ### Boolean Literal A boolean literal is used to specify a boolean value. #### Syntax -{% highlight sql %} +```sql TRUE | FALSE -{% endhighlight %} +``` #### Examples -{% highlight sql %} +```sql SELECT TRUE AS col; +----+ | col| +----+ |true| +----+ -{% endhighlight %} +``` ### Numeric Literal A numeric literal is used to specify a fixed or floating-point number. #### Integral Literal -#### Syntax +##### Syntax -{% highlight sql %} +```sql [ + | - ] digit [ ... ] [ L | S | Y ] -{% endhighlight %} +``` -#### Parameters +##### Parameters + +* **digit** -<dl> - <dt><code><em>digit</em></code></dt> - <dd> Any numeral from 0 to 9. - </dd> -</dl> -<dl> - <dt><code><em>L</em></code></dt> - <dd> - Case insensitive, indicates <code>BIGINT</code>, which is a 8-byte signed integer number. - </dd> -</dl> -<dl> - <dt><code><em>S</em></code></dt> - <dd> - Case insensitive, indicates <code>SMALLINT</code>, which is a 2-byte signed integer number. - </dd> -</dl> -<dl> - <dt><code><em>Y</em></code></dt> - <dd> - Case insensitive, indicates <code>TINYINT</code>, which is a 1-byte signed integer number. - </dd> -</dl> -<dl> - <dt><code><em>default (no postfix)</em></code></dt> - <dd> + +* **L** + + Case insensitive, indicates `BIGINT`, which is a 8-byte signed integer number. Review comment: nit: `an 8-byte` ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org