[BUG] deeplake v4.5.6 raises 'deeplake._deeplake.InvalidType: Dtype is unknown.' for filter ((-104454 * f3[12]) != 0), but no error for ((f3[12] * -104454) != 0) #3147
Description
Severity
P2 - Not urgent, nice to have
Current Behavior
Deeplake raises a Dtype is unknown exception
Steps to Reproduce
run the following code to reproduce the error.
import deeplake as deeplake_lib
from deeplake import types as dl_types
import numpy as np
# create dataset
path = "mem://test_collection"
try:
deeplake_lib.delete(path)
except:
pass
ds = deeplake_lib.create(path)
# define schema
ds.add_column("f0", dl_types.Text())
ds.add_column("f1", dl_types.Dict())
ds.add_column("f2", dl_types.Text())
ds.add_column("f3", dl_types.Array("int64", 1))
ds.add_column("f4", dl_types.Float32())
ds.add_column("f5", dl_types.Bool())
ds.add_column("f6", dl_types.Embedding(34, dtype='float32'))
ds.add_column("f7", dl_types.Embedding(86, dtype='float32'))
# define data
data_list = [
{'f0': '', 'f1': {'e1': -376707, 'e4': 0, 'e5': False, 'e6': False, 'e3': [0.16164, 0, -0.58172, 0.84732, -0.80616, -0.55324, -0.85403, 0.63764, 0, -0.59601, 0, -0.55499, -0.06859], 'e2': -0.54477}, 'f2': '+O2*M=', 'f3': [0, 0, 144740, 0, 0, 376007, 0, 433928, -82129, 3154, 238297, -168037], 'f4': 0, 'f5': True, 'f6': [0.42573, 0.79153, 0.6364, 0.19344, 0.55068, 0.39151, 0.09344, 0.82567, 0.06643, 0.45215, 0.94213, 0.54453, 0.20783, 0.44767, 0.55159, 0.39835, 0.38987, 0.12159, 0.02728, 0.32253, 0.70929, 0.55861, 0.98812, 0.93794, 0.45273, 0.52077, 0.12324, 0.43113, 0.21398, 0.54107, 0.88514, 0.89577, 0.8699, 0.64384], 'f7': [0.02376, 0.45177, 0.3607, 0.07637, 0.9763, 0.10899, 0.53501, 0.75874, 0.25349, 0.50072, 0.45411, 0.95776, 0.15757, 0.01884, 0.5484, 0.25245, 0.42963, 0.02607, 0.10318, 0.9615, 0.50725, 0.37684, 0.21614, 0.93488, 0.16416, 0.65967, 0.0333, 0.40293, 0.70406, 0.20086, 0.4021, 0.24425, 0.23477, 0.69606, 0.65291, 0.48196, 0.82025, 0.22651, 0.79967, 0.94753, 0.64592, 0.82294, 0.84021, 0.17501, 0.85972, 0.12601, 0.99727, 0.04705, 0.98675, 0.02407, 0.74614, 0.79427, 0.06138, 0.09267, 0.6171, 0.77004, 0.76632, 0.12759, 0.7404, 0.87235, 0.84263, 0.72409, 0.50133, 0.62287, 0.55175, 0.83351, 0.11366, 0.35764, 0.45267, 0.40132, 0.87776, 0.58793, 0.67653, 0.63118, 0.2743, 0.02396, 0.33473, 0.28213, 0.77051, 0.5261, 0.66022, 0.99951, 0.36825, 0.46881, 0.60006, 0.03325]},
{'f0': ',0Mzg`UQd`', 'f1': {'e1': 50049, 'e2': -0.17696, 'e0': [0, 96842, 186205, -80456, 122114, 326436, 326221, 97463, 443121, 499934, -399524, -466567, -471037, -167059, 0, -351766, 210357, 245513, -119785, -54188, -267464, 86202], 'e3': [-0.42787, 0, -0.9399, -0.97286, 0.98184, 0.4504, -0.97539, 0.82725, 0.71888, 0.32121, -0.58168, 0.9841, 0.23656, 0, -0.73758, -0.47101]}, 'f2': '', 'f3': [-405908, 433307, 227720, -164972, -294881, -332867, -481955, 0, 434945, -305863, 444781, 0, 187936, 312137, -495613], 'f4': -0.4705, 'f5': True, 'f6': [0.41361, 0.88641, 0.28517, 0.17987, 0.53646, 0.36055, 0.09089, 0.52804, 0.09204, 0.88999, 0.64107, 0.54996, 0.67993, 0.72175, 0.02391, 0.44685, 0.27343, 0.12816, 0.68112, 0.84832, 0.72814, 0.69496, 0.99012, 0.95723, 0.38938, 0.50154, 0.117, 0.43954, 0.22669, 0.43561, 0.90037, 0.07556, 0.88148, 0.6517], 'f7': [0.97653, 0.6256, 0.27181, 0.73283, 0.99588, 0.11119, 0.04969, 0.08349, 0.03917, 0.49065, 0.10998, 0.95762, 0.42566, 0.61563, 0.57937, 0.57221, 0.41205, 0.04211, 0.08695, 0.84585, 0.54836, 0.34126, 0.20689, 0.96261, 0.16622, 0.02506, 0.00237, 0.76508, 0.84767, 0.36869, 0.62861, 0.33853, 0.36076, 0.65605, 0.6503, 0.84972, 0.68799, 0.40861, 0.99168, 0.83475, 0.63621, 0.82602, 0.84908, 0.47587, 0.44121, 0.26121, 0.98567, 0.15642, 0.88074, 0.79795, 0.76567, 0.3253, 0.23288, 0.63683, 0.84829, 0.77493, 0.78821, 0.10407, 0.99668, 0.0047, 0.27613, 0.83018, 0.77395, 0.8948, 0.23414, 0.81093, 0.5537, 0.49682, 0.88381, 0.28142, 0.8916, 0.15865, 0.6383, 0.62952, 0.26777, 0.48115, 0.31506, 0.4236, 0.79167, 0.51022, 0.56779, 0.53106, 0.30584, 0.94947, 0.56057, 0.0233]},
{'f0': 'S_*m', 'f1': {'e2': 0.04567, 'e4': 0.91594, 'e0': [436777, 127597, -446058, 179677, 0, 0, -154142, -361001, 459361, -462213], 'e5': False, 'e3': [0.45665], 'e6': True, 'e1': -55258}, 'f2': '|#yM', 'f3': [0, -359347, -167016], 'f4': -0.70844, 'f5': False, 'f6': [0.16796, 0.62417, 0.6113, 0.59557, 0.46638, 0.34554, 0.52448, 0.19113, 0.09154, 0.19806, 0.70742, 0.00295, 0.90427, 0.17913, 0.11281, 0.41554, 0.22286, 0.14159, 0.67487, 0.74516, 0.54287, 0.56664, 0.99317, 0.925, 0.43206, 0.46798, 0.47447, 0.22719, 0.81825, 0.96547, 0.89026, 0.05834, 0.559, 0.66539], 'f7': [0.93045, 0.44806, 0.26498, 0.46342, 0.4906, 0.30095, 0.90629, 0.49963, 0.28586, 0.5126, 0.08793, 0.96419, 0.37257, 0.43137, 0.70981, 0.79853, 0.4586, 0.07434, 0.08479, 0.18586, 0.55548, 0.63019, 0.24342, 0.58819, 0.31823, 0.36969, 0.02222, 0.75386, 0.0891, 0.36122, 0.4275, 0.36083, 0.34828, 0.46154, 0.66495, 0.23386, 0.23421, 0.97381, 0.80451, 0.99913, 0.25503, 0.85886, 0.84774, 0.47242, 0.43404, 0.03941, 0.00716, 0.5079, 0.91359, 0.52832, 0.09287, 0.82688, 0.83839, 0.14266, 0.841, 0.07397, 0.83881, 0.25125, 0.81591, 0.01659, 0.27709, 0.54703, 0.90891, 0.65808, 0.85741, 0.36385, 0.97036, 0.35984, 0.77624, 0.43928, 0.18738, 0.15566, 0.9637, 0.3923, 0.29708, 0.88397, 0.97364, 0.52281, 0.8071, 0.52223, 0.65659, 0.52916, 0.05439, 0.92108, 0.36682, 0.61935]},
{'f0': '?tZw', 'f1': {'e2': -0.15912, 'e0': [10545, -179230, -406070, 342674, 57331, 35986, -307794, 82211, 172187, 96723, -7154, 128, 470785, 96583, 151225, 250628, -345657, 270185, 307799, -455210, 89884], 'e6': False, 'e1': 66055, 'e5': True, 'e4': -0.76257, 'e3': [0.55793, 0, 0.33494, 0, 0.13485, -0.08201, 0.60393, -0.3692, 0.77779, 0, 0, 0, 0.5579, -0.26074, 0.21539, 0.39162]}, 'f2': 'X&', 'f3': [0, -358530], 'f4': 0, 'f5': False, 'f6': [0.41627, 0.87631, 0.15894, 0.66268, 0.53648, 0.36281, 0.10432, 0.72814, 0.94961, 0.93198, 0.68576, 0.55336, 0.62777, 0.43285, 0.90571, 0.35545, 0.28806, 0.21949, 0.67258, 0.84679, 0.5486, 0.54995, 0.99225, 0.396, 0.36341, 0.49572, 0.62273, 0.2166, 0.20584, 0.46173, 0.73915, 0.09692, 0.17821, 0.63932], 'f7': [0.97242, 0.45718, 0.40263, 0.07843, 0.96969, 0.60068, 0.51936, 0.75029, 0.2859, 0.50385, 0.96654, 0.96212, 0.65388, 0.12917, 0.7797, 0.81381, 0.88757, 0.05721, 0.0903, 0.37061, 0.59332, 0.35658, 0.22619, 0.58143, 0.94252, 0.35465, 0.00937, 0.40506, 0.128, 0.95039, 0.40368, 0.0556, 0.42252, 0.75734, 0.63731, 0.45693, 0.68907, 0.40471, 0.95754, 0.32952, 0.26707, 0.78633, 0.85532, 0.50167, 0.02578, 0.19958, 0.05426, 0.23385, 0.89201, 0.41226, 0.72702, 0.82529, 0.33444, 0.38002, 0.50396, 0.76843, 0.23189, 0.27907, 0.76794, 0.98495, 0.8366, 0.63951, 0.76904, 0.64677, 0.76775, 0.11994, 0.10276, 0.47022, 0.46699, 0.94059, 0.75039, 0.58108, 0.65041, 0.41275, 0.28103, 0.25311, 0.31251, 0.52609, 0.32864, 0.51723, 0.53767, 0.2725, 0.99468, 0.97244, 0.38524, 0.64842]},
{'f0': '&[JG;hZ', 'f1': {'e3': [-0.29468, 0.22433, 0, 0.01219, -0.66482, 0.14506, 0, -0.7742, 0], 'e1': 444375, 'e2': 0.36719, 'e4': 0, 'e0': [216292, -486849, 304723, 0, 323695, 264900, 0, -140654, 0, 220191, -452889, 30449, 0, 56893, 0, 455266]}, 'f2': 'bJm9oV)tai', 'f3': [-60721, -53223, 0, 331237, 0, 342062, -26326, -436751, -449301, 358159, -59721, -224848, -474016, -115163, -301788], 'f4': 0.7987, 'f5': False, 'f6': [0.42575, 0.87582, 0.16593, 0.21173, 0.4918, 0.38224, 0.08244, 0.1706, 0.11063, 0.54127, 0.64561, 0.87209, 0.68562, 0.88388, 0.35959, 0.32832, 0.38568, 0.11857, 0.04171, 0.72883, 0.67845, 0.68369, 0.97334, 0.38067, 0.4129, 0.51282, 0.63852, 0.21549, 0.22888, 0.98001, 0.7416, 0.07867, 0.37417, 0.25084], 'f7': [0.08147, 0.3637, 0.29131, 0.44027, 0.48296, 0.29285, 0.50611, 0.48682, 0.27946, 0.51529, 0.1556, 0.9665, 0.97817, 0.53913, 0.60216, 0.79506, 0.42533, 0.05008, 0.47591, 0.97379, 0.58657, 0.63515, 0.2241, 0.37968, 0.18686, 0.36576, 0.01125, 0.74623, 0.70699, 0.36633, 0.12898, 0.97998, 0.64943, 0.78467, 0.65351, 0.76659, 0.69298, 0.96551, 0.7838, 0.82269, 0.64133, 0.92771, 0.84584, 0.49087, 0.57625, 0.68749, 0.97252, 0.88589, 0.8029, 0.05216, 0.20188, 0.35251, 0.05332, 0.41998, 0.83974, 0.77651, 0.06953, 0.24787, 0.3049, 0.02533, 0.83934, 0.02407, 0.76988, 0.68444, 0.86247, 0.37809, 0.12871, 0.47403, 0.18908, 0.93819, 0.91964, 0.61063, 0.63386, 0.57498, 0.28591, 0.84165, 0.32743, 0.55432, 0.30608, 0.50191, 0.04333, 0.53033, 0.30562, 0.23174, 0.59122, 0.70808]},
{'f0': 'tV^WaQBY+', 'f1': {'e4': -0.32914, 'e0': [0, 400369, -162146, -280246, 0, -461347], 'e1': -142775, 'e6': False, 'e3': [-0.02617, 0.06798, -0.59393], 'e2': 0.60837, 'e5': True}, 'f2': ':RWM', 'f3': [0, 0, 112599, 186462, -302117], 'f4': -0.24487, 'f5': True, 'f6': [0.43129, 0.61464, 0.3362, 0.18386, 0.5735, 0.35746, 0.10698, 0.50137, 0.96868, 0.91073, 0.69049, 0.51378, 0.57907, 0.88297, 0.36891, 0.3726, 0.26941, 0.1255, 0.68943, 0.70735, 0.24967, 0.68199, 0.95714, 0.37472, 0.37191, 0.46855, 0.59152, 0.21295, 0.22149, 0.10311, 0.89064, 0.85309, 0.82876, 0.22672], 'f7': [0.57763, 0.71737, 0.2696, 0.78189, 0.97853, 0.11565, 0.49687, 0.08195, 0.27909, 0.49619, 0.99883, 0.05358, 0.39217, 0.59885, 0.62431, 0.28192, 0.86717, 0.05161, 0.45978, 0.95992, 0.51012, 0.6444, 0.22193, 0.35886, 0.94922, 0.87944, 0.00411, 0.21571, 0.71467, 0.39134, 0.44131, 0.99796, 0.66067, 0.69572, 0.64388, 0.8841, 0.75193, 0.42143, 0.84143, 0.95156, 0.66391, 0.92453, 0.86718, 0.50528, 0.8388, 0.29717, 0.07397, 0.87794, 0.48819, 0.38834, 0.67797, 0.82937, 0.22681, 0.26531, 0.44775, 0.75363, 0.99429, 0.09355, 0.98572, 0.99366, 0.27967, 0.85492, 0.87783, 0.64796, 0.82529, 0.41879, 0.98211, 0.34744, 0.80297, 0.17716, 0.90776, 0.16484, 0.64332, 0.63498, 0.26191, 0.31086, 0.3229, 0.04624, 0.40559, 0.52023, 0.11206, 0.12827, 0.02308, 0.24925, 0.50788, 0.55312]},
{'f0': '', 'f1': {'e0': [-137967, -251573, -24248, -87990, 0, 0, 0], 'e5': False, 'e2': 0.49437, 'e6': False, 'e1': -293893}, 'f2': ']4k[', 'f3': [421549, 334945, 427376, 0, 413767, 290516, 348645, 278215, 0, -39006, -422369, 202483, -9513, -170060, -250548], 'f4': 0, 'f5': True, 'f6': [0.14957, 0.81514, 0.15001, 0.6128, 0.47794, 0.36886, 0.10163, 0.1859, 0.94035, 0.40368, 0.93815, 0.01077, 0.89619, 0.99581, 0.00211, 0.60136, 0.37558, 0.09072, 0.02893, 0.85588, 0.55815, 0.62745, 0.98333, 0.86134, 0.38608, 0.48063, 0.02694, 0.08409, 0.23061, 0.52555, 0.8835, 0.0566, 0.14878, 0.23625], 'f7': [0.60854, 0.67578, 0.40289, 0.4455, 0.75355, 0.29416, 0.51213, 0.72891, 0.25888, 0.45751, 0.1045, 0.09208, 0.64744, 0.64419, 0.59415, 0.55859, 0.87464, 0.02731, 0.09281, 0.37213, 0.56725, 0.63291, 0.21536, 0.55522, 0.58009, 0.11518, 0.02281, 0.38264, 0.82329, 0.37618, 0.13221, 0.33332, 0.62051, 0.74998, 0.66589, 0.89668, 0.84263, 0.41914, 0.98323, 0.93464, 0.65266, 0.77829, 0.82025, 0.45273, 0.4603, 0.03591, 0.9991, 0.11159, 0.93483, 0.79439, 0.71811, 0.36872, 0.12762, 0.25146, 0.45195, 0.22185, 0.05882, 0.11712, 0.96558, 0.921, 0.55788, 0.76734, 0.11236, 0.90083, 0.55818, 0.84932, 0.96788, 0.61637, 0.21363, 0.25504, 0.91667, 0.19492, 0.40132, 0.64546, 0.49038, 0.31813, 0.29877, 0.41186, 0.27616, 0.52386, 0.04862, 0.12762, 0.2886, 0.97411, 0.57418, 0.53647]},
{'f0': 'J$2', 'f1': {'e2': 0, 'e6': True}, 'f2': 'd.dl', 'f3': [-305657, -430338, 34049, -451450, 276529, 91948, -334872], 'f4': 0, 'f5': True, 'f6': [0.41512, 0.62786, 0.15464, 0.55862, 0.85278, 0.36644, 0.08895, 0.19591, 0.12391, 0.3972, 0.67555, 0.5342, 0.89769, 0.85666, 0.13854, 0.35654, 0.3734, 0.79674, 0.66896, 0.7241, 0.69644, 0.69631, 0.97839, 0.90054, 0.37053, 0.49069, 0.68309, 0.21652, 0.17036, 0.97826, 0.90866, 0.57842, 0.1177, 0.63887], 'f7': [0.82788, 0.63506, 0.3852, 0.39069, 0.33934, 0.11417, 0.88595, 0.61001, 0.30186, 0.50367, 0.13594, 0.06702, 0.99297, 0.00775, 0.58892, 0.59541, 0.9027, 0.04789, 0.08656, 0.98652, 0.54334, 0.64894, 0.23975, 0.61896, 0.33084, 0.63653, 0.02073, 0.75161, 0.71904, 0.37796, 0.72327, 0.30258, 0.23484, 0.9773, 0.64779, 0.88473, 0.21605, 0.95206, 0.98181, 0.79483, 0.65342, 0.81554, 0.85724, 0.48537, 9e-05, 0.27834, 0.06898, 0.50924, 0.49036, 0.42471, 0.05437, 0.83568, 0.79882, 0.03452, 0.833, 0.78793, 0.39968, 0.25996, 0.3034, 0.99712, 0.83725, 0.85159, 0.90261, 0.65412, 0.87519, 0.83546, 0.52887, 0.62708, 0.20585, 0.14708, 0.13788, 0.16957, 0.66614, 0.63109, 0.48437, 0.85831, 0.30237, 0.28664, 0.34032, 0.5298, 0.55879, 0.26816, 0.08702, 0.09618, 0.09475, 0.65973]},
{'f0': '=gZ', 'f1': {'e0': [113716, 46513, -354506, 396799, -247224, 298713, 21063, 247545, 23726, 190468, 130487, -358276, -459012, -156675], 'e3': [0.20962, 0.58023, 0.22152, 0.61129, 0.68616, -0.61262]}, 'f2': 'W', 'f3': [-470223, -109660, 205820, 348763, -199420, 0, 249704, 0, 0, 334611, -74719, 61958, -352292, -96598, -235144, -444648, 329207, 196262, -206225, 0, -190015, -124716, 409760, 154094], 'f4': 0, 'f5': True, 'f6': [0.41777, 0.81402, 0.02867, 0.61165, 0.53713, 0.40116, 0.12058, 0.48136, 0.12866, 0.42913, 0.69937, 0.50135, 0.53558, 0.84622, 0.16599, 0.36305, 0.10396, 0.14018, 0.67616, 0.13231, 0.54436, 0.65648, 0.98203, 0.89183, 0.34847, 0.50366, 0.52204, 0.21394, 0.18364, 0.16009, 0.88374, 0.09628, 0.55586, 0.64641], 'f7': [0.84919, 0.69172, 0.41164, 0.40577, 0.70238, 0.97391, 0.64444, 0.73686, 0.91462, 0.48674, 0.71093, 0.98596, 0.15701, 0.00353, 0.34304, 0.58112, 0.4348, 0.06551, 0.49128, 0.95204, 0.57783, 0.63623, 0.22301, 0.39094, 0.17013, 0.14985, 0.02383, 0.39008, 0.43691, 0.93432, 0.69113, 0.35001, 0.20781, 0.74204, 0.645, 0.12841, 0.22758, 0.16017, 0.99259, 0.32073, 0.6384, 0.77517, 0.84275, 0.49281, 0.45739, 0.1972, 0.7507, 0.18039, 0.96646, 0.40137, 0.68059, 0.37629, 0.92672, 0.44016, 0.44819, 0.77201, 0.86954, 0.13081, 0.97718, 0.96121, 0.27674, 0.56124, 0.45306, 0.62923, 0.54958, 0.51769, 0.99098, 0.47892, 0.75177, 0.66407, 0.14026, 0.35902, 0.65085, 0.38952, 0.48186, 0.84079, 0.27753, 0.42393, 0.38714, 0.49896, 0.67814, 0.13234, 0.07355, 0.07902, 0.12275, 0.01817]},
{'f0': '8YNHV*km', 'f1': {'e0': [0, -364737, -52133, 0, -112558, 0, -72888, -390716, -99807, -128195, -196827, 188481, 59913, -142805, 158384, -486891, 299736, -100055], 'e5': True, 'e3': [0.63494], 'e2': -0.19651}, 'f2': '#pPAVR(X', 'f3': [486527, 0, 482785, 0, 0, 0, 472508, 239914, 0, -329970, 301703, -343448, -140560], 'f4': 0.51835, 'f5': True, 'f6': [0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], 'f7': [0.56017, 0.50316, 0.15423, 0.82393, 0.48962, 0.61993, 0.65138, 0.22727, 0.29649, 0.52286, 0.09932, 0.07481, 0.7687, 0.5201, 0.76862, 0.80166, 0.44627, 0.00503, 0.09597, 0.94986, 0.53009, 0.37646, 0.23926, 0.37389, 0.17962, 0.01258, 0.01143, 0.41313, 0.72167, 0.39253, 0.0828, 0.32696, 0.66633, 0.7341, 0.63953, 0.89777, 0.08941, 0.97268, 0.81372, 0.92883, 0.65443, 0.82085, 0.84696, 0.22593, 0.85145, 0.16892, 0.98622, 0.1711, 0.4911, 0.39004, 0.48415, 0.79759, 0.84693, 0.01909, 0.46009, 0.10005, 0.0554, 0.1078, 0.77163, 0.97274, 0.29351, 0.76614, 0.75185, 0.04271, 0.791, 0.39555, 0.09323, 0.35005, 0.20759, 0.25614, 0.8798, 0.20414, 0.40803, 0.39345, 0.27052, 0.26026, 0.57872, 0.49313, 0.84318, 0.51547, 0.59396, 0.14712, 0.74591, 0.92879, 0.54994, 0.09038]},
{'f0': 'L5ei7p)ug+', 'f1': {'e0': [-374646, -167638, 0, 167690], 'e3': [0.88065, 0, 0, 0.2822, 0.14505, -0.45119, -0.92236, -0.80227, 0, 0, 0, -0.04104, 0.77784, -0.73446, 0], 'e5': True}, 'f2': '9/@bKy<', 'f3': [289190, -225052, 0, 200937, -124664, -354682, -44217, -287655, 401242, 347065, 0, -412031, -174850, -159702, 302224, 168903, -415151], 'f4': 0, 'f5': False, 'f6': [0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1], 'f7': [0.01257, 0.46314, 0.26611, 0.48406, 0.6921, 0.98969, 0.65832, 0.50878, 0.30037, 0.52563, 0.09046, 0.21546, 0.14916, 0.64459, 0.57479, 0.54919, 0.39615, 0.03594, 0.48401, 0.98347, 0.5686, 0.36893, 0.26666, 0.93383, 0.57732, 0.14098, 0.02852, 0.41744, 0.93644, 0.37784, 0.42072, 0.99867, 0.24368, 0.70413, 0.66728, 0.91951, 0.69611, 0.41538, 0.98788, 0.30775, 0.66429, 0.77491, 0.85695, 0.27177, 0.48527, 0.28436, 0.05386, 0.16889, 0.49389, 0.42, 0.04085, 0.34905, 0.83284, 0.25005, 0.47695, 0.78093, 0.79145, 0.13893, 0.76922, 0.96855, 0.28005, 0.12911, 0.89993, 0.03923, 0.53672, 0.3924, 0.97239, 0.35657, 0.55621, 0.93279, 0.90405, 0.15696, 0.4125, 0.61846, 0.28177, 0.32817, 0.33516, 0.301, 0.23914, 0.7774, 0.55291, 0.97224, 0.10316, 0.2402, 0.08093, 0.54934]},
{'f0': '<AZe', 'f1': {'e0': [-484023, -432615, -442498, 0, -198415, 0, -498314, 31498, 0, -412663, 390112, 282227, -388393, 310109, 0, 0, 485821, -389001, 0], 'e6': True, 'e5': True, 'e4': 0.13175, 'e2': 0.1384, 'e3': [0.15467, -0.5643, -0.47252, 0.44576, 0], 'e1': 0}, 'f2': 's>)s8q9', 'f3': [146158, -372302, 76564, 473806, 0, 92722, 0, 143386, -495673, 0, -108831, -49923, 0, 278282, 167907, 15835, 350001, 0, -397968], 'f4': -0.69911, 'f5': False, 'f6': [0.4201, 0.8926, 0.00557, 0.14133, 0.47626, 0.36601, 0.50157, 0.49988, 0.94509, 0.44398, 0.69141, 0.56041, 0.68999, 0.97081, 0.05007, 0.33187, 0.18334, 0.20517, 0.72264, 0.49833, 0.55802, 0.59601, 0.98533, 0.38611, 0.40116, 0.46085, 0.61758, 0.22506, 0.22311, 0.9885, 0.89915, 0.08522, 0.16558, 0.64016], 'f7': [0.57824, 0.62746, 0.19846, 0.08221, 0.70245, 0.11938, 0.50125, 0.08116, 0.27752, 0.51355, 0.06069, 0.2117, 0.37541, 0.11438, 0.85286, 0.25775, 0.42016, 0.04359, 0.09117, 0.92713, 0.56512, 0.3689, 0.25076, 0.06932, 0.17098, 0.01037, 0.00718, 0.19531, 0.95187, 0.96502, 0.7368, 0.84983, 0.86998, 0.98448, 0.65067, 0.75811, 0.70449, 0.4093, 0.81471, 0.95526, 0.65457, 0.91924, 0.83553, 0.46751, 0.11177, 0.82629, 0.74391, 0.2298, 0.49366, 0.38264, 0.74244, 0.84673, 0.11191, 0.17633, 0.49531, 0.76694, 0.36333, 0.37214, 0.78417, 0.85615, 0.84882, 0.07039, 0.78641, 0.37763, 0.51991, 0.12814, 0.50724, 0.61692, 0.77744, 0.63816, 0.12166, 0.57568, 0.65028, 0.38684, 0.43682, 0.31427, 0.26301, 0.04709, 0.22517, 0.50635, 0.56349, 0.5442, 0.31908, 0.23409, 0.57933, 0.015]},
{'f0': '', 'f1': {'e3': [0.74999, -0.69923, -0.06422, 0.59243], 'e4': -0.7072, 'e5': True, 'e2': 0, 'e0': [-240978, -494305, -138503, 0, -57930, -407000, -391331, -166849, -247320, 375951, 0, 0, 0, 0, 290120, -393776, -38404, -225194, 335656, 416614, 485417, -89279, -83358, 166716, 312461, -72551], 'e6': False}, 'f2': '1P;FBj|t', 'f3': [434254, -474455, -402957, 72195, 0, 294621, -209351, 0, 0, 0, -443647, -406713, -162588, -151986], 'f4': 0.70728, 'f5': True, 'f6': [0.15104, 0.61246, 0.3276, 0.63082, 0.4939, 0.41864, 0.09175, 0.50359, 0.94142, 0.52678, 0.66731, 0.54504, 0.9023, 0.74576, 0.16093, 0.59366, 0.27665, 0.11579, 0.0271, 0.51209, 0.71033, 0.56442, 0.99535, 0.93258, 0.41101, 0.49307, 0.61891, 0.226, 0.20569, 0.9755, 0.74547, 0.08128, 0.81457, 0.62228], 'f7': [0.842, 0.64445, 0.2797, 0.45512, 0.75794, 0.73411, 0.91184, 0.27009, 0.31283, 0.5151, 0.70689, 0.35952, 0.37683, 0.39851, 0.32943, 0.78816, 0.44741, 0.05561, 0.09875, 0.94402, 0.55752, 0.62817, 0.24182, 0.3809, 0.18786, 0.14252, 0.00619, 0.38774, 0.85869, 0.93723, 0.14936, 0.30115, 0.62445, 0.7764, 0.64961, 0.12834, 0.87503, 0.12702, 0.79648, 0.8502, 0.67542, 0.92755, 0.8622, 0.25652, 0.1107, 0.15389, 0.99358, 0.22382, 0.47849, 0.41953, 0.05984, 0.825, 0.04994, 0.11482, 0.47506, 0.77635, 0.43186, 0.10155, 0.75558, 0.97499, 0.29881, 0.80783, 0.89603, 0.07089, 0.57261, 0.39539, 0.56247, 0.62104, 0.80481, 0.26577, 0.89314, 0.34551, 0.64405, 0.63297, 0.44446, 0.28318, 0.58435, 0.44978, 0.22766, 0.5118, 0.534, 0.53999, 0.28182, 0.68646, 0.55568, 0.68512]},
{'f0': '(+zz^-o', 'f1': {'e1': 0, 'e0': [371964, 498078, 0, 53623, 81864, -196799, -382716, 115197, 0, -355112, 0, -331244, -28325, 0, -149617, -10714, 497076, -44262, -14673, 0, -188706, -58655, 382825, 204190, -142442]}, 'f2': 'Rq8xdK', 'f3': [-333369, -394589, 0, -305353, 416514, -392350, 0, 0, 0, -469810, -404125, -30690, 0, -327995, -117887, 137951, -174487, -218916, 0, -94676], 'f4': -0.27892, 'f5': False, 'f6': [0.4224, 0.6351, 0.09899, 0.56772, 0.53081, 0.3882, 0.08803, 0.52481, 0.10156, 0.94036, 0.9453, 0.86896, 0.67596, 0.24407, 0.13861, 0.37331, 0.39526, 0.79821, 0.70074, 0.71739, 0.20756, 0.63141, 0.98807, 0.4128, 0.36363, 0.50159, 0.02208, 0.20393, 0.20573, 0.9539, 0.89314, 0.86602, 0.5169, 0.27362], 'f7': [0.83868, 0.62201, 0.26197, 0.79056, 0.83116, 0.13976, 0.08387, 0.77211, 0.24488, 0.4885, 0.75126, 0.17713, 0.15665, 0.60983, 0.72107, 0.26765, 0.88216, 0.05264, 0.0704, 0.38021, 0.509, 0.63913, 0.23008, 0.42025, 0.17901, 0.12244, 0.03392, 0.41038, 0.88077, 0.96919, 0.44523, 0.85814, 0.64864, 0.78002, 0.65431, 0.89464, 0.83459, 0.97175, 0.99744, 0.93926, 0.64231, 0.912, 0.81203, 0.17566, 0.42595, 0.03188, 0.24598, 0.48895, 0.96872, 0.07918, 0.47258, 0.28835, 0.32581, 0.25507, 0.46086, 0.78258, 0.88372, 0.10643, 0.82499, 0.96299, 0.52857, 0.85349, 0.72923, 0.63947, 0.50957, 0.80756, 0.09266, 0.60715, 0.20683, 0.27511, 0.71155, 0.60706, 0.66345, 0.61081, 0.26944, 0.31996, 0.32173, 0.34188, 0.32617, 0.51375, 0.56159, 0.98581, 0.08795, 0.24137, 0.52284, 0.70034]},
{'f0': 'n+e~@', 'f1': {'e4': -0.74063, 'e1': 308913, 'e6': False, 'e0': [0, -284860, 0, -217379, 0, 365385, -323223, -148188, 239579, 0, 217383, 444825, 0, 14396, -192765, -328273, 436756, -160822], 'e5': False, 'e2': 0}, 'f2': '?{kZ#!0nJ', 'f3': [174865, 0, 353512, -341712, 459892, 0, 40660, 125470, 0, 273470, -97465, -107358, -329206, -263721, 0, 0, 410520, -303642, -81888], 'f4': 0, 'f5': True, 'f6': [0.18678, 0.621, 0.34462, 0.61731, 0.53912, 0.38468, 0.11575, 0.52627, 0.97026, 0.20134, 0.9142, 0.02928, 0.53907, 0.99363, 0.02026, 0.35332, 0.09194, 0.81858, 0.69249, 0.85388, 0.40922, 0.67746, 0.9972, 0.93104, 0.42005, 0.47994, 0.50078, 0.22507, 0.28202, 0.15013, 0.89952, 0.5968, 0.64708, 0.18286], 'f7': [0.05035, 0.69641, 0.25937, 0.40372, 0.99061, 0.60443, 0.49268, 0.10378, 0.04407, 0.48371, 0.71256, 0.08633, 0.17336, 0.52629, 0.14221, 0.28803, 0.40273, 0.08534, 0.08473, 0.94926, 0.58282, 0.36081, 0.21036, 0.37809, 0.18416, 0.97373, 0.01551, 0.39924, 0.14122, 0.37942, 0.55978, 0.2472, 0.23159, 0.432, 0.64801, 0.88643, 0.09475, 0.96681, 0.99807, 0.99409, 0.65705, 0.95254, 0.85189, 0.57948, 0.85061, 0.24193, 0.06794, 0.06788, 0.90733, 0.08405, 0.08492, 0.80989, 0.05518, 0.30276, 0.5254, 0.76162, 0.22166, 0.29173, 0.99551, 0.00969, 0.85596, 0.53604, 0.87777, 0.06877, 0.75346, 0.42782, 0.98827, 0.34311, 0.18925, 0.25007, 0.124, 0.3508, 0.37992, 0.63581, 0.40486, 0.34657, 0.99268, 0.48874, 0.27897, 0.50909, 0.6515, 0.12688, 0.09595, 0.26714, 0.57485, 0.63086]},
{'f0': 'B-2>::KC.', 'f1': {'e1': 0, 'e5': True, 'e0': [-142245], 'e2': -0.01245, 'e4': 0.55883, 'e3': [0.4736, 0.70395, -0.50855, 0.7001, 0, 0.07033, 0.53855, 0.41187, -0.73341, -0.31791, -0.86323, 0.23216, 0.84097, -0.53202, 0.15872, -0.32783, 0, 0.28052]}, 'f2': '(HF:S`)`', 'f3': [0, 87513, 3262, -301381, 52291, -339773, -360764, 319, 296001, -837, 0], 'f4': 0.27406, 'f5': True, 'f6': [0.41503, 0.58061, 0.28609, 0.11628, 0.47394, 0.39578, 0.52787, 0.73694, 0.95932, 0.41776, 0.67342, 0.51723, 0.52817, 0.73154, 0.90844, 0.37775, 0.19382, 0.11687, 0.04727, 0.85023, 0.3946, 0.634, 0.99647, 0.91041, 0.38541, 0.48305, 0.23548, 0.2185, 0.18694, 0.08616, 0.89571, 0.88659, 0.17744, 0.18992], 'f7': [0.82568, 0.6639, 0.41868, 0.39642, 0.36062, 0.63101, 0.64707, 0.24793, 0.01043, 0.53868, 0.67661, 0.95294, 0.16271, 0.62404, 0.71303, 0.29536, 0.4357, 0.04615, 0.10337, 0.3017, 0.54447, 0.3703, 0.23411, 0.42665, 0.32521, 0.1411, 0.02045, 0.22416, 0.11012, 0.93641, 0.1534, 0.95706, 0.86622, 0.67595, 0.66476, 0.89627, 0.69355, 0.02169, 0.82392, 0.96896, 0.65389, 0.92718, 0.83298, 0.17437, 0.03211, 0.14068, 0.05527, 0.19678, 0.7717, 0.0459, 0.47297, 0.85356, 0.20003, 0.1178, 0.83379, 0.78684, 0.77495, 0.12851, 0.82205, 0.00832, 0.55321, 0.75077, 0.49359, 0.38572, 0.27262, 0.38206, 0.48668, 0.49932, 0.7794, 0.69242, 0.73753, 0.87317, 0.62626, 0.63304, 0.28429, 0.13789, 0.97398, 0.2853, 0.4132, 0.51288, 0.51615, 0.53116, 0.31152, 0.28613, 0.53581, 0.53696]},
{'f0': 'z`HqmG^,', 'f1': {'e2': -0.4701, 'e4': 0, 'e5': True}, 'f2': '.', 'f3': [-28328, 209850, -96144, -320823, 30388, 0], 'f4': 0.78728, 'f5': True, 'f6': [0.4139, 0.80713, 0.30899, 0.18097, 0.55121, 0.35479, 0.1026, 0.7279, 0.11923, 0.38865, 0.64878, 0.01663, 0.76633, 0.73314, 0.0442, 0.42511, 0.22561, 0.13822, 0.67655, 0.8665, 0.41605, 0.62721, 0.99828, 0.39678, 0.38919, 0.48798, 0.66886, 0.2299, 0.23279, 0.52783, 0.90568, 0.07858, 0.85423, 0.29709], 'f7': [0.09002, 0.36916, 0.16818, 0.6417, 0.45897, 0.79036, 0.02752, 0.74565, 0.26818, 0.46739, 0.67271, 0.07539, 0.41644, 0.54611, 0.76063, 0.26763, 0.89351, 0.07798, 0.094, 0.39368, 0.55176, 0.61155, 0.20695, 0.41661, 0.34156, 0.12181, 0.02399, 0.37918, 0.58409, 0.40099, 0.14203, 0.33311, 0.60651, 0.97272, 0.64678, 0.53315, 0.23372, 0.16135, 0.99962, 0.82174, 0.6631, 0.77559, 0.84426, 0.4972, 0.01015, 0.28331, 0.24414, 0.50497, 0.47805, 0.03079, 0.07953, 0.79387, 0.11863, 0.3194, 0.83709, 0.79657, 0.21538, 0.11102, 0.29217, 0.87037, 0.52804, 0.6561, 0.48947, 0.06863, 0.50702, 0.43977, 0.09313, 0.00533, 0.57722, 0.23894, 0.45451, 0.3593, 0.64741, 0.6115, 0.27116, 0.85091, 0.31001, 0.42726, 0.8477, 0.52152, 0.55156, 0.99207, 0.30036, 0.21939, 0.10903, 0.03541]},
{'f0': 'E{j|+9)v`5', 'f1': {'e4': -0.97893}, 'f2': '$EU=n%', 'f3': [-446654, -119005, 150739, -481283, 0, 0, 0, 279429, -283256, 83319, 417506, -162737, -381461], 'f4': 0.55745, 'f5': False, 'f6': [0.41882, 0.63516, 0.04973, 0.19124, 0.46308, 0.38489, 0.08481, 0.4631, 0.06993, 0.55838, 0.6413, 0.85984, 0.26709, 0.3842, 0.10709, 0.40109, 0.14276, 0.12153, 0.69981, 0.12878, 0.54529, 0.66548, 0.99283, 0.91946, 0.41049, 0.48161, 0.49763, 0.22773, 0.21767, 0.57762, 0.88336, 0.05384, 0.78898, 0.21966], 'f7': [0.83016, 0.46587, 0.39768, 0.41006, 0.72832, 0.69535, 0.49968, 0.27287, 0.24518, 0.49848, 0.44402, 0.98009, 0.43687, 0.16445, 0.73049, 0.5696, 0.89205, 0.02717, 0.09019, 0.91981, 0.53737, 0.36694, 0.24611, 0.43015, 0.33704, 0.92321, 0.01399, 0.73587, 0.93852, 0.94848, 0.05903, 0.98225, 0.23412, 0.42916, 0.66033, 0.12087, 0.09367, 0.43391, 0.78594, 0.31866, 0.63094, 0.8205, 0.82893, 0.57879, 0.60551, 0.04028, 0.07119, 0.52716, 0.92015, 0.03466, 0.69691, 0.25109, 0.23191, 0.6285, 0.49086, 0.7892, 0.25967, 0.12272, 0.75991, 0.01647, 0.53511, 0.84839, 0.77542, 0.61933, 0.52638, 0.45762, 0.67896, 0.61087, 0.76613, 0.24058, 0.02667, 0.17934, 0.65695, 0.63168, 0.40883, 0.87543, 0.32085, 0.30782, 0.30698, 0.52854, 0.89282, 0.54743, 0.75004, 0.95596, 0.57325, 0.03217]},
{'f0': 'LhR:c', 'f1': {'e3': [-0.11919, -0.57669, 0, 0.51252, 0.99676, 0, 0, -0.98356, 0.4794, 0, 0.22667, 0, -0.33821, 0, 0], 'e1': 0}, 'f2': 'CS2{d', 'f3': [-446752, -76271, 0, 466803, 308388, -321741, 10187, 376754, 0, 97889, 0, 0, 397934, 280833, -8364], 'f4': 0.95761, 'f5': True, 'f6': [0.42512, 0.8774, 0.33534, 0.60147, 0.52805, 0.37249, 0.07763, 0.50431, 0.08451, 0.41956, 0.67124, 0.86055, 0.77362, 0.38352, 0.9704, 0.44597, 0.24719, 0.21824, 0.70858, 0.33047, 0.54082, 0.64841, 0.97706, 0.39977, 0.44724, 0.5409, 0.10155, 0.2339, 0.19543, 0.15345, 0.73846, 0.06384, 0.12997, 0.6463], 'f7': [0.82561, 0.70585, 0.35005, 0.06763, 0.82128, 0.71693, 0.62784, 0.88035, 0.03239, 0.49541, 0.73795, 0.20324, 0.35393, 0.91597, 0.84302, 0.79194, 0.41576, 0.04492, 0.47864, 0.97101, 0.54425, 0.3554, 0.24552, 0.9357, 0.1826, 0.64705, 0.01197, 0.21605, 0.40515, 0.18713, 0.42078, 0.33206, 0.64056, 0.58261, 0.66014, 0.49874, 0.70728, 0.14517, 0.8079, 0.32998, 0.65059, 0.92025, 0.83516, 0.50892, 0.61249, 0.14085, 0.04497, 0.23651, 0.87066, 0.06278, 0.46914, 0.80162, 0.38472, 0.44307, 0.4902, 0.21994, 0.43894, 0.26321, 0.75555, 0.00385, 0.87164, 0.60537, 0.89215, 0.6303, 0.87809, 0.42461, 0.67301, 0.34791, 0.20932, 0.29458, 0.45715, 0.20022, 0.6079, 0.37591, 0.48288, 0.88879, 0.28115, 0.47919, 0.21712, 0.5054, 0.98002, 0.55059, 0.28613, 0.2657, 0.09895, 0.06325]},
{'f0': 'U|Ue[2lo:', 'f1': {'e4': 0, 'e0': [0, 125545, -46725, 143815, 0, -455037, -351848, -13497, -3465, -340915, -120539]}, 'f2': '>|$r', 'f3': [0, 0, 299449, -252957, -371615, -428595, 76110, 93079, -104227, 0, 0, -46756, 226571, 243480, 422833, 243527, 424316], 'f4': -0.61366, 'f5': True, 'f6': [0.42752, 0.79348, 0.03408, 0.13937, 0.55102, 0.38701, 0.10506, 0.83697, 0.0763, 0.92922, 0.92931, 0.53248, 0.6787, 0.42937, 0.02055, 0.42928, 0.37609, 0.79547, 0.03026, 0.71282, 0.40148, 0.58546, 0.97638, 0.86327, 0.37771, 0.48201, 0.69499, 0.21882, 0.31587, 0.97454, 0.73374, 0.63027, 0.51276, 0.6398], 'f7': [0.59858, 0.65284, 0.26391, 0.45414, 0.98342, 0.29217, 0.64499, 0.88401, 0.2937, 0.4806, 0.76218, 0.09153, 0.74065, 0.1566, 0.70217, 0.58207, 0.89939, 0.04667, 0.08001, 0.2579, 0.5515, 0.3949, 0.2381, 0.53811, 0.94069, 0.97982, 0.0349, 0.22409, 0.45369, 0.22871, 0.45235, 0.33897, 0.63543, 0.64655, 0.66732, 0.26271, 0.8597, 0.43198, 0.995, 0.95228, 0.65697, 0.82365, 0.83755, 0.59686, 0.60484, 0.18867, 0.00699, 0.17298, 0.94993, 0.43037, 0.75285, 0.35223, 0.06381, 0.42765, 0.49137, 0.20526, 0.89798, 0.12867, 0.82606, 0.98677, 0.28379, 0.86382, 0.6098, 0.64709, 0.87694, 0.39521, 0.68022, 0.37177, 0.43163, 0.26633, 0.88686, 0.17389, 0.66037, 0.63344, 0.40072, 0.27716, 0.58512, 0.29204, 0.38766, 0.5011, 0.56455, 0.11591, 0.28938, 0.96619, 0.57424, 0.23516]},
{'f0': 's0S;y_yE#', 'f1': {'e3': [0.68491, 0.28778, 0, 0.96591, 0, 0.50424, -0.02364, 0.24216, -0.5866, 0.03445, 0.2263, 0.79786, -0.08508, -0.24747]}, 'f2': '@8D^=', 'f3': [-450825, 304146, -300820, 104241, 119125, -209163, -161825, 0, -428406, 109472, -3882], 'f4': 0.72034, 'f5': False, 'f6': [0.4114, 0.59707, 0.32488, 0.17917, 0.49273, 0.37198, 0.49714, 0.85263, 0.97774, 0.54669, 0.65703, 0.85732, 0.90219, 0.40765, 0.36042, 0.59055, 0.19733, 0.21355, 0.66561, 0.86711, 0.69074, 0.5251, 0.98715, 0.94458, 0.43789, 0.50867, 0.01005, 0.41643, 0.39249, 0.07584, 0.89869, 0.86282, 0.82912, 0.61103], 'f7': [0.6123, 0.46117, 0.42893, 0.03991, 0.73861, 0.60707, 0.05426, 0.73577, 0.01703, 0.48786, 0.70704, 0.21356, 0.6385, 0.87129, 0.73029, 0.25724, 0.88889, 0.02284, 0.08725, 0.95917, 0.54626, 0.63018, 0.24142, 0.38053, 0.3253, 0.35669, 0.00789, 0.22535, 0.46419, 0.97061, 0.1164, 0.24788, 0.22979, 0.43686, 0.64277, 0.45119, 0.70997, 0.97002, 0.81748, 0.81889, 0.64301, 0.84242, 0.86191, 0.59027, 0.04577, 0.11488, 0.25807, 0.55488, 0.46968, 0.79457, 0.6783, 0.82684, 0.07111, 0.42857, 0.59584, 0.76412, 0.77886, 0.10193, 0.7927, 0.98804, 0.86033, 0.65056, 0.90098, 0.36972, 0.562, 0.11905, 0.09686, 0.36658, 0.44274, 0.28188, 0.91099, 0.57618, 0.62322, 0.61178, 0.47537, 0.85473, 0.57654, 0.28695, 0.22549, 0.49396, 0.64122, 0.27096, 0.35774, 0.85576, 0.55268, 0.03483]},
]
pkey_name = 'f2'
pk_to_idx = {}
if pkey_name is not None and len(ds) > 0:
col = ds[pkey_name]
for i, v in enumerate(col):
pk_to_idx[v] = i
# insert data
for data in data_list:
pk = data.get(pkey_name) if pkey_name is not None else None
idx = pk_to_idx.get(pk) if pk is not None else None
if idx is None:
row = {k: [v] for k, v in data.items()}
ds.append(row)
if pk is not None:
pk_to_idx[pk] = len(ds) - 1
else:
for field, v in data.items():
if field in ['f0', 'f1', 'f2', 'f3', 'f4', 'f5', 'f6', 'f7']:
ds[field][idx] = v
ds.commit()
ds["f2"].create_index(dl_types.Inverted)
# build the query
target_vector = [0.58673, 0.69171, 0, -0.48815, -0.44447, 0.22053, -0.03507, 0.80613, 0, 0, 0.97243, 0, -0.44562, 0.15794, 0, -0.69033, -0.21655, 0, 0.88673, -0.83283, 0.36543, 0, -0.65554, -0.43319, 0, 0.64693, -0.59443, 0, 0.78558, 0.65626, -0.41932, 0, 0, 0.90494]
filter = '''((-104454 * f3[12]) != 0)'''
filter_correct = '''((f3[12] * -104454) != 0)'''
q = f'''SELECT *, L2_NORM(f6 - ARRAY{target_vector}) AS distance_score WHERE {filter} ORDER BY L2_NORM(f6 - ARRAY{target_vector}) ASC LIMIT 2067'''
q_correct = f'''SELECT *, L2_NORM(f6 - ARRAY{target_vector}) AS distance_score WHERE {filter_correct} ORDER BY L2_NORM(f6 - ARRAY{target_vector}) ASC LIMIT 2067'''
view = ds.query(q_correct) # this should not raise an error
view = ds.query(q) # this should raise an errorExpected/Desired Behavior
The multiplication operator should be commutative, switching the order of multiplication from -104454 * f3[12] to f3[12] * -104454 should not affect the query result.
Python Version
3.10
OS
22.04
IDE
No response
Packages
No response
Additional Context
No response
Possible Solution
No response
Are you willing to submit a PR?
- I'm willing to submit a PR (Thank you!)