[
https://issues.apache.org/jira/browse/TRAFODION-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16676642#comment-16676642
]
ASF GitHub Bot commented on TRAFODION-3229:
-------------------------------------------
GitHub user liuyu000 opened a pull request:
https://github.com/apache/trafodion/pull/1737
[TRAFODION-3229] Update *Syntax Descriptions* for *FLOAT* in *Trafodion SQL
Reference Manual*
IS_IPV6:
```
SQL>SELECT IS_IPV6('10.0.5.9'), IS_IPV6('::1') from dual;
(EXPR) (EXPR)
------ ------
0 1
--- 1 row(s) selected.
```
INET_ATON:
```
SQL>SELECT INET_ATON('10.0.5.9') from dual;
(EXPR)
----------
151322634
--- 1 row(s) selected.
```
INET_NTOA:
```
SQL>SELECT INET_NTOA(167773449) from dual;
(EXPR)
---------------
9.5.0.10
--- 1 row(s) selected.
```
ALTER TABLE Statement:
```
SQL>showddl float_1;
CREATE TABLE TRAFODION.SCH.FLOAT_1
(
A DOUBLE PRECISION DEFAULT NULL NOT
SERIALIZED
)
ATTRIBUTES ALIGNED FORMAT
;
-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON
TRAFODION.SCH.FLOAT_1 TO DB__ROOT WITH GRANT OPTION;
--- SQL operation complete.
```
```
SQL>alter table FLOAT_1 alter column a REAL;
--- SQL operation complete.
```
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/liuyu000/trafodion FLOAT
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1737.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1737
----
commit 66fb2f6fd011f393fbff690a370706f38364c48f
Author: liuyu000 <qwertyioz@...>
Date: 2018-11-06T11:14:27Z
[TRAFODION-3229] Update *Syntax Descriptions* for *FLOAT* in *Trafodion SQL
Reference Manual*
----
> Update *Syntax Descriptions* for *FLOAT* in *Trafodion SQL Reference Manual*
> ----------------------------------------------------------------------------
>
> Key: TRAFODION-3229
> URL: https://issues.apache.org/jira/browse/TRAFODION-3229
> Project: Apache Trafodion
> Issue Type: Documentation
> Reporter: Liu Yu
> Assignee: Liu Yu
> Priority: Major
> Fix For: 2.4
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
