trafodion-codereview mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anoopsharma00 <...@git.apache.org>
Subject [GitHub] incubator-trafodion pull request #674: JIRA TRAFODION-2180 enable/externaliz...
Date Fri, 26 Aug 2016 21:04:47 GMT
GitHub user anoopsharma00 opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/674

    JIRA TRAFODION-2180 enable/externalize non-ansi sql syntax/functionality

    Enabled and externalized support for following functionality:
    -- RANDOM and RANDOM(seed) functions
    -- CEIL (same as CEILING) math function
    -- GREATEST(val1, val2), LEAST(val1, val2)
      -- return greater or lesser value between val1 and val2
    -- MONTHS_BETWEEN(date1, date2)
      -- number of months between date1 and date2.
         +ve, if date1 > date2. -ve, otherwise
    -- LAST_DAY(<date>)
      -- date of the last day of the month of <date>
    -- NEXT_DAY(<date>, <string>)
      -- returns the date of the first weekday named by <string>
         that is later than the date <date>
    -- TRUNC. Same as DATE_TRUNC
    -- TO_NUMBER. Limited support.
    -- TO_TIMESTAMP.  Limited support.
    -- syntax BYTEINT (same as TINYINT)
    -- select UNIQUE ... from <tab>.  Same as DISTINCT
    -- NOT NULL ENABLE syntax in col defn (same as NOT NULL)
    -- Removal of all reserved keywords
    -- support for 'select * from DUAL'
    
    Other changes:
    -- error 8413 to indicate that source data being displayed is in hex
    
    -- "-failed" option to runregr and runallsb.
       It will rerun only the tests that have failed
    
    -- removed mode_special_2, mode_special_3, mode_special_5 cqds
    
    -- fixed an issue with hive data modification check
    
    -- alter rename stmt now writes generated object into metadata
    
    -- Infrastructure support for couple of JIRAs.
       These have not been enabled as default for this ckin but
       developer regressions are run after enabling them.
      -- JIRA TRAFODION-2181 Incompatible operations
      -- JIRA TRAFODION-2184 Groupby/Orderby extensions

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/anoopsharma00/incubator-trafodion ansharma_trafr21_br

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/674.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 #674
    
----
commit 9a41e522302b1aa6905f4072a55f5509dbb41198
Author: Anoop Sharma <anoop.sharma@esgyn.com>
Date:   2016-08-26T21:02:48Z

    JIRA TRAFODION-2180 enable/externalize non-ansi sql syntax/functionality
    
    Enabled and externalized support for following functionality:
    -- RANDOM and RANDOM(seed) functions
    -- CEIL (same as CEILING) math function
    -- GREATEST(val1, val2), LEAST(val1, val2)
      -- return greater or lesser value between val1 and val2
    -- MONTHS_BETWEEN(date1, date2)
      -- number of months between date1 and date2.
         +ve, if date1 > date2. -ve, otherwise
    -- LAST_DAY(<date>)
      -- date of the last day of the month of <date>
    -- NEXT_DAY(<date>, <string>)
      -- returns the date of the first weekday named by <string>
         that is later than the date <date>
    -- TRUNC. Same as DATE_TRUNC
    -- TO_NUMBER. Limited support.
    -- TO_TIMESTAMP.  Limited support.
    -- syntax BYTEINT (same as TINYINT)
    -- select UNIQUE ... from <tab>.  Same as DISTINCT
    -- NOT NULL ENABLE syntax in col defn (same as NOT NULL)
    -- Removal of all reserved keywords
    -- support for 'select * from DUAL'
    
    Other changes:
    -- error 8413 to indicate that source data being displayed is in hex
    
    -- "-failed" option to runregr and runallsb.
       It will rerun only the tests that have failed
    
    -- removed mode_special_2, mode_special_3, mode_special_5 cqds
    
    -- fixed an issue with hive data modification check
    
    -- alter rename stmt now writes generated object into metadata
    
    -- Infrastructure support for couple of JIRAs.
       These have not been enabled as default for this ckin but
       developer regressions are run after enabling them.
      -- JIRA TRAFODION-2181 Incompatible operations
      -- JIRA TRAFODION-2184 Groupby/Orderby extensions

----


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

Mime
View raw message