<div dir="ltr"><div><div><div>村上です。<br><br>以下のようにインデックスカラムがないときはselectのfilter内の関数の<br>結果での式が評価されます。<br><br>plugin_register functions/vector<br>[[0,0.0,0.0],true]<br>table_create Users TABLE_NO_KEY<br>[[0,0.0,0.0],true]<br>column_create Users names COLUMN_VECTOR ShortText<br>[[0,0.0,0.0],true]<br>load --table Users<br>[<br>{&quot;names&quot;: [&quot;Alice&quot;, &quot;Bob&quot;]},<br>{&quot;names&quot;: [&quot;Tom&quot;]}<br>]<br>[[0,0.0,0.0],2]<br>select Users --filter &#39;vector_size(names) == 1&#39; --output_columns &#39;names&#39; --command_version 2<br>[[0,0.0,0.0],[[[1],[[&quot;names&quot;,&quot;ShortText&quot;]],[[&quot;Tom&quot;]]]]]<br></div><br></div>しかし、インデックスカラムがある場合は、関数での結果で式を評価できません。<br>シーケンシャルサーチにはなりますが関数は呼ばれません。<br>これは仕様ですか？<br><br><br>plugin_register functions/vector<br>[[0,0.0,0.0],true]<br>table_create Users TABLE_NO_KEY<br>[[0,0.0,0.0],true]<br>column_create Users names COLUMN_VECTOR ShortText<br>[[0,0.0,0.0],true]<br>table_create Words TABLE_PAT_KEY ShortText<br>[[0,0.0,0.0],true]<br>column_create Words users COLUMN_INDEX Users names<br>[[0,0.0,0.0],true]<br>load --table Users<br>[<br>{&quot;names&quot;: [&quot;Alice&quot;, &quot;Bob&quot;]},<br>{&quot;names&quot;: [&quot;Tom&quot;]}<br>]<br>[[0,0.0,0.0],2]<br>select Users --filter &#39;vector_size(names) == 1&#39; --output_columns &#39;names&#39; --command_version 2<br>[[0,0.0,0.0],[[[0],[[&quot;names&quot;,&quot;ShortText&quot;]]]]]<br><br></div>よろしくお願いします。<br><div><br><br></div></div>