You are viewing a plain text version of this content. The canonical link for it is here.
Posted to codereview@trafodion.apache.org by liuyu000 <gi...@git.apache.org> on 2018/11/06 11:28:39 UTC
[GitHub] trafodion pull request #1737: [TRAFODION-3229] Update *Syntax Descriptions* ...
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 <qw...@...>
Date: 2018-11-06T11:14:27Z
[TRAFODION-3229] Update *Syntax Descriptions* for *FLOAT* in *Trafodion SQL Reference Manual*
----
---
[GitHub] trafodion pull request #1737: [TRAFODION-3229] Update *Syntax Descriptions* ...
Posted by asfgit <gi...@git.apache.org>.
Github user asfgit closed the pull request at:
https://github.com/apache/trafodion/pull/1737
---