Ritik Raj created ASTERIXDB-3499:
------------------------------------
Summary: Missing updation of filters for Boolean columns while
merging
Key: ASTERIXDB-3499
URL: https://issues.apache.org/jira/browse/ASTERIXDB-3499
Project: Apache AsterixDB
Issue Type: Bug
Components: STO - Storage
Affects Versions: 0.9.9
Reporter: Ritik Raj
Fix For: 0.9.10
While merging/compaction the filters of the boolean columns were not getting
updated causing the rangeFilter to skip whole mega page, hence giving empty
results.
Sample case:
{code:java}
CREATE collection sample_collection PRIMARY KEY (primary_key_id: string)
WITH {
"storage-format": {
"format": "column"
}
};{code}
{code:java}
insert into sample_collection ([{'primary_key_id': '1', 'int_field1': 69114320,
'decimal_field1': 9610, 'datetime_field1': '2005-11-08 00:00:00',
'bool_field1': False, 'varchar_field1': 'BPBlasoTZq', 'char_field1': 'C'},
{'primary_key_id': '10', 'int_field1': 91192377, 'decimal_field1': 5216,
'datetime_field1': '2014-08-19 00:00:00', 'bool_field1': False,
'varchar_field1': 'JdhrIvAAnK', 'char_field1': 'T'}, {'primary_key_id': '100',
'int_field1': 68552596, 'decimal_field1': 6414, 'datetime_field1': '2009-01-09
00:00:00', 'bool_field1': False, 'varchar_field1': 'xBmJMePkHm', 'char_field1':
'W'}, {'primary_key_id': '1000', 'int_field1': 92970191, 'decimal_field1':
7864, 'datetime_field1': '2006-12-15 00:00:00', 'bool_field1': False,
'varchar_field1': 'TmRayzVdVM', 'char_field1': 'G'}, {'primary_key_id': '101',
'int_field1': 56965560, 'decimal_field1': 9071, 'datetime_field1': '2012-12-28
00:00:00', 'bool_field1': False, 'varchar_field1': 'VCGkPaEigi', 'char_field1':
'Y'}, {'primary_key_id': '102', 'int_field1': 97370171, 'decimal_field1': 8897,
'datetime_field1': '2000-05-04 00:00:00', 'bool_field1': True,
'varchar_field1': 'xZbGskVAzM', 'char_field1': 'E'}, {'primary_key_id': '103',
'int_field1': 20631727, 'decimal_field1': 1492, 'datetime_field1': '2001-10-09
00:00:00', 'bool_field1': True, 'varchar_field1': 'UHXQuHyrgi', 'char_field1':
'F'}, {'primary_key_id': '104', 'int_field1': 43232483, 'decimal_field1': 6308,
'datetime_field1': '2005-10-21 00:00:00', 'bool_field1': False,
'varchar_field1': 'yzUJxpHKoH', 'char_field1': 'A'}, {'primary_key_id': '105',
'int_field1': 19656910, 'decimal_field1': 322, 'datetime_field1': '2012-03-05
00:00:00', 'bool_field1': False, 'varchar_field1': 'EqvpbMXCWo', 'char_field1':
'J'}, {'primary_key_id': '106', 'int_field1': 79855425, 'decimal_field1': 5907,
'datetime_field1': '2006-08-19 00:00:00', 'bool_field1': True,
'varchar_field1': 'lKsbhVYFLw', 'char_field1': 'X'}, {'primary_key_id': '107',
'int_field1': 36029901, 'decimal_field1': 3478, 'datetime_field1': '2004-02-13
00:00:00', 'bool_field1': True, 'varchar_field1': 'dSAjRdXhbN', 'char_field1':
'H'}, {'primary_key_id': '108', 'int_field1': 46527972, 'decimal_field1': 4174,
'datetime_field1': '2009-03-19 00:00:00', 'bool_field1': True,
'varchar_field1': 'LozzDUsdMJ', 'char_field1': 'O'}, {'primary_key_id': '109',
'int_field1': 80651305, 'decimal_field1': 2818, 'datetime_field1': '2005-07-08
00:00:00', 'bool_field1': False, 'varchar_field1': 'uFchCQzWGe', 'char_field1':
'H'}, {'primary_key_id': '11', 'int_field1': 4211607, 'decimal_field1': 9140,
'datetime_field1': '2013-04-12 00:00:00', 'bool_field1': False,
'varchar_field1': 'rxUxRJcVPl', 'char_field1': 'M'}, {'primary_key_id': '110',
'int_field1': 56651305, 'decimal_field1': 8227, 'datetime_field1': '2007-03-26
00:00:00', 'bool_field1': True, 'varchar_field1': 'RbceZJKBwo', 'char_field1':
'B'}, {'primary_key_id': '111', 'int_field1': 56833222, 'decimal_field1': 5766,
'datetime_field1': '2012-09-08 00:00:00', 'bool_field1': True,
'varchar_field1': 'gUxvycSKSB', 'char_field1': 'Z'}, {'primary_key_id': '112',
'int_field1': 53672159, 'decimal_field1': 4676, 'datetime_field1': '2007-11-02
00:00:00', 'bool_field1': True, 'varchar_field1': 'JBSElMzpnr', 'char_field1':
'X'}, {'primary_key_id': '113', 'int_field1': 57632266, 'decimal_field1': 3878,
'datetime_field1': '2014-12-23 00:00:00', 'bool_field1': False,
'varchar_field1': 'rItDMtXKey', 'char_field1': 'N'}, {'primary_key_id': '114',
'int_field1': 72682342, 'decimal_field1': 5057, 'datetime_field1': '2002-05-22
00:00:00', 'bool_field1': False, 'varchar_field1': 'YLrzUXnbZu', 'char_field1':
'A'}, {'primary_key_id': '115', 'int_field1': 38560730, 'decimal_field1': 7387,
'datetime_field1': '2004-01-07 00:00:00', 'bool_field1': False,
'varchar_field1': 'DOQgiOufOx', 'char_field1': 'O'}, {'primary_key_id': '116',
'int_field1': 92065667, 'decimal_field1': 677, 'datetime_field1': '2013-04-21
00:00:00', 'bool_field1': False, 'varchar_field1': 'ZtiroBQGuY', 'char_field1':
'L'}, {'primary_key_id': '117', 'int_field1': 73143775, 'decimal_field1': 4562,
'datetime_field1': '2002-07-22 00:00:00', 'bool_field1': False,
'varchar_field1': 'TJdowLFmVa', 'char_field1': 'V'}, {'primary_key_id': '118',
'int_field1': 62167915, 'decimal_field1': 5917, 'datetime_field1': '2008-06-28
00:00:00', 'bool_field1': True, 'varchar_field1': 'lqYuEMbTeM', 'char_field1':
'W'}, {'primary_key_id': '119', 'int_field1': 81315587, 'decimal_field1': 6232,
'datetime_field1': '2000-06-02 00:00:00', 'bool_field1': True,
'varchar_field1': 'gAeHMBaIza', 'char_field1': 'D'}, {'primary_key_id': '12',
'int_field1': 70709080, 'decimal_field1': 4352, 'datetime_field1': '2011-10-13
00:00:00', 'bool_field1': False, 'varchar_field1': 'VkfcSLqjYO', 'char_field1':
'J'}, {'primary_key_id': '120', 'int_field1': 86995748, 'decimal_field1': 4940,
'datetime_field1': '2004-04-27 00:00:00', 'bool_field1': False,
'varchar_field1': 'gwdYNwBDaG', 'char_field1': 'P'}, {'primary_key_id': '121',
'int_field1': 80786528, 'decimal_field1': 7033, 'datetime_field1': '2014-09-22
00:00:00', 'bool_field1': True, 'varchar_field1': 'xggPCOxVXq', 'char_field1':
'K'}, {'primary_key_id': '122', 'int_field1': 24524866, 'decimal_field1': 597,
'datetime_field1': '2013-01-15 00:00:00', 'bool_field1': False,
'varchar_field1': 'dcLABdDruR', 'char_field1': 'F'}, {'primary_key_id': '123',
'int_field1': 14444825, 'decimal_field1': 3271, 'datetime_field1': '2001-01-03
00:00:00', 'bool_field1': False, 'varchar_field1': 'HbeYpqNDbY', 'char_field1':
'W'}, {'primary_key_id': '124', 'int_field1': 53748411, 'decimal_field1': 9072,
'datetime_field1': '1999-03-21 00:00:00', 'bool_field1': False,
'varchar_field1': 'otyKoYJPYq', 'char_field1': 'V'}, {'primary_key_id': '125',
'int_field1': 92691854, 'decimal_field1': 5206, 'datetime_field1': '2007-10-09
00:00:00', 'bool_field1': False, 'varchar_field1': 'sIFWQrahiC', 'char_field1':
'E'}, {'primary_key_id': '126', 'int_field1': 41662726, 'decimal_field1': 4754,
'datetime_field1': '2001-05-17 00:00:00', 'bool_field1': True,
'varchar_field1': 'dHGouHgBUt', 'char_field1': 'L'}, {'primary_key_id': '127',
'int_field1': 77023283, 'decimal_field1': 995, 'datetime_field1': '2012-09-20
00:00:00', 'bool_field1': False, 'varchar_field1': 'DnDqrIFJxw', 'char_field1':
'P'}, {'primary_key_id': '128', 'int_field1': 45341801, 'decimal_field1': 5677,
'datetime_field1': '2009-03-19 00:00:00', 'bool_field1': False,
'varchar_field1': 'mGZxNjTlSr', 'char_field1': 'X'}, {'primary_key_id': '129',
'int_field1': 55150209, 'decimal_field1': 7646, 'datetime_field1': '2009-06-22
00:00:00', 'bool_field1': True, 'varchar_field1': 'VhPDjImWtf', 'char_field1':
'H'}, {'primary_key_id': '13', 'int_field1': 81301722, 'decimal_field1': 721,
'datetime_field1': '2011-04-24 00:00:00', 'bool_field1': False,
'varchar_field1': 'HxAHxdBGpv', 'char_field1': 'Q'}, {'primary_key_id': '130',
'int_field1': 29478826, 'decimal_field1': 8437, 'datetime_field1': '2000-03-15
00:00:00', 'bool_field1': True, 'varchar_field1': 'knLADwlJWp', 'char_field1':
'I'}, {'primary_key_id': '131', 'int_field1': 44881292, 'decimal_field1': 8978,
'datetime_field1': '2006-08-23 00:00:00', 'bool_field1': False,
'varchar_field1': 'uaVRvRQkCn', 'char_field1': 'A'}, {'primary_key_id': '132',
'int_field1': 27255027, 'decimal_field1': 1946, 'datetime_field1': '2010-09-27
00:00:00', 'bool_field1': False, 'varchar_field1': 'xMBwQHAcaq', 'char_field1':
'P'}, {'primary_key_id': '133', 'int_field1': 28935409, 'decimal_field1': 9154,
'datetime_field1': '2011-06-01 00:00:00', 'bool_field1': False,
'varchar_field1': 'HwvoGAbgRW', 'char_field1': 'W'}, {'primary_key_id': '134',
'int_field1': 56421286, 'decimal_field1': 7969, 'datetime_field1': '2009-11-12
00:00:00', 'bool_field1': False, 'varchar_field1': 'JQfWZRsskz', 'char_field1':
'K'}, {'primary_key_id': '135', 'int_field1': 74579756, 'decimal_field1': 7642,
'datetime_field1': '2014-09-22 00:00:00', 'bool_field1': False,
'varchar_field1': 'WXCmbRsJxy', 'char_field1': 'R'}, {'primary_key_id': '136',
'int_field1': 36494432, 'decimal_field1': 6570, 'datetime_field1': '2005-06-11
00:00:00', 'bool_field1': True, 'varchar_field1': 'wTMIzJEzhl', 'char_field1':
'N'}, {'primary_key_id': '137', 'int_field1': 3577314, 'decimal_field1': 5423,
'datetime_field1': '2009-04-22 00:00:00', 'bool_field1': True,
'varchar_field1': 'vFcKJpPrSw', 'char_field1': 'Z'}, {'primary_key_id': '138',
'int_field1': 30866287, 'decimal_field1': 1646, 'datetime_field1': '2006-11-16
00:00:00', 'bool_field1': False, 'varchar_field1': 'IKaaUmagJG', 'char_field1':
'S'}, {'primary_key_id': '139', 'int_field1': 71223312, 'decimal_field1': 954,
'datetime_field1': '2003-09-09 00:00:00', 'bool_field1': True,
'varchar_field1': 'xLAlfYhjEE', 'char_field1': 'U'}, {'primary_key_id': '14',
'int_field1': 9749149, 'decimal_field1': 2510, 'datetime_field1': '2011-11-21
00:00:00', 'bool_field1': False, 'varchar_field1': 'gwrtZJaOEJ', 'char_field1':
'T'}, {'primary_key_id': '140', 'int_field1': 42435671, 'decimal_field1': 8365,
'datetime_field1': '2009-10-20 00:00:00', 'bool_field1': True,
'varchar_field1': 'GVxTAusnmA', 'char_field1': 'A'}, {'primary_key_id': '141',
'int_field1': 74226873, 'decimal_field1': 1343, 'datetime_field1': '2004-01-21
00:00:00', 'bool_field1': True, 'varchar_field1': 'jqRwJDYTbg', 'char_field1':
'F'}, {'primary_key_id': '142', 'int_field1': 71787244, 'decimal_field1': 4561,
'datetime_field1': '2012-02-26 00:00:00', 'bool_field1': False,
'varchar_field1': 'BpwrZCIxQl', 'char_field1': 'P'}, {'primary_key_id': '143',
'int_field1': 57332808, 'decimal_field1': 6128, 'datetime_field1': '2007-08-05
00:00:00', 'bool_field1': True, 'varchar_field1': 'ssDMtVdzCD', 'char_field1':
'E'}, {'primary_key_id': '144', 'int_field1': 65965971, 'decimal_field1': 4635,
'datetime_field1': '1999-11-18 00:00:00', 'bool_field1': False,
'varchar_field1': 'qwHlvZvOHD', 'char_field1': 'B'}, {'primary_key_id': '145',
'int_field1': 574924, 'decimal_field1': 8456, 'datetime_field1': '2009-02-07
00:00:00', 'bool_field1': True, 'varchar_field1': 'UBDtgWeZmb', 'char_field1':
'X'}, {'primary_key_id': '146', 'int_field1': 53018413, 'decimal_field1': 6590,
'datetime_field1': '2000-07-13 00:00:00', 'bool_field1': True,
'varchar_field1': 'uDgObRjdLZ', 'char_field1': 'N'}, {'primary_key_id': '147',
'int_field1': 86225036, 'decimal_field1': 6409, 'datetime_field1': '2008-12-25
00:00:00', 'bool_field1': True, 'varchar_field1': 'dpvyNCYAsG', 'char_field1':
'K'}, {'primary_key_id': '148', 'int_field1': 52616627, 'decimal_field1': 7373,
'datetime_field1': '2011-10-01 00:00:00', 'bool_field1': False,
'varchar_field1': 'icUvVixWZX', 'char_field1': 'W'}, {'primary_key_id': '149',
'int_field1': 80169731, 'decimal_field1': 9954, 'datetime_field1': '2007-07-03
00:00:00', 'bool_field1': True, 'varchar_field1': 'ZwVBpXTxih', 'char_field1':
'H'}, {'primary_key_id': '15', 'int_field1': 47646740, 'decimal_field1': 1017,
'datetime_field1': '2002-03-02 00:00:00', 'bool_field1': False,
'varchar_field1': 'oNKSAvrhXo', 'char_field1': 'S'}, {'primary_key_id': '150',
'int_field1': 31112968, 'decimal_field1': 7467, 'datetime_field1': '2013-02-02
00:00:00', 'bool_field1': False, 'varchar_field1': 'CKVzmURovd', 'char_field1':
'M'}, {'primary_key_id': '151', 'int_field1': 12498371, 'decimal_field1': 6473,
'datetime_field1': '2007-06-13 00:00:00', 'bool_field1': True,
'varchar_field1': 'sHmapRNWrQ', 'char_field1': 'Y'}, {'primary_key_id': '152',
'int_field1': 67190924, 'decimal_field1': 6231, 'datetime_field1': '2007-06-01
00:00:00', 'bool_field1': False, 'varchar_field1': 'JQqcdbmOGH', 'char_field1':
'O'}, {'primary_key_id': '153', 'int_field1': 22303139, 'decimal_field1': 4898,
'datetime_field1': '1999-04-03 00:00:00', 'bool_field1': False,
'varchar_field1': 'WTQlzJOxay', 'char_field1': 'S'}, {'primary_key_id': '154',
'int_field1': 79242112, 'decimal_field1': 4365, 'datetime_field1': '2006-06-22
00:00:00', 'bool_field1': False, 'varchar_field1': 'OCekxnCQdV', 'char_field1':
'N'}, {'primary_key_id': '155', 'int_field1': 33439874, 'decimal_field1': 3360,
'datetime_field1': '2004-08-06 00:00:00', 'bool_field1': False,
'varchar_field1': 'YXDRMitxat', 'char_field1': 'D'}, {'primary_key_id': '156',
'int_field1': 55104099, 'decimal_field1': 2631, 'datetime_field1': '2005-08-23
00:00:00', 'bool_field1': True, 'varchar_field1': 'NkhKLuxIJn', 'char_field1':
'K'}, {'primary_key_id': '157', 'int_field1': 28681915, 'decimal_field1': 8221,
'datetime_field1': '2014-08-17 00:00:00', 'bool_field1': True,
'varchar_field1': 'WkyXvNSmjX', 'char_field1': 'T'}, {'primary_key_id': '158',
'int_field1': 25835084, 'decimal_field1': 9364, 'datetime_field1': '2010-03-02
00:00:00', 'bool_field1': False, 'varchar_field1': 'SPtEqcXfSe', 'char_field1':
'G'}, {'primary_key_id': '159', 'int_field1': 66335945, 'decimal_field1': 8637,
'datetime_field1': '2001-02-15 00:00:00', 'bool_field1': True,
'varchar_field1': 'WTnxKdtRBu', 'char_field1': 'V'}, {'primary_key_id': '16',
'int_field1': 29610499, 'decimal_field1': 2257, 'datetime_field1': '2001-10-14
00:00:00', 'bool_field1': False, 'varchar_field1': 'mhQnZxDKPc', 'char_field1':
'K'}, {'primary_key_id': '160', 'int_field1': 45898926, 'decimal_field1': 7195,
'datetime_field1': '2000-07-05 00:00:00', 'bool_field1': True,
'varchar_field1': 'cvNfdOMsDN', 'char_field1': 'S'}, {'primary_key_id': '161',
'int_field1': 93253044, 'decimal_field1': 9255, 'datetime_field1': '2009-10-06
00:00:00', 'bool_field1': False, 'varchar_field1': 'InubVGAjaI', 'char_field1':
'M'}, {'primary_key_id': '162', 'int_field1': 52684867, 'decimal_field1': 6058,
'datetime_field1': '2010-09-04 00:00:00', 'bool_field1': False,
'varchar_field1': 'ehVKImmpGM', 'char_field1': 'D'}, {'primary_key_id': '163',
'int_field1': 31216293, 'decimal_field1': 9229, 'datetime_field1': '2003-02-18
00:00:00', 'bool_field1': False, 'varchar_field1': 'MAIowIsgoT', 'char_field1':
'W'}, {'primary_key_id': '164', 'int_field1': 51503802, 'decimal_field1': 8043,
'datetime_field1': '2010-06-22 00:00:00', 'bool_field1': False,
'varchar_field1': 'QorcULRaUd', 'char_field1': 'S'}, {'primary_key_id': '165',
'int_field1': 21214183, 'decimal_field1': 5539, 'datetime_field1': '2008-04-17
00:00:00', 'bool_field1': True, 'varchar_field1': 'btMByVVEhl', 'char_field1':
'A'}, {'primary_key_id': '166', 'int_field1': 64328432, 'decimal_field1': 4883,
'datetime_field1': '2007-07-17 00:00:00', 'bool_field1': False,
'varchar_field1': 'uQJBkoDcWj', 'char_field1': 'G'}, {'primary_key_id': '167',
'int_field1': 77828216, 'decimal_field1': 7779, 'datetime_field1': '2014-11-07
00:00:00', 'bool_field1': False, 'varchar_field1': 'yZfFAxIPvi', 'char_field1':
'V'}, {'primary_key_id': '168', 'int_field1': 41324887, 'decimal_field1': 5869,
'datetime_field1': '2001-03-10 00:00:00', 'bool_field1': True,
'varchar_field1': 'BmzytHlMPR', 'char_field1': 'P'}, {'primary_key_id': '169',
'int_field1': 69920345, 'decimal_field1': 4177, 'datetime_field1': '2010-07-12
00:00:00', 'bool_field1': True, 'varchar_field1': 'PaLBcwmnUW', 'char_field1':
'W'}, {'primary_key_id': '17', 'int_field1': 29719352, 'decimal_field1': 7351,
'datetime_field1': '2011-10-26 00:00:00', 'bool_field1': False,
'varchar_field1': 'TZAixgIAwl', 'char_field1': 'J'}, {'primary_key_id': '170',
'int_field1': 47340222, 'decimal_field1': 9613, 'datetime_field1': '2000-01-08
00:00:00', 'bool_field1': False, 'varchar_field1': 'kNEnqmFVBl', 'char_field1':
'X'}, {'primary_key_id': '171', 'int_field1': 56334354, 'decimal_field1': 7081,
'datetime_field1': '2008-06-24 00:00:00', 'bool_field1': False,
'varchar_field1': 'VczDBjrRTf', 'char_field1': 'H'}, {'primary_key_id': '172',
'int_field1': 28287293, 'decimal_field1': 3971, 'datetime_field1': '2014-02-15
00:00:00', 'bool_field1': False, 'varchar_field1': 'GaxCyuIVbH', 'char_field1':
'Z'}, {'primary_key_id': '173', 'int_field1': 21786271, 'decimal_field1': 4386,
'datetime_field1': '2006-12-24 00:00:00', 'bool_field1': True,
'varchar_field1': 'TFbZvIgnwX', 'char_field1': 'G'}, {'primary_key_id': '174',
'int_field1': 30810793, 'decimal_field1': 3960, 'datetime_field1': '2006-06-05
00:00:00', 'bool_field1': True, 'varchar_field1': 'vASmWVjfHd', 'char_field1':
'E'}, {'primary_key_id': '175', 'int_field1': 72399364, 'decimal_field1': 1918,
'datetime_field1': '2013-01-15 00:00:00', 'bool_field1': False,
'varchar_field1': 'qALilFnWGy', 'char_field1': 'K'}, {'primary_key_id': '176',
'int_field1': 7268079, 'decimal_field1': 9406, 'datetime_field1': '1999-01-22
00:00:00', 'bool_field1': True, 'varchar_field1': 'pQQnIueBTl', 'char_field1':
'T'}, {'primary_key_id': '177', 'int_field1': 42893358, 'decimal_field1': 6450,
'datetime_field1': '1999-06-26 00:00:00', 'bool_field1': False,
'varchar_field1': 'vaCFMWdVlh', 'char_field1': 'K'}, {'primary_key_id': '178',
'int_field1': 42886397, 'decimal_field1': 8549, 'datetime_field1': '2003-12-04
00:00:00', 'bool_field1': True, 'varchar_field1': 'KueEKKhedO', 'char_field1':
'P'}, {'primary_key_id': '179', 'int_field1': 41515130, 'decimal_field1': 4165,
'datetime_field1': '2014-01-07 00:00:00', 'bool_field1': False,
'varchar_field1': 'SOChnjAbVn', 'char_field1': 'Q'}, {'primary_key_id': '18',
'int_field1': 46873680, 'decimal_field1': 4761, 'datetime_field1': '2010-09-28
00:00:00', 'bool_field1': True, 'varchar_field1': 'qUCHSamVbl', 'char_field1':
'U'}, {'primary_key_id': '180', 'int_field1': 98939585, 'decimal_field1': 5087,
'datetime_field1': '2004-06-03 00:00:00', 'bool_field1': False,
'varchar_field1': 'RntCPJdvdL', 'char_field1': 'U'}, {'primary_key_id': '181',
'int_field1': 5426583, 'decimal_field1': 795, 'datetime_field1': '2000-10-01
00:00:00', 'bool_field1': False, 'varchar_field1': 'VNhkZwrVSo', 'char_field1':
'G'}, {'primary_key_id': '182', 'int_field1': 43263082, 'decimal_field1': 6680,
'datetime_field1': '2009-04-13 00:00:00', 'bool_field1': False,
'varchar_field1': 'JNyUamlIwJ', 'char_field1': 'M'}, {'primary_key_id': '183',
'int_field1': 17492818, 'decimal_field1': 6343, 'datetime_field1': '2011-11-28
00:00:00', 'bool_field1': False, 'varchar_field1': 'RIyPxvZvFx', 'char_field1':
'M'}, {'primary_key_id': '184', 'int_field1': 83547614, 'decimal_field1': 6761,
'datetime_field1': '2011-07-15 00:00:00', 'bool_field1': False,
'varchar_field1': 'kUtNBJroHo', 'char_field1': 'X'}, {'primary_key_id': '185',
'int_field1': 80724211, 'decimal_field1': 9652, 'datetime_field1': '2007-05-15
00:00:00', 'bool_field1': True, 'varchar_field1': 'CoCScxzBcG', 'char_field1':
'S'}, {'primary_key_id': '186', 'int_field1': 49494657, 'decimal_field1': 8265,
'datetime_field1': '2005-01-15 00:00:00', 'bool_field1': False,
'varchar_field1': 'hsyJPQKCfj', 'char_field1': 'I'}, {'primary_key_id': '187',
'int_field1': 92182154, 'decimal_field1': 6225, 'datetime_field1': '2002-03-06
00:00:00', 'bool_field1': False, 'varchar_field1': 'lDNkyPxKdB', 'char_field1':
'B'}, {'primary_key_id': '188', 'int_field1': 75566826, 'decimal_field1': 3350,
'datetime_field1': '2010-08-12 00:00:00', 'bool_field1': False,
'varchar_field1': 'kzRvZQdPAk', 'char_field1': 'K'}]);
{code}
{code:java}
insert into sample_collection ([{'primary_key_id': '189', 'int_field1':
89463144, 'decimal_field1': 3490, 'datetime_field1': '2012-12-19 00:00:00',
'bool_field1': False, 'varchar_field1': 'nfQdaGVYjH', 'char_field1': 'C'},
{'primary_key_id': '19', 'int_field1': 95534617, 'decimal_field1': 6925,
'datetime_field1': '2006-12-08 00:00:00', 'bool_field1': False,
'varchar_field1': 'EIzZrVKcdv', 'char_field1': 'F'}, {'primary_key_id': '190',
'int_field1': 61419091, 'decimal_field1': 6521, 'datetime_field1': '1999-01-16
00:00:00', 'bool_field1': True, 'varchar_field1': 'MgHjEcFtoG', 'char_field1':
'Y'}, {'primary_key_id': '191', 'int_field1': 25738926, 'decimal_field1': 6629,
'datetime_field1': '2002-04-22 00:00:00', 'bool_field1': True,
'varchar_field1': 'yfTtPINwCi', 'char_field1': 'Q'}, {'primary_key_id': '192',
'int_field1': 93456155, 'decimal_field1': 4990, 'datetime_field1': '2010-12-25
00:00:00', 'bool_field1': True, 'varchar_field1': 'DCzrMLacZz', 'char_field1':
'D'}, {'primary_key_id': '193', 'int_field1': 56328999, 'decimal_field1': 6250,
'datetime_field1': '2012-12-27 00:00:00', 'bool_field1': False,
'varchar_field1': 'RNVjHuDrrd', 'char_field1': 'K'}, {'primary_key_id': '194',
'int_field1': 73058201, 'decimal_field1': 8573, 'datetime_field1': '2007-12-17
00:00:00', 'bool_field1': True, 'varchar_field1': 'uINbFqozTG', 'char_field1':
'W'}, {'primary_key_id': '195', 'int_field1': 51301801, 'decimal_field1': 4558,
'datetime_field1': '2004-04-02 00:00:00', 'bool_field1': False,
'varchar_field1': 'jbYXkxEdMA', 'char_field1': 'C'}, {'primary_key_id': '196',
'int_field1': 36896639, 'decimal_field1': 9117, 'datetime_field1': '2006-10-09
00:00:00', 'bool_field1': True, 'varchar_field1': 'cAGjObnVoS', 'char_field1':
'J'}, {'primary_key_id': '197', 'int_field1': 11258314, 'decimal_field1': 1015,
'datetime_field1': '2014-07-22 00:00:00', 'bool_field1': False,
'varchar_field1': 'FaVoBiAqKh', 'char_field1': 'H'}, {'primary_key_id': '198',
'int_field1': 28531473, 'decimal_field1': 5588, 'datetime_field1': '2010-12-20
00:00:00', 'bool_field1': False, 'varchar_field1': 'LxUdMpgGjW', 'char_field1':
'V'}, {'primary_key_id': '199', 'int_field1': 84168892, 'decimal_field1': 9095,
'datetime_field1': '2006-10-21 00:00:00', 'bool_field1': True,
'varchar_field1': 'GPXCzcaGkj', 'char_field1': 'N'}, {'primary_key_id': '2',
'int_field1': 13948560, 'decimal_field1': 7298, 'datetime_field1': '2013-09-26
00:00:00', 'bool_field1': True, 'varchar_field1': 'EIdnYxcFXz', 'char_field1':
'F'}, {'primary_key_id': '20', 'int_field1': 76425576, 'decimal_field1': 351,
'datetime_field1': '2008-02-24 00:00:00', 'bool_field1': True,
'varchar_field1': 'REUdwgBYiu', 'char_field1': 'Y'}, {'primary_key_id': '200',
'int_field1': 14661013, 'decimal_field1': 4651, 'datetime_field1': '2009-01-14
00:00:00', 'bool_field1': True, 'varchar_field1': 'rRklOINzJx', 'char_field1':
'S'}, {'primary_key_id': '201', 'int_field1': 10058150, 'decimal_field1': 6630,
'datetime_field1': '2002-05-08 00:00:00', 'bool_field1': False,
'varchar_field1': 'bCcnOIKshR', 'char_field1': 'H'}, {'primary_key_id': '202',
'int_field1': 92521077, 'decimal_field1': 9294, 'datetime_field1': '1999-08-22
00:00:00', 'bool_field1': True, 'varchar_field1': 'bwtOWjGGOp', 'char_field1':
'T'}, {'primary_key_id': '203', 'int_field1': 7208092, 'decimal_field1': 5403,
'datetime_field1': '1999-08-13 00:00:00', 'bool_field1': False,
'varchar_field1': 'WFpNifpqNK', 'char_field1': 'U'}, {'primary_key_id': '204',
'int_field1': 16927968, 'decimal_field1': 7140, 'datetime_field1': '2006-07-08
00:00:00', 'bool_field1': False, 'varchar_field1': 'TvKCpfIuEd', 'char_field1':
'G'}, {'primary_key_id': '205', 'int_field1': 86540849, 'decimal_field1': 7677,
'datetime_field1': '2003-08-11 00:00:00', 'bool_field1': False,
'varchar_field1': 'axDWAumJPb', 'char_field1': 'E'}, {'primary_key_id': '206',
'int_field1': 29556587, 'decimal_field1': 9149, 'datetime_field1': '2011-06-02
00:00:00', 'bool_field1': False, 'varchar_field1': 'SgDDEwJymd', 'char_field1':
'N'}, {'primary_key_id': '207', 'int_field1': 3622716, 'decimal_field1': 1549,
'datetime_field1': '2006-03-16 00:00:00', 'bool_field1': False,
'varchar_field1': 'dSmQYbFwJs', 'char_field1': 'D'}, {'primary_key_id': '208',
'int_field1': 42052385, 'decimal_field1': 1081, 'datetime_field1': '2003-08-16
00:00:00', 'bool_field1': True, 'varchar_field1': 'oPfSqcVKrJ', 'char_field1':
'N'}, {'primary_key_id': '209', 'int_field1': 18639991, 'decimal_field1': 9699,
'datetime_field1': '2011-04-08 00:00:00', 'bool_field1': True,
'varchar_field1': 'WGuoRfBCaj', 'char_field1': 'Q'}, {'primary_key_id': '21',
'int_field1': 59781131, 'decimal_field1': 4225, 'datetime_field1': '2005-10-16
00:00:00', 'bool_field1': False, 'varchar_field1': 'xqEsJpBwET', 'char_field1':
'Q'}, {'primary_key_id': '210', 'int_field1': 80754824, 'decimal_field1': 7948,
'datetime_field1': '2005-06-16 00:00:00', 'bool_field1': False,
'varchar_field1': 'UjgtWjtOSQ', 'char_field1': 'U'}, {'primary_key_id': '211',
'int_field1': 83409569, 'decimal_field1': 2760, 'datetime_field1': '2000-11-17
00:00:00', 'bool_field1': False, 'varchar_field1': 'xFGcPWaeKx', 'char_field1':
'X'}, {'primary_key_id': '212', 'int_field1': 17558874, 'decimal_field1': 1326,
'datetime_field1': '2008-05-07 00:00:00', 'bool_field1': False,
'varchar_field1': 'wdQJNtGqLj', 'char_field1': 'N'}, {'primary_key_id': '213',
'int_field1': 62466645, 'decimal_field1': 6564, 'datetime_field1': '1999-06-04
00:00:00', 'bool_field1': False, 'varchar_field1': 'AxQrnHdMsO', 'char_field1':
'O'}, {'primary_key_id': '214', 'int_field1': 33632123, 'decimal_field1': 736,
'datetime_field1': '2003-02-23 00:00:00', 'bool_field1': False,
'varchar_field1': 'YtkoUkGwIV', 'char_field1': 'P'}, {'primary_key_id': '215',
'int_field1': 94363414, 'decimal_field1': 8981, 'datetime_field1': '1999-07-18
00:00:00', 'bool_field1': False, 'varchar_field1': 'wXqZwccBXK', 'char_field1':
'C'}, {'primary_key_id': '216', 'int_field1': 30458191, 'decimal_field1': 5412,
'datetime_field1': '2008-12-08 00:00:00', 'bool_field1': True,
'varchar_field1': 'SjSrvnNTiD', 'char_field1': 'X'}, {'primary_key_id': '217',
'int_field1': 31824144, 'decimal_field1': 4187, 'datetime_field1': '2000-10-06
00:00:00', 'bool_field1': True, 'varchar_field1': 'eLqKTwhChH', 'char_field1':
'G'}, {'primary_key_id': '218', 'int_field1': 34050461, 'decimal_field1': 4565,
'datetime_field1': '2013-09-04 00:00:00', 'bool_field1': True,
'varchar_field1': 'iZrjoNnNTP', 'char_field1': 'V'}, {'primary_key_id': '219',
'int_field1': 46872419, 'decimal_field1': 3547, 'datetime_field1': '2006-06-02
00:00:00', 'bool_field1': False, 'varchar_field1': 'WiYgohwGCT', 'char_field1':
'Y'}, {'primary_key_id': '22', 'int_field1': 15677579, 'decimal_field1': 2804,
'datetime_field1': '2009-10-25 00:00:00', 'bool_field1': False,
'varchar_field1': 'kYoLXfOhpE', 'char_field1': 'J'}, {'primary_key_id': '220',
'int_field1': 58514065, 'decimal_field1': 8591, 'datetime_field1': '2003-06-16
00:00:00', 'bool_field1': True, 'varchar_field1': 'fhSPuVFKow', 'char_field1':
'D'}, {'primary_key_id': '221', 'int_field1': 86679417, 'decimal_field1': 4753,
'datetime_field1': '2014-07-11 00:00:00', 'bool_field1': False,
'varchar_field1': 'EgNGmNucvB', 'char_field1': 'V'}, {'primary_key_id': '222',
'int_field1': 48382632, 'decimal_field1': 6391, 'datetime_field1': '2011-03-20
00:00:00', 'bool_field1': True, 'varchar_field1': 'DVgnbLeIJs', 'char_field1':
'V'}, {'primary_key_id': '223', 'int_field1': 79799602, 'decimal_field1': 915,
'datetime_field1': '2010-04-17 00:00:00', 'bool_field1': False,
'varchar_field1': 'pDqGdLvPVj', 'char_field1': 'B'}, {'primary_key_id': '224',
'int_field1': 49203658, 'decimal_field1': 1709, 'datetime_field1': '2012-03-10
00:00:00', 'bool_field1': True, 'varchar_field1': 'yLNVBgfnaU', 'char_field1':
'J'}, {'primary_key_id': '225', 'int_field1': 40661014, 'decimal_field1': 1175,
'datetime_field1': '2011-04-19 00:00:00', 'bool_field1': False,
'varchar_field1': 'esCQfzVePD', 'char_field1': 'F'}, {'primary_key_id': '226',
'int_field1': 34474718, 'decimal_field1': 1442, 'datetime_field1': '2004-08-24
00:00:00', 'bool_field1': False, 'varchar_field1': 'JKcXdjYzIw', 'char_field1':
'B'}, {'primary_key_id': '227', 'int_field1': 39974649, 'decimal_field1': 1938,
'datetime_field1': '2000-04-28 00:00:00', 'bool_field1': False,
'varchar_field1': 'kXSgzQBcIc', 'char_field1': 'X'}, {'primary_key_id': '228',
'int_field1': 74171311, 'decimal_field1': 3814, 'datetime_field1': '2008-10-27
00:00:00', 'bool_field1': False, 'varchar_field1': 'hIrMuFTZga', 'char_field1':
'U'}, {'primary_key_id': '229', 'int_field1': 32488651, 'decimal_field1': 9990,
'datetime_field1': '2009-01-26 00:00:00', 'bool_field1': True,
'varchar_field1': 'LNzFcAjlvN', 'char_field1': 'Y'}, {'primary_key_id': '23',
'int_field1': 46199497, 'decimal_field1': 1899, 'datetime_field1': '2011-03-24
00:00:00', 'bool_field1': False, 'varchar_field1': 'huVwNynQYV', 'char_field1':
'R'}, {'primary_key_id': '230', 'int_field1': 36930299, 'decimal_field1': 924,
'datetime_field1': '2003-08-04 00:00:00', 'bool_field1': True,
'varchar_field1': 'jjBBWBoffA', 'char_field1': 'H'}, {'primary_key_id': '231',
'int_field1': 77604910, 'decimal_field1': 6433, 'datetime_field1': '2009-01-25
00:00:00', 'bool_field1': False, 'varchar_field1': 'QluEntYgJO', 'char_field1':
'K'}, {'primary_key_id': '232', 'int_field1': 43305092, 'decimal_field1': 6308,
'datetime_field1': '1999-06-15 00:00:00', 'bool_field1': True,
'varchar_field1': 'OvWsFujsPH', 'char_field1': 'C'}, {'primary_key_id': '233',
'int_field1': 20329341, 'decimal_field1': 3975, 'datetime_field1': '2011-06-02
00:00:00', 'bool_field1': False, 'varchar_field1': 'ogjBXEelRM', 'char_field1':
'F'}, {'primary_key_id': '234', 'int_field1': 96612164, 'decimal_field1': 7963,
'datetime_field1': '2006-04-12 00:00:00', 'bool_field1': True,
'varchar_field1': 'LmAAOpvuIb', 'char_field1': 'N'}, {'primary_key_id': '235',
'int_field1': 10229276, 'decimal_field1': 8630, 'datetime_field1': '2014-09-25
00:00:00', 'bool_field1': False, 'varchar_field1': 'IUKQbczMoq', 'char_field1':
'D'}, {'primary_key_id': '236', 'int_field1': 7214198, 'decimal_field1': 9346,
'datetime_field1': '2013-02-21 00:00:00', 'bool_field1': True,
'varchar_field1': 'AUPjcirVCe', 'char_field1': 'W'}, {'primary_key_id': '237',
'int_field1': 44429416, 'decimal_field1': 4836, 'datetime_field1': '2008-07-14
00:00:00', 'bool_field1': True, 'varchar_field1': 'mMdhKBbWfP', 'char_field1':
'S'}, {'primary_key_id': '238', 'int_field1': 38753497, 'decimal_field1': 2528,
'datetime_field1': '2002-09-09 00:00:00', 'bool_field1': True,
'varchar_field1': 'dgOcIWzQAm', 'char_field1': 'Q'}, {'primary_key_id': '239',
'int_field1': 33590023, 'decimal_field1': 4125, 'datetime_field1': '2003-01-08
00:00:00', 'bool_field1': True, 'varchar_field1': 'MiZpChDahZ', 'char_field1':
'J'}, {'primary_key_id': '24', 'int_field1': 47780609, 'decimal_field1': 1426,
'datetime_field1': '2010-09-26 00:00:00', 'bool_field1': False,
'varchar_field1': 'NWiMzqqYtR', 'char_field1': 'M'}, {'primary_key_id': '240',
'int_field1': 70381880, 'decimal_field1': 272, 'datetime_field1': '2014-09-24
00:00:00', 'bool_field1': False, 'varchar_field1': 'JBsakuDNDn', 'char_field1':
'Y'}, {'primary_key_id': '241', 'int_field1': 89204970, 'decimal_field1': 9859,
'datetime_field1': '2013-05-08 00:00:00', 'bool_field1': True,
'varchar_field1': 'tZUpcQhCeK', 'char_field1': 'A'}, {'primary_key_id': '242',
'int_field1': 16476415, 'decimal_field1': 4948, 'datetime_field1': '2013-01-17
00:00:00', 'bool_field1': True, 'varchar_field1': 'NDYHibqVec', 'char_field1':
'V'}, {'primary_key_id': '243', 'int_field1': 90934594, 'decimal_field1': 5548,
'datetime_field1': '2013-02-10 00:00:00', 'bool_field1': False,
'varchar_field1': 'epdmHEEcFS', 'char_field1': 'O'}, {'primary_key_id': '244',
'int_field1': 81367447, 'decimal_field1': 4395, 'datetime_field1': '2001-06-12
00:00:00', 'bool_field1': True, 'varchar_field1': 'bTOofeQYrU', 'char_field1':
'U'}, {'primary_key_id': '245', 'int_field1': 10182909, 'decimal_field1': 2193,
'datetime_field1': '2000-06-16 00:00:00', 'bool_field1': False,
'varchar_field1': 'GPoZCrBgsd', 'char_field1': 'K'}, {'primary_key_id': '246',
'int_field1': 45530621, 'decimal_field1': 9220, 'datetime_field1': '2004-01-23
00:00:00', 'bool_field1': False, 'varchar_field1': 'rnvKelYPJL', 'char_field1':
'F'}, {'primary_key_id': '247', 'int_field1': 71886769, 'decimal_field1': 8921,
'datetime_field1': '2011-01-04 00:00:00', 'bool_field1': False,
'varchar_field1': 'MuDjXAwSbd', 'char_field1': 'A'}, {'primary_key_id': '248',
'int_field1': 49395285, 'decimal_field1': 4057, 'datetime_field1': '2002-06-17
00:00:00', 'bool_field1': True, 'varchar_field1': 'zAdnmZDEBa', 'char_field1':
'C'}, {'primary_key_id': '249', 'int_field1': 16245410, 'decimal_field1': 6328,
'datetime_field1': '2012-08-11 00:00:00', 'bool_field1': False,
'varchar_field1': 'tBaJBTrSjo', 'char_field1': 'T'}, {'primary_key_id': '25',
'int_field1': 96119463, 'decimal_field1': 8622, 'datetime_field1': '2009-03-10
00:00:00', 'bool_field1': True, 'varchar_field1': 'GOtEWQdzgh', 'char_field1':
'T'}, {'primary_key_id': '250', 'int_field1': 95530432, 'decimal_field1': 1571,
'datetime_field1': '2008-03-12 00:00:00', 'bool_field1': False,
'varchar_field1': 'HSIzlEzhSg', 'char_field1': 'O'}, {'primary_key_id': '251',
'int_field1': 23767827, 'decimal_field1': 1390, 'datetime_field1': '2004-12-15
00:00:00', 'bool_field1': False, 'varchar_field1': 'gPLrHlTeqJ', 'char_field1':
'N'}, {'primary_key_id': '252', 'int_field1': 204673, 'decimal_field1': 4120,
'datetime_field1': '2013-02-28 00:00:00', 'bool_field1': True,
'varchar_field1': 'jDnDgMjDYq', 'char_field1': 'K'}, {'primary_key_id': '253',
'int_field1': 67606538, 'decimal_field1': 6768, 'datetime_field1': '2013-06-03
00:00:00', 'bool_field1': False, 'varchar_field1': 'fgRqePSHkX', 'char_field1':
'B'}, {'primary_key_id': '254', 'int_field1': 76881468, 'decimal_field1': 8508,
'datetime_field1': '2004-03-11 00:00:00', 'bool_field1': True,
'varchar_field1': 'nPgoBwSNIs', 'char_field1': 'H'}, {'primary_key_id': '255',
'int_field1': 95381191, 'decimal_field1': 6058, 'datetime_field1': '2014-05-28
00:00:00', 'bool_field1': True, 'varchar_field1': 'aFTEFxOvfk', 'char_field1':
'M'}, {'primary_key_id': '256', 'int_field1': 49045159, 'decimal_field1': 4727,
'datetime_field1': '2001-05-12 00:00:00', 'bool_field1': False,
'varchar_field1': 'ptJyYKtKMp', 'char_field1': 'R'}, {'primary_key_id': '257',
'int_field1': 44670010, 'decimal_field1': 7459, 'datetime_field1': '2003-04-14
00:00:00', 'bool_field1': True, 'varchar_field1': 'cKWCmFriGm', 'char_field1':
'S'}, {'primary_key_id': '258', 'int_field1': 70927209, 'decimal_field1': 541,
'datetime_field1': '2003-07-13 00:00:00', 'bool_field1': False,
'varchar_field1': 'vLBxJgbQzO', 'char_field1': 'G'}, {'primary_key_id': '259',
'int_field1': 37344475, 'decimal_field1': 1530, 'datetime_field1': '2000-07-23
00:00:00', 'bool_field1': False, 'varchar_field1': 'ISszFhsIAr', 'char_field1':
'Y'}, {'primary_key_id': '26', 'int_field1': 58855615, 'decimal_field1': 2178,
'datetime_field1': '2002-09-23 00:00:00', 'bool_field1': True,
'varchar_field1': 'CNhcAstMhF', 'char_field1': 'M'}, {'primary_key_id': '260',
'int_field1': 13774590, 'decimal_field1': 4271, 'datetime_field1': '2000-02-26
00:00:00', 'bool_field1': True, 'varchar_field1': 'qYApQxciZH', 'char_field1':
'L'}, {'primary_key_id': '261', 'int_field1': 81342434, 'decimal_field1': 7860,
'datetime_field1': '2000-11-23 00:00:00', 'bool_field1': False,
'varchar_field1': 'VlUeRiGOxr', 'char_field1': 'C'}, {'primary_key_id': '262',
'int_field1': 21634375, 'decimal_field1': 7659, 'datetime_field1': '2013-10-17
00:00:00', 'bool_field1': True, 'varchar_field1': 'lmFDjkBDrM', 'char_field1':
'L'}, {'primary_key_id': '263', 'int_field1': 53358511, 'decimal_field1': 5944,
'datetime_field1': '2001-12-22 00:00:00', 'bool_field1': False,
'varchar_field1': 'MbvdBWVImp', 'char_field1': 'V'}, {'primary_key_id': '264',
'int_field1': 18819552, 'decimal_field1': 5687, 'datetime_field1': '2010-08-04
00:00:00', 'bool_field1': True, 'varchar_field1': 'kBCIcrpUNw', 'char_field1':
'Q'}, {'primary_key_id': '265', 'int_field1': 85134484, 'decimal_field1': 9550,
'datetime_field1': '2004-10-01 00:00:00', 'bool_field1': True,
'varchar_field1': 'cBsdNYzFFk', 'char_field1': 'U'}, {'primary_key_id': '266',
'int_field1': 58814551, 'decimal_field1': 6947, 'datetime_field1': '2009-12-22
00:00:00', 'bool_field1': False, 'varchar_field1': 'InMnRdyTSo', 'char_field1':
'G'}, {'primary_key_id': '267', 'int_field1': 25566898, 'decimal_field1': 6955,
'datetime_field1': '2014-06-06 00:00:00', 'bool_field1': False,
'varchar_field1': 'giYADXgHke', 'char_field1': 'G'}, {'primary_key_id': '268',
'int_field1': 24476450, 'decimal_field1': 3380, 'datetime_field1': '2002-05-04
00:00:00', 'bool_field1': False, 'varchar_field1': 'CqyMOkDRxe', 'char_field1':
'L'}, {'primary_key_id': '269', 'int_field1': 47334311, 'decimal_field1': 8424,
'datetime_field1': '2003-11-25 00:00:00', 'bool_field1': True,
'varchar_field1': 'pKzLMfXglB', 'char_field1': 'A'}, {'primary_key_id': '27',
'int_field1': 66456171, 'decimal_field1': 9853, 'datetime_field1': '2013-04-07
00:00:00', 'bool_field1': False, 'varchar_field1': 'VGiwKyJZxi', 'char_field1':
'I'}, {'primary_key_id': '270', 'int_field1': 97084715, 'decimal_field1': 4548,
'datetime_field1': '2005-06-02 00:00:00', 'bool_field1': True,
'varchar_field1': 'TCywasBdZF', 'char_field1': 'C'}, {'primary_key_id': '271',
'int_field1': 85759833, 'decimal_field1': 8229, 'datetime_field1': '2013-04-18
00:00:00', 'bool_field1': False, 'varchar_field1': 'uYbavKTSLt', 'char_field1':
'Q'}, {'primary_key_id': '272', 'int_field1': 75030382, 'decimal_field1': 4935,
'datetime_field1': '2012-05-27 00:00:00', 'bool_field1': False,
'varchar_field1': 'rmPoRfKPxH', 'char_field1': 'L'}, {'primary_key_id': '273',
'int_field1': 54077485, 'decimal_field1': 9343, 'datetime_field1': '2004-05-18
00:00:00', 'bool_field1': True, 'varchar_field1': 'yeIMdSxbJU', 'char_field1':
'K'}, {'primary_key_id': '274', 'int_field1': 26701425, 'decimal_field1': 4105,
'datetime_field1': '2014-11-19 00:00:00', 'bool_field1': True,
'varchar_field1': 'oIzekBHKLd', 'char_field1': 'P'}, {'primary_key_id': '275',
'int_field1': 71969206, 'decimal_field1': 3051, 'datetime_field1': '2003-01-13
00:00:00', 'bool_field1': False, 'varchar_field1': 'hUEOrwEOmb', 'char_field1':
'B'}, {'primary_key_id': '276', 'int_field1': 22751431, 'decimal_field1': 7979,
'datetime_field1': '2008-07-03 00:00:00', 'bool_field1': False,
'varchar_field1': 'rlKfXPAgbP', 'char_field1': 'X'}, {'primary_key_id': '277',
'int_field1': 73028308, 'decimal_field1': 6945, 'datetime_field1': '2010-01-17
00:00:00', 'bool_field1': False, 'varchar_field1': 'VivDrNIyAi', 'char_field1':
'Q'}, {'primary_key_id': '278', 'int_field1': 16115087, 'decimal_field1': 2214,
'datetime_field1': '2010-12-20 00:00:00', 'bool_field1': False,
'varchar_field1': 'LrqNtttNZT', 'char_field1': 'W'}]);
{code}
{code:java}
compact collection sample_collection;
{code}
{code:java}
select int_field1 from sample_collection where bool_field1 = false;
{code}
will add a smaller reproducer later.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
