[
https://issues.apache.org/jira/browse/TRAFODION-2548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16057811#comment-16057811
]
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_r123298981
--- 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^
+| 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^
+.4+| 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^ ^7^
+| NATIONAL CHAR[ACTER] VARYING | Variable-length ASCII character string |
1 to 32703 characters^4^ ^7^
+.6+| Datetime Data Types .6+| Date-Time | | Point in time, using the
Gregorian calendar and a 24 hour clock system. The five supported designations
are listed below.
| YEAR 0001-9999 +
MONTH 1-12 +
DAY 1-31 +
- +
DAY constrained by MONTH and YEAR +
+
HOUR 0-23 +
MINUTE 0-59 +
SECOND 0-59 +
FRACTION(n) 0-999999 +
- +
in which n is the number of significant digits, from 1 to 6
-(default is 6; minimum is 1; maximum is 6). Actual database storage is
-incremental, as follows:
+(default is 6; minimum is 1; maximum is 6). +
+
+Actual database storage is incremental, as follows:
YEAR in 2 bytes +
MONTH in 1 byte +
DAY in 1 byte +
HOUR in 1 byte +
MINUTE in 1
byte SECOND in 1 byte +
FRACTION in 4 bytes +
-| | DATE | Date
| Format as YYYY-MM-DD; actual database storage size is 4 bytes
-| | TIME | Time of day, 24 hour clock, no time
precision. Format as HH:MM:SS; actual database storage size is 3 bytes
-| | TIME (with time precision) | Time of day, 24 hour clock, with time
precision | Format as HH:MM:SS.FFFFFF; actual database storage size is 7 bytes
-| | TIMESTAMP | Point in time, no time precision |
Format as YYYY-MM-DD HH:MM:SS; actual database storage size is 7 bytes
-| | TIMESTAMP (with time precision) Point in time, with time precision |
Format as YYYY-MM-DD HH:MM:SS.FFFFFF; actual database storage size is 1 byte
-| Interval | INTERVAL | Duration of time; value is in the YEAR/MONTH range
or the DAY/HOUR/MINUTE/YEAR/SECOND/FRACTION range
+| DATE | Date |
Format as YYYY-MM-DD; actual database storage size is 4 bytes
+| TIME | Time of day, 24 hour clock, no time
precision. | Format as HH:MM:SS; actual database storage size is 3 bytes
+| TIME (with time precision) | Time of day, 24 hour clock, with time
precision | Format as HH:MM:SS.FFFFFF; actual database storage size is 7 bytes
+| TIMESTAMP | Point in time, no time precision |
Format as YYYY-MM-DD HH:MM:SS; actual database storage size is 7 bytes
--- End diff --
A timestamp without a precision specified defaults to TIMESTAMP(6), with
microsecond precision and a storage length of 11.
> 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)
