Kouhei Sutou
null+****@clear*****
Mon Oct 3 13:21:01 JST 2016
Kouhei Sutou 2016-10-03 13:21:01 +0900 (Mon, 03 Oct 2016) New Revision: 17d3ff477ae8779489bc5cfa2f3a76f234b86f6e https://github.com/groonga/groonga/commit/17d3ff477ae8779489bc5cfa2f3a76f234b86f6e Message: test: add a test for sorting by reference column It's sorted by record ID not key. Added files: test/command/suite/select/sort_keys/reference.expected test/command/suite/select/sort_keys/reference.test Added: test/command/suite/select/sort_keys/reference.expected (+50 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/sort_keys/reference.expected 2016-10-03 13:21:01 +0900 (d21f371) @@ -0,0 +1,50 @@ +table_create Numbers TABLE_HASH_KEY Int32 +[[0,0.0,0.0],true] +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values number COLUMN_SCALAR Numbers +[[0,0.0,0.0],true] +load --table Values +[ +{"number": 127}, +{"number": 256}, +{"number": -255} +] +[[0,0.0,0.0],3] +select Values --sort_keys number --output_columns number._id,number +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 3 + ], + [ + [ + "number._id", + "UInt32" + ], + [ + "number", + "Numbers" + ] + ], + [ + 1, + 127 + ], + [ + 2, + 256 + ], + [ + 3, + -255 + ] + ] + ] +] Added: test/command/suite/select/sort_keys/reference.test (+13 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/sort_keys/reference.test 2016-10-03 13:21:01 +0900 (ee65828) @@ -0,0 +1,13 @@ +table_create Numbers TABLE_HASH_KEY Int32 + +table_create Values TABLE_NO_KEY +column_create Values number COLUMN_SCALAR Numbers + +load --table Values +[ +{"number": 127}, +{"number": 256}, +{"number": -255} +] + +select Values --sort_keys number --output_columns number._id,number -------------- next part -------------- HTML����������������������������...Download