[
https://issues.apache.org/jira/browse/TRAFODION-2548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16057810#comment-16057810
]
ASF GitHub Bot commented on TRAFODION-2548:
-------------------------------------------
Github user zellerh commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1133#discussion_r123298408
--- Diff:
docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc ---
@@ -320,84 +320,70 @@ more information, see <<cast_expression,CAST
Expression>>.
The following table summarizes the {project-name} SQL data types:
-[cols="13%,29%,29%,29%",options="header"]
+[cols="14%,14%,24%,24%,24%",options="header"]
|===
-| Type | SQL Designation | Description | Size or Range^1^
-| Fixed-length character | CHAR[ACTER] | Fixed-length character
data | 1 to 32707 characters^2^
-| | NCHAR | Fixed-length character
data in predefined national character set | 1 to 32707 bytes^3^ ^7^
-| | NATIONAL CHAR[ACTER] | Fixed-length character
data in predefined national character set | 1 to 32707 bytes^3^ ^7^
-| Variable-length character | VARCHAR |
Variable-length ASCII character string | 1 to 32703 characters^4^
-| | CHAR[ACTER] VARYING |
Variable-length ASCII character string | 1 to 32703 characters^4^
-| | NCHAR VARYING |
Variable-length ASCII character string | 1 to 32703 bytes^4^ ^8^
-| | NATIONAL CHAR[ACTER] VARYING |
Variable-length ASCII character string | 1 to 32703 characters^4^ ^8^
-| Numeric
-| NUMERIC (1,_scale_) to +
-NUMERIC (128,_scale_)
-| Binary number with optional scale; signed or unsigned for 1 to 9 digits
-| 1 to 128 digits; stored: +
-1 to 4 digits in 2 bytes +
- +
-5 to 9 digits in 4 bytes +
- +
-10 to 128 digits in 8-64 bytes, depending on precision
-| | SMALLINT | Binary
integer; signed or unsigned | 0 to 65535 unsigned, -32768 to +32767 signed;
stored in 2 bytes
-| | INTEGER | Binary
integer; signed or unsigned | 0 to 4294967295 unsigned, -2147483648 to
+2147483647 signed; stored in 4 bytes
-| | LARGEINT | Binary
integer; signed only | -2**63 to +(2**63)-1; stored in 8 bytes
-| Numeric (extended numeric precision) | NUMERIC (precision 19 to 128) |
Binary integer; signed or unsigned | Stored as multiple chunks of 16-bit
integers, with a minimum storage
-length of 8 bytes.
-| Floating point number
-| FLOAT[(_precision_)]
-| Floating point number; precision designates from 1 through 52 bits of
precision
-| +/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308; stored
in 8 bytes
-| | REAL |
Floating point number (32 bits) | +/- 1.17549435e-38 through +/
3.40282347e+38; stored in 4 bytes
-|
-| DOUBLE PRECISION
-| Floating-point numbers (64 bits) with 1 through 52 bits of precision (52
bits of binary precision and 1 bits of exponent)
-| +/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308; stored
in 8 byte
-| Decimal number
-| DECIMAL (1,_scale_) to DECIMAL (18,_scale_)
-| Decimal number with optional scale; stored as ASCII characters; signed
or unsigned for 1 to 9 digits; signed required for 10 or more digits
-| 1 to 18 digits. Byte length equals the number of digits. Sign is stored
as the first bit of the leftmost byte.
-|
-| Date-Time
-| Point in time, using the Gregorian calendar and a 24 hour clock system.
The five supported designations are listed below.
+| Category | Type | SQL Designation | Description | Size or Range^1^
+.7+| Character String Data Type .3+| Fixed-length character | CHAR[ACTER]
| Fixed-length character data | 1 to 32707 characters^2^
--- End diff --
I wonder where the limit of 32707 comes from. This may be from older
versions of this code (before Trafodion). I don't think there are any fixed
limits for CHAR and VARCHAR column sizes at this time.
> Add tinyint data type for sql reference manual
> -----------------------------------------------
>
> Key: TRAFODION-2548
> URL: https://issues.apache.org/jira/browse/TRAFODION-2548
> Project: Apache Trafodion
> Issue Type: Documentation
> Reporter: liu ming
> Assignee: Liu Yu
>
> refer to https://issues.apache.org/jira/browse/TRAFODION-2060
> Trafodion now supports new data types as in TRAFODION-2060, so documentation
> need to be updated accordingly.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
