Susumu Yata
null+****@clear*****
Mon Jul 3 00:52:03 JST 2017
Susumu Yata 2017-07-03 00:52:03 +0900 (Mon, 03 Jul 2017) New Revision: 1ed105d4b2fc073524a35f213bccbc963364b015 https://github.com/groonga/groonga/commit/1ed105d4b2fc073524a35f213bccbc963364b015 Message: test: add tests for text-to-int typecasts in load GitHub: #722 Added files: test/command/suite/load/max/text/int16.expected test/command/suite/load/max/text/int16.test test/command/suite/load/max/text/int32.expected test/command/suite/load/max/text/int32.test test/command/suite/load/max/text/int64.expected test/command/suite/load/max/text/int64.test test/command/suite/load/max/text/int8.expected test/command/suite/load/max/text/int8.test test/command/suite/load/max/text/uint16.expected test/command/suite/load/max/text/uint16.test test/command/suite/load/max/text/uint32.expected test/command/suite/load/max/text/uint32.test test/command/suite/load/max/text/uint64.expected test/command/suite/load/max/text/uint64.test test/command/suite/load/max/text/uint8.expected test/command/suite/load/max/text/uint8.test test/command/suite/load/min/text/int16.expected test/command/suite/load/min/text/int16.test test/command/suite/load/min/text/int32.expected test/command/suite/load/min/text/int32.test test/command/suite/load/min/text/int64.expected test/command/suite/load/min/text/int64.test test/command/suite/load/min/text/int8.expected test/command/suite/load/min/text/int8.test Added: test/command/suite/load/max/text/int16.expected (+11 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/int16.expected 2017-07-03 00:52:03 +0900 (eafeb25) @@ -0,0 +1,11 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values value COLUMN_SCALAR Int16 +[[0,0.0,0.0],true] +load --table Values +[ +{"value": "32767"} +] +[[0,0.0,0.0],1] +select Values --output_columns _id,value +[[0,0.0,0.0],[[[1],[["_id","UInt32"],["value","Int16"]],[1,32767]]]] Added: test/command/suite/load/max/text/int16.test (+9 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/int16.test 2017-07-03 00:52:03 +0900 (c7a5d31) @@ -0,0 +1,9 @@ +table_create Values TABLE_NO_KEY +column_create Values value COLUMN_SCALAR Int16 + +load --table Values +[ +{"value": "32767"} +] + +select Values --output_columns _id,value Added: test/command/suite/load/max/text/int32.expected (+11 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/int32.expected 2017-07-03 00:52:03 +0900 (55474b0) @@ -0,0 +1,11 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values value COLUMN_SCALAR Int32 +[[0,0.0,0.0],true] +load --table Values +[ +{"value": "2147483647"} +] +[[0,0.0,0.0],1] +select Values --output_columns _id,value +[[0,0.0,0.0],[[[1],[["_id","UInt32"],["value","Int32"]],[1,2147483647]]]] Added: test/command/suite/load/max/text/int32.test (+9 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/int32.test 2017-07-03 00:52:03 +0900 (06a4d4e) @@ -0,0 +1,9 @@ +table_create Values TABLE_NO_KEY +column_create Values value COLUMN_SCALAR Int32 + +load --table Values +[ +{"value": "2147483647"} +] + +select Values --output_columns _id,value Added: test/command/suite/load/max/text/int64.expected (+38 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/int64.expected 2017-07-03 00:52:03 +0900 (9d8c837) @@ -0,0 +1,38 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values value COLUMN_SCALAR Int64 +[[0,0.0,0.0],true] +load --table Values +[ +{"value": "9223372036854775807"} +] +[[0,0.0,0.0],1] +select Values --output_columns _id,value +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 1 + ], + [ + [ + "_id", + "UInt32" + ], + [ + "value", + "Int64" + ] + ], + [ + 1, + 9223372036854775807 + ] + ] + ] +] Added: test/command/suite/load/max/text/int64.test (+9 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/int64.test 2017-07-03 00:52:03 +0900 (78896cb) @@ -0,0 +1,9 @@ +table_create Values TABLE_NO_KEY +column_create Values value COLUMN_SCALAR Int64 + +load --table Values +[ +{"value": "9223372036854775807"} +] + +select Values --output_columns _id,value Added: test/command/suite/load/max/text/int8.expected (+11 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/int8.expected 2017-07-03 00:52:03 +0900 (60ae9a8) @@ -0,0 +1,11 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values value COLUMN_SCALAR Int8 +[[0,0.0,0.0],true] +load --table Values +[ +{"value": "127"} +] +[[0,0.0,0.0],1] +select Values --output_columns _id,value +[[0,0.0,0.0],[[[1],[["_id","UInt32"],["value","Int8"]],[1,127]]]] Added: test/command/suite/load/max/text/int8.test (+9 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/int8.test 2017-07-03 00:52:03 +0900 (8daa43e) @@ -0,0 +1,9 @@ +table_create Values TABLE_NO_KEY +column_create Values value COLUMN_SCALAR Int8 + +load --table Values +[ +{"value": "127"} +] + +select Values --output_columns _id,value Added: test/command/suite/load/max/text/uint16.expected (+11 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/uint16.expected 2017-07-03 00:52:03 +0900 (2f658a5) @@ -0,0 +1,11 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values value COLUMN_SCALAR UInt16 +[[0,0.0,0.0],true] +load --table Values +[ +{"value": "65535"} +] +[[0,0.0,0.0],1] +select Values --output_columns _id,value +[[0,0.0,0.0],[[[1],[["_id","UInt32"],["value","UInt16"]],[1,65535]]]] Added: test/command/suite/load/max/text/uint16.test (+9 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/uint16.test 2017-07-03 00:52:03 +0900 (65e56c2) @@ -0,0 +1,9 @@ +table_create Values TABLE_NO_KEY +column_create Values value COLUMN_SCALAR UInt16 + +load --table Values +[ +{"value": "65535"} +] + +select Values --output_columns _id,value Added: test/command/suite/load/max/text/uint32.expected (+11 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/uint32.expected 2017-07-03 00:52:03 +0900 (5888001) @@ -0,0 +1,11 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values value COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +load --table Values +[ +{"value": "4294967295"} +] +[[0,0.0,0.0],1] +select Values --output_columns _id,value +[[0,0.0,0.0],[[[1],[["_id","UInt32"],["value","UInt32"]],[1,4294967295]]]] Added: test/command/suite/load/max/text/uint32.test (+9 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/uint32.test 2017-07-03 00:52:03 +0900 (4697a1f) @@ -0,0 +1,9 @@ +table_create Values TABLE_NO_KEY +column_create Values value COLUMN_SCALAR UInt32 + +load --table Values +[ +{"value": "4294967295"} +] + +select Values --output_columns _id,value Added: test/command/suite/load/max/text/uint64.expected (+38 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/uint64.expected 2017-07-03 00:52:03 +0900 (323e58e) @@ -0,0 +1,38 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values value COLUMN_SCALAR UInt64 +[[0,0.0,0.0],true] +load --table Values +[ +{"value": "18446744073709551615"} +] +[[0,0.0,0.0],1] +select Values --output_columns _id,value +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 1 + ], + [ + [ + "_id", + "UInt32" + ], + [ + "value", + "UInt64" + ] + ], + [ + 1, + 18446744073709551615 + ] + ] + ] +] Added: test/command/suite/load/max/text/uint64.test (+9 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/uint64.test 2017-07-03 00:52:03 +0900 (7952a32) @@ -0,0 +1,9 @@ +table_create Values TABLE_NO_KEY +column_create Values value COLUMN_SCALAR UInt64 + +load --table Values +[ +{"value": "18446744073709551615"} +] + +select Values --output_columns _id,value Added: test/command/suite/load/max/text/uint8.expected (+11 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/uint8.expected 2017-07-03 00:52:03 +0900 (18b3462) @@ -0,0 +1,11 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values value COLUMN_SCALAR UInt8 +[[0,0.0,0.0],true] +load --table Values +[ +{"value": "255"} +] +[[0,0.0,0.0],1] +select Values --output_columns _id,value +[[0,0.0,0.0],[[[1],[["_id","UInt32"],["value","UInt8"]],[1,255]]]] Added: test/command/suite/load/max/text/uint8.test (+9 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/max/text/uint8.test 2017-07-03 00:52:03 +0900 (062a270) @@ -0,0 +1,9 @@ +table_create Values TABLE_NO_KEY +column_create Values value COLUMN_SCALAR UInt8 + +load --table Values +[ +{"value": "255"} +] + +select Values --output_columns _id,value Added: test/command/suite/load/min/text/int16.expected (+11 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/min/text/int16.expected 2017-07-03 00:52:03 +0900 (b01f394) @@ -0,0 +1,11 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values value COLUMN_SCALAR Int16 +[[0,0.0,0.0],true] +load --table Values +[ +{"value": "-32768"} +] +[[0,0.0,0.0],1] +select Values --output_columns _id,value +[[0,0.0,0.0],[[[1],[["_id","UInt32"],["value","Int16"]],[1,-32768]]]] Added: test/command/suite/load/min/text/int16.test (+9 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/min/text/int16.test 2017-07-03 00:52:03 +0900 (428f5f1) @@ -0,0 +1,9 @@ +table_create Values TABLE_NO_KEY +column_create Values value COLUMN_SCALAR Int16 + +load --table Values +[ +{"value": "-32768"} +] + +select Values --output_columns _id,value Added: test/command/suite/load/min/text/int32.expected (+11 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/min/text/int32.expected 2017-07-03 00:52:03 +0900 (3440ff5) @@ -0,0 +1,11 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values value COLUMN_SCALAR Int32 +[[0,0.0,0.0],true] +load --table Values +[ +{"value": "-2147483648"} +] +[[0,0.0,0.0],1] +select Values --output_columns _id,value +[[0,0.0,0.0],[[[1],[["_id","UInt32"],["value","Int32"]],[1,-2147483648]]]] Added: test/command/suite/load/min/text/int32.test (+9 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/min/text/int32.test 2017-07-03 00:52:03 +0900 (429978c) @@ -0,0 +1,9 @@ +table_create Values TABLE_NO_KEY +column_create Values value COLUMN_SCALAR Int32 + +load --table Values +[ +{"value": "-2147483648"} +] + +select Values --output_columns _id,value Added: test/command/suite/load/min/text/int64.expected (+38 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/min/text/int64.expected 2017-07-03 00:52:03 +0900 (d64cbe8) @@ -0,0 +1,38 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values value COLUMN_SCALAR Int64 +[[0,0.0,0.0],true] +load --table Values +[ +{"value": "-9223372036854775808"} +] +[[0,0.0,0.0],1] +select Values --output_columns _id,value +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 1 + ], + [ + [ + "_id", + "UInt32" + ], + [ + "value", + "Int64" + ] + ], + [ + 1, + -9223372036854775808 + ] + ] + ] +] Added: test/command/suite/load/min/text/int64.test (+9 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/min/text/int64.test 2017-07-03 00:52:03 +0900 (091c1b2) @@ -0,0 +1,9 @@ +table_create Values TABLE_NO_KEY +column_create Values value COLUMN_SCALAR Int64 + +load --table Values +[ +{"value": "-9223372036854775808"} +] + +select Values --output_columns _id,value Added: test/command/suite/load/min/text/int8.expected (+11 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/min/text/int8.expected 2017-07-03 00:52:03 +0900 (fd8df2b) @@ -0,0 +1,11 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values value COLUMN_SCALAR Int8 +[[0,0.0,0.0],true] +load --table Values +[ +{"value": "-128"} +] +[[0,0.0,0.0],1] +select Values --output_columns _id,value +[[0,0.0,0.0],[[[1],[["_id","UInt32"],["value","Int8"]],[1,-128]]]] Added: test/command/suite/load/min/text/int8.test (+9 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/load/min/text/int8.test 2017-07-03 00:52:03 +0900 (7ae0143) @@ -0,0 +1,9 @@ +table_create Values TABLE_NO_KEY +column_create Values value COLUMN_SCALAR Int8 + +load --table Values +[ +{"value": "-128"} +] + +select Values --output_columns _id,value -------------- next part -------------- HTML����������������������������... Download