trafodion-codereview mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DaveBirdsall <...@git.apache.org>
Subject [GitHub] trafodion pull request #1587: [TRAFODION-3094] Add Syntax and Examples for *...
Date Mon, 02 Jul 2018 23:56:26 GMT
Github user DaveBirdsall commented on a diff in the pull request:

    https://github.com/apache/trafodion/pull/1587#discussion_r199651804
  
    --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
    @@ -4342,6 +4363,45 @@ DELETE FROM invent.partsupp WHERE suppnum NOT IN
     delete from table1 where a in (select a from table1 where b > 200)
     ```
     
    +* This example executes a non-transactional delete of first 1000 rows that satisfy the
    +WHERE condition.
    ++
    +```
    +DELETE WITH NO ROLLBACK [FIRST 1000] 
    +FROM test 
    +WHERE id<30;
    +```
    +
    +* This example shows that the option `WITH NO ROLLBACK` is only supported if there is
no
    +index on the table.
    ++
    +```
    +SQL>DELETE WITH NO ROLLBACK FROM test;
    +
    +*** ERROR[3232] INSERT, UPDATE, or DELETE of table TRAFODION.SEABASE.TEST with dependent
Index : TRAFODION.SEABASE.INDEX_TEST is not allowed when NO ROLLBACK transaction setting is
in effect. [2018-05-30 05:42:47]
    --- End diff --
    
    Keeping it is fine.


---

Mime
View raw message