YugabyteDB (2.13.0.0-b42, bfc6a6643e7399ac8a0e81d06a3ee6d6571b33ab)

//--------------------------------------------------------------------------------------------------

// Copyright (c) YugaByte, Inc.

//

// Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except

// in compliance with the License.  You may obtain a copy of the License at

//

// http://www.apache.org/licenses/LICENSE-2.0

//

// Unless required by applicable law or agreed to in writing, software distributed under the License

// is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express

// or implied.  See the License for the specific language governing permissions and limitations

// under the License.

//

//--------------------------------------------------------------------------------------------------

#include "yb/yql/cql/ql/test/ql-test-base.h"

namespace yb {

namespace ql {

class TestQLConditionalDml : public QLTestBase {

 public:

  TestQLConditionalDml() : QLTestBase() {

  }

};

TEST_F(TestQLConditionalDml, TestQLConditionalDml) {

  // Init the simulated cluster.

  ASSERT_NO_FATALS(CreateSimulatedCluster());

  // Get a processor.

  TestQLProcessor *processor = GetQLProcessor();

  // Create the table 1.

  const char *create_stmt =

      "CREATE TABLE t (h1 int, h2 varchar, "

                      "r1 int, r2 varchar, "

                      "c1 int, c2 varchar, "

                      "primary key((h1, h2), r1, r2));";

  CHECK_VALID_STMT(create_stmt);

  // Test parsing of conditional DML:

  // Test insert IF NOT EXISTS

  PARSE_VALID_STMT("INSERT INTO t (h1, h2, r1, r2, c1, c2) "

                   "VALUES (1, 'a', 2, 'b', 3, 'c') IF NOT EXISTS OR c1 = 0;");

  // Test insert IF NOT EXISTS again

  PARSE_VALID_STMT("INSERT INTO t (h1, h2, r1, r2, c1, c2) "

                   "VALUES (1, 'a', 2, 'b', 3, 'c') IF NOT EXISTS AND h1 = 1;");

  // Test insert IF EXISTS

  PARSE_VALID_STMT("INSERT INTO t (k) VALUES (1) IF NOT EXISTS;");

  // Test insert IF NOT EXISTS or a column condition

  PARSE_VALID_STMT("INSERT INTO t (k, c) VALUES (1, 2) IF NOT EXISTS OR c = 1" );

  // Test insert IF NOT EXISTS and two column condition

  PARSE_VALID_STMT("INSERT INTO t (k, c) VALUES (1, 2) IF NOT EXISTS OR c >= 0 and c <= 1" );

  // Test update IF EXISTS

  PARSE_VALID_STMT("UPDATE t set c = 1 WHERE k = 1 IF EXISTS" );

  // Test update IF NOT EXISTS

  PARSE_VALID_STMT("UPDATE t set c = 1 WHERE k = 1 IF NOT EXISTS" );

  // Test update IF EXISTS and a column condition

  PARSE_VALID_STMT("UPDATE t set c = 1 WHERE k = 1 IF EXISTS AND c = 1" );

  // Test delete IF EXISTS

  PARSE_VALID_STMT("DELETE FROM t WHERE k = 1 IF EXISTS" );

  // Test delete IF EXISTS and a column condition

  PARSE_VALID_STMT("DELETE FROM t WHERE k = 1 IF EXISTS AND c = 1" );

  // Test delete IF EXISTS and 2 column conditions with paranthesis

  PARSE_VALID_STMT("DELETE FROM t WHERE k = 1 IF EXISTS AND (c = 1 OR c = 2)" );

}

} // namespace ql

} // namespace yb