trafodion-codereview mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From liuyu000 <...@git.apache.org>
Subject [GitHub] trafodion pull request #1737: [TRAFODION-3229] Update *Syntax Descriptions* ...
Date Tue, 06 Nov 2018 11:28:39 GMT
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*

----


---

Mime
View raw message