Susumu Yata
null+****@clear*****
Fri Nov 17 11:20:46 JST 2017
Susumu Yata 2017-11-17 11:20:46 +0900 (Fri, 17 Nov 2017) New Revision: 9efd03ed79e215c623929cdb7cd6041e906e3961 https://github.com/groonga/groonga/commit/9efd03ed79e215c623929cdb7cd6041e906e3961 Message: test: add a test for in_values using an index with many values GitHub: #760 Added files: test/command/suite/select/function/in_values/with_index/many_values.expected test/command/suite/select/function/in_values/with_index/many_values.test Added: test/command/suite/select/function/in_values/with_index/many_values.expected (+145 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/function/in_values/with_index/many_values.expected 2017-11-17 11:20:46 +0900 (347c219ef) @@ -0,0 +1,145 @@ +table_create Items TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Items tag COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +table_create Tags TABLE_PAT_KEY UInt32 +[[0,0.0,0.0],true] +column_create Tags items_tag COLUMN_INDEX Items tag +[[0,0.0,0.0],true] +load --table Items +[ +["tag"], +[1], +[2], +[3], +[4], +[5], +[6], +[7], +[8], +[9], +[10], +[11], +[12], +[13], +[14], +[15], +[16], +[17], +[18], +[19], +[20], +[21], +[22], +[23], +[24], +[25], +[26], +[27], +[28], +[29], +[30], +[31], +[32], +[33], +[34], +[35], +[36], +[37], +[38], +[39], +[40], +[41], +[42], +[43], +[44], +[45], +[46], +[47], +[48], +[49], +[50], +[51], +[52], +[53], +[54], +[55], +[56], +[57], +[58], +[59], +[60], +[61], +[62], +[63], +[64], +[65], +[66], +[67], +[68], +[69], +[70], +[71], +[72], +[73], +[74], +[75], +[76], +[77], +[78], +[79], +[80], +[81], +[82], +[83], +[84], +[85], +[86], +[87], +[88], +[89], +[90], +[91], +[92], +[93], +[94], +[95], +[96], +[97], +[98], +[99], +[100], +[101], +[102], +[103], +[104], +[105], +[106], +[107], +[108], +[109], +[110], +[111], +[112], +[113], +[114], +[115], +[116], +[117], +[118], +[119], +[120], +[121], +[122], +[123], +[124], +[125], +[126], +[127], +[128], +[129], +[130] +] +[[0,0.0,0.0],130] +select Items --filter 'in_values(tag,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128)' --limit 0 +[[0,0.0,0.0],[[[128],[["_id","UInt32"],["tag","UInt32"]]]]] Added: test/command/suite/select/function/in_values/with_index/many_values.test (+144 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/function/in_values/with_index/many_values.test 2017-11-17 11:20:46 +0900 (881d09931) @@ -0,0 +1,144 @@ +table_create Items TABLE_NO_KEY +column_create Items tag COLUMN_SCALAR UInt32 + +table_create Tags TABLE_PAT_KEY UInt32 +column_create Tags items_tag COLUMN_INDEX Items tag + +load --table Items +[ +["tag"], +[1], +[2], +[3], +[4], +[5], +[6], +[7], +[8], +[9], +[10], +[11], +[12], +[13], +[14], +[15], +[16], +[17], +[18], +[19], +[20], +[21], +[22], +[23], +[24], +[25], +[26], +[27], +[28], +[29], +[30], +[31], +[32], +[33], +[34], +[35], +[36], +[37], +[38], +[39], +[40], +[41], +[42], +[43], +[44], +[45], +[46], +[47], +[48], +[49], +[50], +[51], +[52], +[53], +[54], +[55], +[56], +[57], +[58], +[59], +[60], +[61], +[62], +[63], +[64], +[65], +[66], +[67], +[68], +[69], +[70], +[71], +[72], +[73], +[74], +[75], +[76], +[77], +[78], +[79], +[80], +[81], +[82], +[83], +[84], +[85], +[86], +[87], +[88], +[89], +[90], +[91], +[92], +[93], +[94], +[95], +[96], +[97], +[98], +[99], +[100], +[101], +[102], +[103], +[104], +[105], +[106], +[107], +[108], +[109], +[110], +[111], +[112], +[113], +[114], +[115], +[116], +[117], +[118], +[119], +[120], +[121], +[122], +[123], +[124], +[125], +[126], +[127], +[128], +[129], +[130] +] + +select Items \ + --filter 'in_values(tag,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128)' \ + --limit 0 -------------- next part -------------- HTML����������������������������... URL: https://lists.osdn.me/mailman/archives/groonga-commit/attachments/20171117/25615e1e/attachment-0001.htm
