<included /home/prom1se/GG/calcite_work/var/suite-sql_combination/test_modules/test_sql_combination/test_sql_combination/dml_merge_with_memory/dml_merge_with_memory..calcite.sql.1.log>
Setting property: [force, true]
Setting property: [showWarnings, true]
Setting property: [showNestedErrs, true]
issuing: !connect jdbc:ignite:thin://127.0.0.1/?useExperimentalQueryEngine=true '' '' org.apache.ignite.IgniteJdbcThinDriver
Connecting to jdbc:ignite:thin://127.0.0.1/?useExperimentalQueryEngine=true
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Connected to: Apache Ignite (version 2.9.0#20210209-sha1:2fa4e2b8)
Driver: Apache Ignite Thin JDBC Driver (version 2.9.0#20210209-sha1:2fa4e2b8)
Autocommit status: true
Transaction isolation: TRANSACTION_REPEATABLE_READ
1/268        !outputformat csv
2/268        !record /home/prom1se/GG/calcite_work/var/suite-sql_combination/test_modules/test_sql_combination/test_sql_combination/dml_merge_with_memory/dml_merge_with_memory..calcite.sql.1.record.txt
Saving all output to "/home/prom1se/GG/calcite_work/var/suite-sql_combination/test_modules/test_sql_combination/test_sql_combination/dml_merge_with_memory/dml_merge_with_memory..calcite.sql.1.record.txt". Enter "record" with no arguments to stop it.
3/268        # t1: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't1', 'offset': 1}
4/268        # t2: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't2', 'offset': 2}
5/268        # t3: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't3', 'offset': 3}
6/268        # t4: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't4', 'offset': 4}
7/268        # t5: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't5', 'offset': 5}
8/268        # t6: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't6', 'offset': 6}
9/268        # t7: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't7', 'offset': 7}
10/268       # t8: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't8', 'offset': 8}
11/268       # t9: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't9', 'offset': 9}
12/268       # t10: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't10', 'offset': 1}
13/268       # t11: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't11', 'offset': 1}
14/268       # t12: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't12', 'offset': 1}
15/268       # t13: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't13', 'offset': 1}
16/268       # t14: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't14', 'offset': 1}
17/268       # t15: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't15', 'offset': 1}
18/268       # t16: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't16', 'offset': 1}
19/268       # t17: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't17', 'offset': 1}
20/268       # t18: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't18', 'offset': 1}
21/268       # t19: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't19', 'offset': 1}
22/268       # t20: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't20', 'offset': 2}
23/268       # t21: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't21', 'offset': 2}
24/268       # t22: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't22', 'offset': 2}
25/268       # t23: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't23', 'offset': 2}
26/268       # t24: {'order': ['id', 'bool_col', 'tinyint_col', 'smallint_col', 'int_col', 'bigint_col', 'varchar_col', 'char_col', 'float_col', 'double_col', 'time_col'], 'columns': {'id': 'INT NOT NULL', 'bool_col': 'BOOLEAN', 'tinyint_col': 'TINYINT', 'smallint_col': 'SMALLINT', 'int_col': 'INT', 'bigint_col': 'BIGINT', 'varchar_col': 'VARCHAR', 'char_col': 'CHAR', 'float_col': 'FLOAT', 'double_col': 'DOUBLE', 'time_col': 'TIME'}, 'pk': ['id'], 'name': 't24', 'offset': 2}
27/268       # START BLOCK t1
28/268       CREATE TABLE t1 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) ;
No rows affected (0.186 seconds)
29/268       # DATA LOADING FOR t1
30/268       INSERT INTO t1 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (2,TRUE,0,0,0,0,'string_2','string_2',0,2,'05:46:42'),(3,FALSE,-1,-1,-1,-1,'string_3','string_3',-1.1,3,'05:46:43'),(4,TRUE,1,1,1,1,'string_4','string_4',1.1,4,'05:46:44'),(5,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_5','string_5',5,5,'05:46:45'),(-6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_7','string_7',7,7,'05:46:47'),(8,TRUE,126,32766,2147483646,9223372036854775806,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,9,9,9,9,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.035 seconds)
31/268       SELECT * FROM t1 WHERE id=1 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (1.243 seconds)
32/268       MERGE INTO t1 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(1, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.007 seconds)
33/268       MERGE INTO t1 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.002 seconds)
34/268       SELECT * FROM t1 WHERE id=1 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'1','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.063 seconds)
35/268       DROP TABLE t1;
No rows affected (0.03 seconds)
36/268       # END BLOCK t1
37/268       # START BLOCK t2
38/268       CREATE TABLE t2 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=part-atomic-b2-full_sync";
No rows affected (0.017 seconds)
39/268       # DATA LOADING FOR t2
40/268       INSERT INTO t2 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (3,FALSE,0,0,0,0,'string_3','string_3',0,3,'05:46:43'),(4,TRUE,-1,-1,-1,-1,'string_4','string_4',-1.1,4,'05:46:44'),(5,FALSE,1,1,1,1,'string_5','string_5',1.1,5,'05:46:45'),(-6,TRUE,-128,-32768,-2147483648,-9223372036854775808,'string_6','string_6',-6,6,'05:46:46'),(7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,TRUE,-127,-32767,-2147483647,-9223372036854775807,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,126,32766,2147483646,9223372036854775806,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,FALSE,-11,-11,-11,-11,'string_11','string_11',-11,11,'05:46:51'),(12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.01 seconds)
41/268       SELECT * FROM t2 WHERE id=2 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.04 seconds)
42/268       MERGE INTO t2 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(2, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.002 seconds)
43/268       MERGE INTO t2 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.003 seconds)
44/268       SELECT * FROM t2 WHERE id=2 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'2','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.03 seconds)
45/268       DROP TABLE t2;
No rows affected (0.009 seconds)
46/268       # END BLOCK t2
47/268       # START BLOCK t3
48/268       CREATE TABLE t3 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=part-tx-b2-full_sync";
No rows affected (0.013 seconds)
49/268       # DATA LOADING FOR t3
50/268       INSERT INTO t3 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (4,TRUE,0,0,0,0,'string_4','string_4',0,4,'05:46:44'),(5,FALSE,-1,-1,-1,-1,'string_5','string_5',-1.1,5,'05:46:45'),(-6,TRUE,1,1,1,1,'string_6','string_6',1.1,6,'05:46:46'),(7,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_7','string_7',7,7,'05:46:47'),(8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,126,32766,2147483646,9223372036854775806,'string_10','string_10',10,10,'05:46:50'),(-11,FALSE,-11,-11,-11,-11,'string_11','string_11',-11,11,'05:46:51'),(12,TRUE,12,12,12,12,'string_12','string_12',12,12,'05:46:52'),(13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.046 seconds)
51/268       SELECT * FROM t3 WHERE id=3 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.035 seconds)
52/268       MERGE INTO t3 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(3, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.003 seconds)
53/268       MERGE INTO t3 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.003 seconds)
54/268       SELECT * FROM t3 WHERE id=3 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'3','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.033 seconds)
55/268       DROP TABLE t3;
No rows affected (0.008 seconds)
56/268       # END BLOCK t3
57/268       # START BLOCK t4
58/268       CREATE TABLE t4 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=part-atomic-b0-full_sync";
No rows affected (0.013 seconds)
59/268       # DATA LOADING FOR t4
60/268       INSERT INTO t4 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (5,FALSE,0,0,0,0,'string_5','string_5',0,5,'05:46:45'),(-6,TRUE,-1,-1,-1,-1,'string_6','string_6',-1.1,6,'05:46:46'),(7,FALSE,1,1,1,1,'string_7','string_7',1.1,7,'05:46:47'),(8,TRUE,-128,-32768,-2147483648,-9223372036854775808,'string_8','string_8',8,8,'05:46:48'),(9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,TRUE,-127,-32767,-2147483647,-9223372036854775807,'string_10','string_10',10,10,'05:46:50'),(-11,FALSE,126,32766,2147483646,9223372036854775806,'string_11','string_11',-11,11,'05:46:51'),(12,TRUE,12,12,12,12,'string_12','string_12',12,12,'05:46:52'),(13,FALSE,13,13,13,13,'string_13','string_13',13,13,'05:46:53'),(14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.009 seconds)
61/268       SELECT * FROM t4 WHERE id=4 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.027 seconds)
62/268       MERGE INTO t4 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(4, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.002 seconds)
63/268       MERGE INTO t4 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.002 seconds)
64/268       SELECT * FROM t4 WHERE id=4 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'4','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.026 seconds)
65/268       DROP TABLE t4;
No rows affected (0.009 seconds)
66/268       # END BLOCK t4
67/268       # START BLOCK t5
68/268       CREATE TABLE t5 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=part-tx-b0-full_sync";
No rows affected (0.011 seconds)
69/268       # DATA LOADING FOR t5
70/268       INSERT INTO t5 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (-6,TRUE,0,0,0,0,'string_6','string_6',0,6,'05:46:46'),(7,FALSE,-1,-1,-1,-1,'string_7','string_7',-1.1,7,'05:46:47'),(8,TRUE,1,1,1,1,'string_8','string_8',1.1,8,'05:46:48'),(9,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_9','string_9',9,9,'05:46:49'),(10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(-11,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_11','string_11',-11,11,'05:46:51'),(12,TRUE,126,32766,2147483646,9223372036854775806,'string_12','string_12',12,12,'05:46:52'),(13,FALSE,13,13,13,13,'string_13','string_13',13,13,'05:46:53'),(14,TRUE,14,14,14,14,'string_14','string_14',14,14,'05:46:54'),(15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.015 seconds)
71/268       SELECT * FROM t5 WHERE id=5 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.023 seconds)
72/268       MERGE INTO t5 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(5, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.003 seconds)
73/268       MERGE INTO t5 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.003 seconds)
74/268       SELECT * FROM t5 WHERE id=5 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'5','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.024 seconds)
75/268       DROP TABLE t5;
No rows affected (0.008 seconds)
76/268       # END BLOCK t5
77/268       # START BLOCK t6
78/268       CREATE TABLE t6 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=repl-atomic-full_sync";
No rows affected (0.01 seconds)
79/268       # DATA LOADING FOR t6
80/268       INSERT INTO t6 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (7,FALSE,0,0,0,0,'string_7','string_7',0,7,'05:46:47'),(8,TRUE,-1,-1,-1,-1,'string_8','string_8',-1.1,8,'05:46:48'),(9,FALSE,1,1,1,1,'string_9','string_9',1.1,9,'05:46:49'),(10,TRUE,-128,-32768,-2147483648,-9223372036854775808,'string_10','string_10',10,10,'05:46:50'),(-11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,TRUE,-127,-32767,-2147483647,-9223372036854775807,'string_12','string_12',12,12,'05:46:52'),(13,FALSE,126,32766,2147483646,9223372036854775806,'string_13','string_13',13,13,'05:46:53'),(14,TRUE,14,14,14,14,'string_14','string_14',14,14,'05:46:54'),(15,FALSE,15,15,15,15,'string_15','string_15',15,15,'05:46:55'),(-16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.007 seconds)
81/268       SELECT * FROM t6 WHERE id=6 OR id=10001;
Error: org.apache.ignite.internal.processors.query.calcite.metadata.ColocationMappingException: Failed to map fragment to location. Replicated query parts are not co-located on all nodes (state=50000,code=1)
java.sql.SQLException: org.apache.ignite.internal.processors.query.calcite.metadata.ColocationMappingException: Failed to map fragment to location. Replicated query parts are not co-located on all nodes
	at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:1009)
	at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:234)
	at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:560)
	at sqlline.Commands.execute(Commands.java:823)
	at sqlline.Commands.sql(Commands.java:733)
	at sqlline.SqlLine.dispatch(SqlLine.java:795)
	at sqlline.SqlLine.runCommands(SqlLine.java:1706)
	at sqlline.Commands.run(Commands.java:1317)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
	at sqlline.SqlLine.dispatch(SqlLine.java:791)
	at sqlline.SqlLine.initArgs(SqlLine.java:595)
	at sqlline.SqlLine.begin(SqlLine.java:643)
	at sqlline.SqlLine.start(SqlLine.java:373)
	at sqlline.SqlLine.main(SqlLine.java:265)
82/268       MERGE INTO t6 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(6, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.002 seconds)
83/268       MERGE INTO t6 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.002 seconds)
84/268       SELECT * FROM t6 WHERE id=6 OR id=10001 ORDER BY id;
Error: org.apache.ignite.internal.processors.query.calcite.metadata.ColocationMappingException: Failed to map fragment to location. Replicated query parts are not co-located on all nodes (state=50000,code=1)
java.sql.SQLException: org.apache.ignite.internal.processors.query.calcite.metadata.ColocationMappingException: Failed to map fragment to location. Replicated query parts are not co-located on all nodes
	at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:1009)
	at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:234)
	at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:560)
	at sqlline.Commands.execute(Commands.java:823)
	at sqlline.Commands.sql(Commands.java:733)
	at sqlline.SqlLine.dispatch(SqlLine.java:795)
	at sqlline.SqlLine.runCommands(SqlLine.java:1706)
	at sqlline.Commands.run(Commands.java:1317)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
	at sqlline.SqlLine.dispatch(SqlLine.java:791)
	at sqlline.SqlLine.initArgs(SqlLine.java:595)
	at sqlline.SqlLine.begin(SqlLine.java:643)
	at sqlline.SqlLine.start(SqlLine.java:373)
	at sqlline.SqlLine.main(SqlLine.java:265)
85/268       DROP TABLE t6;
No rows affected (0.009 seconds)
86/268       # END BLOCK t6
87/268       # START BLOCK t7
88/268       CREATE TABLE t7 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=repl-tx-full_sync";
No rows affected (0.012 seconds)
89/268       # DATA LOADING FOR t7
90/268       INSERT INTO t7 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (8,TRUE,0,0,0,0,'string_8','string_8',0,8,'05:46:48'),(9,FALSE,-1,-1,-1,-1,'string_9','string_9',-1.1,9,'05:46:49'),(10,TRUE,1,1,1,1,'string_10','string_10',1.1,10,'05:46:50'),(-11,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_11','string_11',-11,11,'05:46:51'),(12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_13','string_13',13,13,'05:46:53'),(14,TRUE,126,32766,2147483646,9223372036854775806,'string_14','string_14',14,14,'05:46:54'),(15,FALSE,15,15,15,15,'string_15','string_15',15,15,'05:46:55'),(-16,TRUE,-16,-16,-16,-16,'string_16','string_16',-16,16,'05:46:56'),(17,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.014 seconds)
91/268       SELECT * FROM t7 WHERE id=7 OR id=10001;
Error: org.apache.ignite.internal.processors.query.calcite.metadata.ColocationMappingException: Failed to map fragment to location. Replicated query parts are not co-located on all nodes (state=50000,code=1)
java.sql.SQLException: org.apache.ignite.internal.processors.query.calcite.metadata.ColocationMappingException: Failed to map fragment to location. Replicated query parts are not co-located on all nodes
	at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:1009)
	at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:234)
	at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:560)
	at sqlline.Commands.execute(Commands.java:823)
	at sqlline.Commands.sql(Commands.java:733)
	at sqlline.SqlLine.dispatch(SqlLine.java:795)
	at sqlline.SqlLine.runCommands(SqlLine.java:1706)
	at sqlline.Commands.run(Commands.java:1317)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
	at sqlline.SqlLine.dispatch(SqlLine.java:791)
	at sqlline.SqlLine.initArgs(SqlLine.java:595)
	at sqlline.SqlLine.begin(SqlLine.java:643)
	at sqlline.SqlLine.start(SqlLine.java:373)
	at sqlline.SqlLine.main(SqlLine.java:265)
92/268       MERGE INTO t7 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(7, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.004 seconds)
93/268       MERGE INTO t7 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.002 seconds)
94/268       SELECT * FROM t7 WHERE id=7 OR id=10001 ORDER BY id;
Error: org.apache.ignite.internal.processors.query.calcite.metadata.ColocationMappingException: Failed to map fragment to location. Replicated query parts are not co-located on all nodes (state=50000,code=1)
java.sql.SQLException: org.apache.ignite.internal.processors.query.calcite.metadata.ColocationMappingException: Failed to map fragment to location. Replicated query parts are not co-located on all nodes
	at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:1009)
	at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:234)
	at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:560)
	at sqlline.Commands.execute(Commands.java:823)
	at sqlline.Commands.sql(Commands.java:733)
	at sqlline.SqlLine.dispatch(SqlLine.java:795)
	at sqlline.SqlLine.runCommands(SqlLine.java:1706)
	at sqlline.Commands.run(Commands.java:1317)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
	at sqlline.SqlLine.dispatch(SqlLine.java:791)
	at sqlline.SqlLine.initArgs(SqlLine.java:595)
	at sqlline.SqlLine.begin(SqlLine.java:643)
	at sqlline.SqlLine.start(SqlLine.java:373)
	at sqlline.SqlLine.main(SqlLine.java:265)
95/268       DROP TABLE t7;
No rows affected (0.009 seconds)
96/268       # END BLOCK t7
97/268       # START BLOCK t8
98/268       CREATE TABLE t8 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=replicated";
No rows affected (0.032 seconds)
99/268       # DATA LOADING FOR t8
100/268      INSERT INTO t8 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (9,FALSE,0,0,0,0,'string_9','string_9',0,9,'05:46:49'),(10,TRUE,-1,-1,-1,-1,'string_10','string_10',-1.1,10,'05:46:50'),(-11,FALSE,1,1,1,1,'string_11','string_11',1.1,11,'05:46:51'),(12,TRUE,-128,-32768,-2147483648,-9223372036854775808,'string_12','string_12',12,12,'05:46:52'),(13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,TRUE,-127,-32767,-2147483647,-9223372036854775807,'string_14','string_14',14,14,'05:46:54'),(15,FALSE,126,32766,2147483646,9223372036854775806,'string_15','string_15',15,15,'05:46:55'),(-16,TRUE,-16,-16,-16,-16,'string_16','string_16',-16,16,'05:46:56'),(17,FALSE,17,17,17,17,'string_17','string_17',17,17,'05:46:57'),(18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.008 seconds)
101/268      SELECT * FROM t8 WHERE id=8 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.02 seconds)
102/268      MERGE INTO t8 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(8, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.002 seconds)
103/268      MERGE INTO t8 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.002 seconds)
104/268      SELECT * FROM t8 WHERE id=8 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'8','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.025 seconds)
105/268      DROP TABLE t8;
No rows affected (0.009 seconds)
106/268      # END BLOCK t8
107/268      # START BLOCK t9
108/268      CREATE TABLE t9 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, BACKUPS=4, DATA_REGION=dataRegion1";
No rows affected (0.044 seconds)
109/268      # DATA LOADING FOR t9
110/268      INSERT INTO t9 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (10,TRUE,0,0,0,0,'string_10','string_10',0,10,'05:46:50'),(-11,FALSE,-1,-1,-1,-1,'string_11','string_11',-1.1,11,'05:46:51'),(12,TRUE,1,1,1,1,'string_12','string_12',1.1,12,'05:46:52'),(13,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_13','string_13',13,13,'05:46:53'),(14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_15','string_15',15,15,'05:46:55'),(-16,TRUE,126,32766,2147483646,9223372036854775806,'string_16','string_16',-16,16,'05:46:56'),(17,FALSE,17,17,17,17,'string_17','string_17',17,17,'05:46:57'),(18,TRUE,18,18,18,18,'string_18','string_18',18,18,'05:46:58'),(19,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.008 seconds)
111/268      SELECT * FROM t9 WHERE id=9 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.023 seconds)
112/268      MERGE INTO t9 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(9, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.002 seconds)
113/268      MERGE INTO t9 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.002 seconds)
114/268      SELECT * FROM t9 WHERE id=9 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'9','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.023 seconds)
115/268      DROP TABLE t9;
No rows affected (0.01 seconds)
116/268      # END BLOCK t9
117/268      # START BLOCK t10
118/268      CREATE TABLE t10 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, ATOMICITY=ATOMIC, DATA_REGION=dataRegion1";
No rows affected (0.047 seconds)
119/268      # DATA LOADING FOR t10
120/268      INSERT INTO t10 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (2,TRUE,0,0,0,0,'string_2','string_2',0,2,'05:46:42'),(3,FALSE,-1,-1,-1,-1,'string_3','string_3',-1.1,3,'05:46:43'),(4,TRUE,1,1,1,1,'string_4','string_4',1.1,4,'05:46:44'),(5,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_5','string_5',5,5,'05:46:45'),(-6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_7','string_7',7,7,'05:46:47'),(8,TRUE,126,32766,2147483646,9223372036854775806,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,9,9,9,9,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.01 seconds)
121/268      SELECT * FROM t10 WHERE id=10 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'10','true','10','10','10','10','string_10','string_10','10.0','10.0','05:46:50'
1 row selected (0.025 seconds)
122/268      MERGE INTO t10 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.002 seconds)
123/268      MERGE INTO t10 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.002 seconds)
124/268      SELECT * FROM t10 WHERE id=10 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'10','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.021 seconds)
125/268      DROP TABLE t10;
No rows affected (0.011 seconds)
126/268      # END BLOCK t10
127/268      # START BLOCK t11
128/268      CREATE TABLE t11 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, ATOMICITY=TRANSACTIONAL, DATA_REGION=dataRegion1";
No rows affected (0.048 seconds)
129/268      # DATA LOADING FOR t11
130/268      INSERT INTO t11 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (2,TRUE,0,0,0,0,'string_2','string_2',0,2,'05:46:42'),(3,FALSE,-1,-1,-1,-1,'string_3','string_3',-1.1,3,'05:46:43'),(4,TRUE,1,1,1,1,'string_4','string_4',1.1,4,'05:46:44'),(5,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_5','string_5',5,5,'05:46:45'),(-6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_7','string_7',7,7,'05:46:47'),(8,TRUE,126,32766,2147483646,9223372036854775806,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,9,9,9,9,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.016 seconds)
131/268      SELECT * FROM t11 WHERE id=11 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.022 seconds)
132/268      MERGE INTO t11 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(11, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.002 seconds)
133/268      MERGE INTO t11 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.003 seconds)
134/268      SELECT * FROM t11 WHERE id=11 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'11','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.027 seconds)
135/268      DROP TABLE t11;
No rows affected (0.01 seconds)
136/268      # END BLOCK t11
137/268      # START BLOCK t12
138/268      CREATE TABLE t12 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, WRITE_SYNCHRONIZATION_MODE=FULL_SYNC, DATA_REGION=dataRegion1";
No rows affected (0.05 seconds)
139/268      # DATA LOADING FOR t12
140/268      INSERT INTO t12 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (2,TRUE,0,0,0,0,'string_2','string_2',0,2,'05:46:42'),(3,FALSE,-1,-1,-1,-1,'string_3','string_3',-1.1,3,'05:46:43'),(4,TRUE,1,1,1,1,'string_4','string_4',1.1,4,'05:46:44'),(5,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_5','string_5',5,5,'05:46:45'),(-6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_7','string_7',7,7,'05:46:47'),(8,TRUE,126,32766,2147483646,9223372036854775806,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,9,9,9,9,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.009 seconds)
141/268      SELECT * FROM t12 WHERE id=12 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.021 seconds)
142/268      MERGE INTO t12 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(12, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.001 seconds)
143/268      MERGE INTO t12 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.001 seconds)
144/268      SELECT * FROM t12 WHERE id=12 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'12','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.02 seconds)
145/268      DROP TABLE t12;
No rows affected (0.009 seconds)
146/268      # END BLOCK t12
147/268      # START BLOCK t13
148/268      CREATE TABLE t13 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, BACKUPS=4, DATA_REGION=dataRegion2";
No rows affected (0.049 seconds)
149/268      # DATA LOADING FOR t13
150/268      INSERT INTO t13 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (2,TRUE,0,0,0,0,'string_2','string_2',0,2,'05:46:42'),(3,FALSE,-1,-1,-1,-1,'string_3','string_3',-1.1,3,'05:46:43'),(4,TRUE,1,1,1,1,'string_4','string_4',1.1,4,'05:46:44'),(5,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_5','string_5',5,5,'05:46:45'),(-6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_7','string_7',7,7,'05:46:47'),(8,TRUE,126,32766,2147483646,9223372036854775806,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,9,9,9,9,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.008 seconds)
151/268      SELECT * FROM t13 WHERE id=13 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.027 seconds)
152/268      MERGE INTO t13 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(13, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.002 seconds)
153/268      MERGE INTO t13 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.002 seconds)
154/268      SELECT * FROM t13 WHERE id=13 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'13','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.021 seconds)
155/268      DROP TABLE t13;
No rows affected (0.011 seconds)
156/268      # END BLOCK t13
157/268      # START BLOCK t14
158/268      CREATE TABLE t14 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, ATOMICITY=ATOMIC, DATA_REGION=dataRegion2";
No rows affected (0.039 seconds)
159/268      # DATA LOADING FOR t14
160/268      INSERT INTO t14 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (2,TRUE,0,0,0,0,'string_2','string_2',0,2,'05:46:42'),(3,FALSE,-1,-1,-1,-1,'string_3','string_3',-1.1,3,'05:46:43'),(4,TRUE,1,1,1,1,'string_4','string_4',1.1,4,'05:46:44'),(5,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_5','string_5',5,5,'05:46:45'),(-6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_7','string_7',7,7,'05:46:47'),(8,TRUE,126,32766,2147483646,9223372036854775806,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,9,9,9,9,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.008 seconds)
161/268      SELECT * FROM t14 WHERE id=14 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.025 seconds)
162/268      MERGE INTO t14 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(14, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.002 seconds)
163/268      MERGE INTO t14 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.002 seconds)
164/268      SELECT * FROM t14 WHERE id=14 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'14','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.026 seconds)
165/268      DROP TABLE t14;
No rows affected (0.009 seconds)
166/268      # END BLOCK t14
167/268      # START BLOCK t15
168/268      CREATE TABLE t15 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, ATOMICITY=TRANSACTIONAL, DATA_REGION=dataRegion2";
No rows affected (0.043 seconds)
169/268      # DATA LOADING FOR t15
170/268      INSERT INTO t15 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (2,TRUE,0,0,0,0,'string_2','string_2',0,2,'05:46:42'),(3,FALSE,-1,-1,-1,-1,'string_3','string_3',-1.1,3,'05:46:43'),(4,TRUE,1,1,1,1,'string_4','string_4',1.1,4,'05:46:44'),(5,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_5','string_5',5,5,'05:46:45'),(-6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_7','string_7',7,7,'05:46:47'),(8,TRUE,126,32766,2147483646,9223372036854775806,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,9,9,9,9,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.013 seconds)
171/268      SELECT * FROM t15 WHERE id=15 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.022 seconds)
172/268      MERGE INTO t15 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(15, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.003 seconds)
173/268      MERGE INTO t15 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.003 seconds)
174/268      SELECT * FROM t15 WHERE id=15 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'15','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.024 seconds)
175/268      DROP TABLE t15;
No rows affected (0.01 seconds)
176/268      # END BLOCK t15
177/268      # START BLOCK t16
178/268      CREATE TABLE t16 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, WRITE_SYNCHRONIZATION_MODE=FULL_SYNC, DATA_REGION=dataRegion2";
No rows affected (0.044 seconds)
179/268      # DATA LOADING FOR t16
180/268      INSERT INTO t16 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (2,TRUE,0,0,0,0,'string_2','string_2',0,2,'05:46:42'),(3,FALSE,-1,-1,-1,-1,'string_3','string_3',-1.1,3,'05:46:43'),(4,TRUE,1,1,1,1,'string_4','string_4',1.1,4,'05:46:44'),(5,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_5','string_5',5,5,'05:46:45'),(-6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_7','string_7',7,7,'05:46:47'),(8,TRUE,126,32766,2147483646,9223372036854775806,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,9,9,9,9,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.006 seconds)
181/268      SELECT * FROM t16 WHERE id=16 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.018 seconds)
182/268      MERGE INTO t16 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(16, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.001 seconds)
183/268      MERGE INTO t16 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.001 seconds)
184/268      SELECT * FROM t16 WHERE id=16 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'16','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.019 seconds)
185/268      DROP TABLE t16;
No rows affected (0.008 seconds)
186/268      # END BLOCK t16
187/268      # START BLOCK t17
188/268      CREATE TABLE t17 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, BACKUPS=4, DATA_REGION=dataRegion3";
No rows affected (0.036 seconds)
189/268      # DATA LOADING FOR t17
190/268      INSERT INTO t17 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (2,TRUE,0,0,0,0,'string_2','string_2',0,2,'05:46:42'),(3,FALSE,-1,-1,-1,-1,'string_3','string_3',-1.1,3,'05:46:43'),(4,TRUE,1,1,1,1,'string_4','string_4',1.1,4,'05:46:44'),(5,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_5','string_5',5,5,'05:46:45'),(-6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_7','string_7',7,7,'05:46:47'),(8,TRUE,126,32766,2147483646,9223372036854775806,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,9,9,9,9,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.005 seconds)
191/268      SELECT * FROM t17 WHERE id=17 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.02 seconds)
192/268      MERGE INTO t17 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(17, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.001 seconds)
193/268      MERGE INTO t17 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.001 seconds)
194/268      SELECT * FROM t17 WHERE id=17 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'17','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.018 seconds)
195/268      DROP TABLE t17;
No rows affected (0.007 seconds)
196/268      # END BLOCK t17
197/268      # START BLOCK t18
198/268      CREATE TABLE t18 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, ATOMICITY=ATOMIC, DATA_REGION=dataRegion3";
No rows affected (0.046 seconds)
199/268      # DATA LOADING FOR t18
200/268      INSERT INTO t18 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (2,TRUE,0,0,0,0,'string_2','string_2',0,2,'05:46:42'),(3,FALSE,-1,-1,-1,-1,'string_3','string_3',-1.1,3,'05:46:43'),(4,TRUE,1,1,1,1,'string_4','string_4',1.1,4,'05:46:44'),(5,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_5','string_5',5,5,'05:46:45'),(-6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_7','string_7',7,7,'05:46:47'),(8,TRUE,126,32766,2147483646,9223372036854775806,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,9,9,9,9,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.006 seconds)
201/268      SELECT * FROM t18 WHERE id=18 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.019 seconds)
202/268      MERGE INTO t18 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(18, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.002 seconds)
203/268      MERGE INTO t18 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.001 seconds)
204/268      SELECT * FROM t18 WHERE id=18 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'18','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.02 seconds)
205/268      DROP TABLE t18;
No rows affected (0.008 seconds)
206/268      # END BLOCK t18
207/268      # START BLOCK t19
208/268      CREATE TABLE t19 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, ATOMICITY=TRANSACTIONAL, DATA_REGION=dataRegion3";
No rows affected (0.032 seconds)
209/268      # DATA LOADING FOR t19
210/268      INSERT INTO t19 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (2,TRUE,0,0,0,0,'string_2','string_2',0,2,'05:46:42'),(3,FALSE,-1,-1,-1,-1,'string_3','string_3',-1.1,3,'05:46:43'),(4,TRUE,1,1,1,1,'string_4','string_4',1.1,4,'05:46:44'),(5,FALSE,-128,-32768,-2147483648,-9223372036854775808,'string_5','string_5',5,5,'05:46:45'),(-6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,FALSE,-127,-32767,-2147483647,-9223372036854775807,'string_7','string_7',7,7,'05:46:47'),(8,TRUE,126,32766,2147483646,9223372036854775806,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,9,9,9,9,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.012 seconds)
211/268      SELECT * FROM t19 WHERE id=19 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.024 seconds)
212/268      MERGE INTO t19 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(19, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.002 seconds)
213/268      MERGE INTO t19 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.002 seconds)
214/268      SELECT * FROM t19 WHERE id=19 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'19','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.017 seconds)
215/268      DROP TABLE t19;
No rows affected (0.008 seconds)
216/268      # END BLOCK t19
217/268      # START BLOCK t20
218/268      CREATE TABLE t20 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, WRITE_SYNCHRONIZATION_MODE=FULL_SYNC, DATA_REGION=dataRegion3";
No rows affected (0.032 seconds)
219/268      # DATA LOADING FOR t20
220/268      INSERT INTO t20 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (3,FALSE,0,0,0,0,'string_3','string_3',0,3,'05:46:43'),(4,TRUE,-1,-1,-1,-1,'string_4','string_4',-1.1,4,'05:46:44'),(5,FALSE,1,1,1,1,'string_5','string_5',1.1,5,'05:46:45'),(-6,TRUE,-128,-32768,-2147483648,-9223372036854775808,'string_6','string_6',-6,6,'05:46:46'),(7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,TRUE,-127,-32767,-2147483647,-9223372036854775807,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,126,32766,2147483646,9223372036854775806,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,FALSE,-11,-11,-11,-11,'string_11','string_11',-11,11,'05:46:51'),(12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.005 seconds)
221/268      SELECT * FROM t20 WHERE id=20 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.018 seconds)
222/268      MERGE INTO t20 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(20, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.001 seconds)
223/268      MERGE INTO t20 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.001 seconds)
224/268      SELECT * FROM t20 WHERE id=20 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'20','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.017 seconds)
225/268      DROP TABLE t20;
No rows affected (0.007 seconds)
226/268      # END BLOCK t20
227/268      # START BLOCK t21
228/268      CREATE TABLE t21 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, BACKUPS=4, CACHE_NAME='custom_name_181'";
No rows affected (0.032 seconds)
229/268      # DATA LOADING FOR t21
230/268      INSERT INTO t21 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (3,FALSE,0,0,0,0,'string_3','string_3',0,3,'05:46:43'),(4,TRUE,-1,-1,-1,-1,'string_4','string_4',-1.1,4,'05:46:44'),(5,FALSE,1,1,1,1,'string_5','string_5',1.1,5,'05:46:45'),(-6,TRUE,-128,-32768,-2147483648,-9223372036854775808,'string_6','string_6',-6,6,'05:46:46'),(7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,TRUE,-127,-32767,-2147483647,-9223372036854775807,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,126,32766,2147483646,9223372036854775806,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,FALSE,-11,-11,-11,-11,'string_11','string_11',-11,11,'05:46:51'),(12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.006 seconds)
231/268      SELECT * FROM t21 WHERE id=21 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.016 seconds)
232/268      MERGE INTO t21 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(21, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.002 seconds)
233/268      MERGE INTO t21 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.001 seconds)
234/268      SELECT * FROM t21 WHERE id=21 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'21','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.015 seconds)
235/268      DROP TABLE t21;
No rows affected (0.007 seconds)
236/268      # END BLOCK t21
237/268      # START BLOCK t22
238/268      CREATE TABLE t22 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, ATOMICITY=ATOMIC, CACHE_NAME='custom_name_190'";
No rows affected (0.038 seconds)
239/268      # DATA LOADING FOR t22
240/268      INSERT INTO t22 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (3,FALSE,0,0,0,0,'string_3','string_3',0,3,'05:46:43'),(4,TRUE,-1,-1,-1,-1,'string_4','string_4',-1.1,4,'05:46:44'),(5,FALSE,1,1,1,1,'string_5','string_5',1.1,5,'05:46:45'),(-6,TRUE,-128,-32768,-2147483648,-9223372036854775808,'string_6','string_6',-6,6,'05:46:46'),(7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,TRUE,-127,-32767,-2147483647,-9223372036854775807,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,126,32766,2147483646,9223372036854775806,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,FALSE,-11,-11,-11,-11,'string_11','string_11',-11,11,'05:46:51'),(12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.006 seconds)
241/268      SELECT * FROM t22 WHERE id=22 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.016 seconds)
242/268      MERGE INTO t22 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(22, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.002 seconds)
243/268      MERGE INTO t22 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.002 seconds)
244/268      SELECT * FROM t22 WHERE id=22 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'22','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.02 seconds)
245/268      DROP TABLE t22;
No rows affected (0.007 seconds)
246/268      # END BLOCK t22
247/268      # START BLOCK t23
248/268      CREATE TABLE t23 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, ATOMICITY=TRANSACTIONAL, CACHE_NAME='custom_name_199'";
No rows affected (0.031 seconds)
249/268      # DATA LOADING FOR t23
250/268      INSERT INTO t23 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (3,FALSE,0,0,0,0,'string_3','string_3',0,3,'05:46:43'),(4,TRUE,-1,-1,-1,-1,'string_4','string_4',-1.1,4,'05:46:44'),(5,FALSE,1,1,1,1,'string_5','string_5',1.1,5,'05:46:45'),(-6,TRUE,-128,-32768,-2147483648,-9223372036854775808,'string_6','string_6',-6,6,'05:46:46'),(7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,TRUE,-127,-32767,-2147483647,-9223372036854775807,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,126,32766,2147483646,9223372036854775806,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,FALSE,-11,-11,-11,-11,'string_11','string_11',-11,11,'05:46:51'),(12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.01 seconds)
251/268      SELECT * FROM t23 WHERE id=23 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.018 seconds)
252/268      MERGE INTO t23 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(23, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.003 seconds)
253/268      MERGE INTO t23 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.001 seconds)
254/268      SELECT * FROM t23 WHERE id=23 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'23','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.018 seconds)
255/268      DROP TABLE t23;
No rows affected (0.007 seconds)
256/268      # END BLOCK t23
257/268      # START BLOCK t24
258/268      CREATE TABLE t24 ( id INT NOT NULL, bool_col BOOLEAN, tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, varchar_col VARCHAR, char_col CHAR, float_col FLOAT, double_col DOUBLE, time_col TIME, PRIMARY KEY (id)
) WITH "TEMPLATE=partitioned, WRITE_SYNCHRONIZATION_MODE=FULL_SYNC, CACHE_NAME='custom_name_208'";
No rows affected (0.03 seconds)
259/268      # DATA LOADING FOR t24
260/268      INSERT INTO t24 (id,bool_col,tinyint_col,smallint_col,int_col,bigint_col,varchar_col,char_col,float_col,double_col,time_col) VALUES (3,FALSE,0,0,0,0,'string_3','string_3',0,3,'05:46:43'),(4,TRUE,-1,-1,-1,-1,'string_4','string_4',-1.1,4,'05:46:44'),(5,FALSE,1,1,1,1,'string_5','string_5',1.1,5,'05:46:45'),(-6,TRUE,-128,-32768,-2147483648,-9223372036854775808,'string_6','string_6',-6,6,'05:46:46'),(7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,TRUE,-127,-32767,-2147483647,-9223372036854775807,'string_8','string_8',8,8,'05:46:48'),(9,FALSE,126,32766,2147483646,9223372036854775806,'string_9','string_9',9,9,'05:46:49'),(10,TRUE,10,10,10,10,'string_10','string_10',10,10,'05:46:50'),(-11,FALSE,-11,-11,-11,-11,'string_11','string_11',-11,11,'05:46:51'),(12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
10 rows affected (0.005 seconds)
261/268      SELECT * FROM t24 WHERE id=24 OR id=10001;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
No rows selected (0.019 seconds)
262/268      MERGE INTO t24 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(24, TRUE, 2, 2, 2, 2, '2', '2', 2.2, 2.2, '02:02:02');
1 row affected (0.001 seconds)
263/268      MERGE INTO t24 (id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, varchar_col, char_col, float_col, double_col, time_col
) VALUES(10001, TRUE, 3, 3, 3, 3, '3', '3', 3.3, 3.3, '03:03:03');
1 row affected (0.002 seconds)
264/268      SELECT * FROM t24 WHERE id=24 OR id=10001 ORDER BY id;
'ID','BOOL_COL','TINYINT_COL','SMALLINT_COL','INT_COL','BIGINT_COL','VARCHAR_COL','CHAR_COL','FLOAT_COL','DOUBLE_COL','TIME_COL'
'24','true','2','2','2','2','2','2','2.2','2.2','02:02:02'
'10001','true','3','3','3','3','3','3','3.3','3.3','03:03:03'
2 rows selected (0.019 seconds)
265/268      DROP TABLE t24;
No rows affected (0.008 seconds)
266/268      # END BLOCK t24
267/268      !record
Recording stopped.
268/268      !q
Closing: org.apache.ignite.internal.jdbc.thin.JdbcThinConnection