diff options
Diffstat (limited to 'mysql-test/r/ps_4heap.result')
| -rw-r--r-- | mysql-test/r/ps_4heap.result | 136 |
1 files changed, 68 insertions, 68 deletions
diff --git a/mysql-test/r/ps_4heap.result b/mysql-test/r/ps_4heap.result index f024db29633..8616fa0ddf4 100644 --- a/mysql-test/r/ps_4heap.result +++ b/mysql-test/r/ps_4heap.result @@ -2554,12 +2554,12 @@ set @arg00= 9223372036854775807 ; execute my_insert using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00 ; Warnings: -Warning 1264 Out of range value adjusted for column 'c1' at row 1 -Warning 1264 Out of range value adjusted for column 'c2' at row 1 -Warning 1264 Out of range value adjusted for column 'c3' at row 1 -Warning 1264 Out of range value adjusted for column 'c4' at row 1 -Warning 1264 Out of range value adjusted for column 'c5' at row 1 -Warning 1264 Out of range value adjusted for column 'c12' at row 1 +Warning 1264 Out of range value for column 'c1' at row 1 +Warning 1264 Out of range value for column 'c2' at row 1 +Warning 1264 Out of range value for column 'c3' at row 1 +Warning 1264 Out of range value for column 'c4' at row 1 +Warning 1264 Out of range value for column 'c5' at row 1 +Warning 1264 Out of range value for column 'c12' at row 1 execute my_select ; c1 127 c2 32767 @@ -2577,12 +2577,12 @@ set @arg00= '9223372036854775807' ; execute my_insert using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00 ; Warnings: -Warning 1264 Out of range value adjusted for column 'c1' at row 1 -Warning 1264 Out of range value adjusted for column 'c2' at row 1 -Warning 1264 Out of range value adjusted for column 'c3' at row 1 -Warning 1264 Out of range value adjusted for column 'c4' at row 1 -Warning 1264 Out of range value adjusted for column 'c5' at row 1 -Warning 1264 Out of range value adjusted for column 'c12' at row 1 +Warning 1264 Out of range value for column 'c1' at row 1 +Warning 1264 Out of range value for column 'c2' at row 1 +Warning 1264 Out of range value for column 'c3' at row 1 +Warning 1264 Out of range value for column 'c4' at row 1 +Warning 1264 Out of range value for column 'c5' at row 1 +Warning 1264 Out of range value for column 'c12' at row 1 execute my_select ; c1 127 c2 32767 @@ -2600,12 +2600,12 @@ set @arg00= -9223372036854775808 ; execute my_insert using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00 ; Warnings: -Warning 1264 Out of range value adjusted for column 'c1' at row 1 -Warning 1264 Out of range value adjusted for column 'c2' at row 1 -Warning 1264 Out of range value adjusted for column 'c3' at row 1 -Warning 1264 Out of range value adjusted for column 'c4' at row 1 -Warning 1264 Out of range value adjusted for column 'c5' at row 1 -Warning 1264 Out of range value adjusted for column 'c12' at row 1 +Warning 1264 Out of range value for column 'c1' at row 1 +Warning 1264 Out of range value for column 'c2' at row 1 +Warning 1264 Out of range value for column 'c3' at row 1 +Warning 1264 Out of range value for column 'c4' at row 1 +Warning 1264 Out of range value for column 'c5' at row 1 +Warning 1264 Out of range value for column 'c12' at row 1 execute my_select ; c1 -128 c2 -32768 @@ -2623,12 +2623,12 @@ set @arg00= '-9223372036854775808' ; execute my_insert using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00 ; Warnings: -Warning 1264 Out of range value adjusted for column 'c1' at row 1 -Warning 1264 Out of range value adjusted for column 'c2' at row 1 -Warning 1264 Out of range value adjusted for column 'c3' at row 1 -Warning 1264 Out of range value adjusted for column 'c4' at row 1 -Warning 1264 Out of range value adjusted for column 'c5' at row 1 -Warning 1264 Out of range value adjusted for column 'c12' at row 1 +Warning 1264 Out of range value for column 'c1' at row 1 +Warning 1264 Out of range value for column 'c2' at row 1 +Warning 1264 Out of range value for column 'c3' at row 1 +Warning 1264 Out of range value for column 'c4' at row 1 +Warning 1264 Out of range value for column 'c5' at row 1 +Warning 1264 Out of range value for column 'c12' at row 1 execute my_select ; c1 -128 c2 -32768 @@ -2646,14 +2646,14 @@ set @arg00= 1.11111111111111111111e+50 ; execute my_insert using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00 ; Warnings: -Warning 1264 Out of range value adjusted for column 'c1' at row 1 -Warning 1264 Out of range value adjusted for column 'c2' at row 1 -Warning 1264 Out of range value adjusted for column 'c3' at row 1 -Warning 1264 Out of range value adjusted for column 'c4' at row 1 -Warning 1264 Out of range value adjusted for column 'c5' at row 1 -Warning 1264 Out of range value adjusted for column 'c6' at row 1 -Warning 1264 Out of range value adjusted for column 'c7' at row 1 -Warning 1264 Out of range value adjusted for column 'c12' at row 1 +Warning 1264 Out of range value for column 'c1' at row 1 +Warning 1264 Out of range value for column 'c2' at row 1 +Warning 1264 Out of range value for column 'c3' at row 1 +Warning 1264 Out of range value for column 'c4' at row 1 +Warning 1264 Out of range value for column 'c5' at row 1 +Warning 1264 Out of range value for column 'c6' at row 1 +Warning 1264 Out of range value for column 'c7' at row 1 +Warning 1264 Out of range value for column 'c12' at row 1 execute my_select ; c1 127 c2 32767 @@ -2677,8 +2677,8 @@ Warning 1265 Data truncated for column 'c3' at row 1 Warning 1265 Data truncated for column 'c4' at row 1 Warning 1265 Data truncated for column 'c5' at row 1 Warning 1265 Data truncated for column 'c6' at row 1 -Warning 1264 Out of range value adjusted for column 'c7' at row 1 -Warning 1264 Out of range value adjusted for column 'c12' at row 1 +Warning 1264 Out of range value for column 'c7' at row 1 +Warning 1264 Out of range value for column 'c12' at row 1 execute my_select ; c1 1 c2 1 @@ -2696,14 +2696,14 @@ set @arg00= -1.11111111111111111111e+50 ; execute my_insert using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00 ; Warnings: -Warning 1264 Out of range value adjusted for column 'c1' at row 1 -Warning 1264 Out of range value adjusted for column 'c2' at row 1 -Warning 1264 Out of range value adjusted for column 'c3' at row 1 -Warning 1264 Out of range value adjusted for column 'c4' at row 1 -Warning 1264 Out of range value adjusted for column 'c5' at row 1 -Warning 1264 Out of range value adjusted for column 'c6' at row 1 -Warning 1264 Out of range value adjusted for column 'c7' at row 1 -Warning 1264 Out of range value adjusted for column 'c12' at row 1 +Warning 1264 Out of range value for column 'c1' at row 1 +Warning 1264 Out of range value for column 'c2' at row 1 +Warning 1264 Out of range value for column 'c3' at row 1 +Warning 1264 Out of range value for column 'c4' at row 1 +Warning 1264 Out of range value for column 'c5' at row 1 +Warning 1264 Out of range value for column 'c6' at row 1 +Warning 1264 Out of range value for column 'c7' at row 1 +Warning 1264 Out of range value for column 'c12' at row 1 execute my_select ; c1 -128 c2 -32768 @@ -2727,8 +2727,8 @@ Warning 1265 Data truncated for column 'c3' at row 1 Warning 1265 Data truncated for column 'c4' at row 1 Warning 1265 Data truncated for column 'c5' at row 1 Warning 1265 Data truncated for column 'c6' at row 1 -Warning 1264 Out of range value adjusted for column 'c7' at row 1 -Warning 1264 Out of range value adjusted for column 'c12' at row 1 +Warning 1264 Out of range value for column 'c7' at row 1 +Warning 1264 Out of range value for column 'c12' at row 1 execute my_select ; c1 -1 c2 -1 @@ -2959,45 +2959,45 @@ Warning 1265 Data truncated for column 'c17' at row 1 Warnings: Warning 1265 Data truncated for column 'c17' at row 1 Warnings: -Warning 1264 Out of range value adjusted for column 'c13' at row 1 -Warning 1264 Out of range value adjusted for column 'c14' at row 1 +Warning 1264 Out of range value for column 'c13' at row 1 +Warning 1264 Out of range value for column 'c14' at row 1 Warning 1265 Data truncated for column 'c15' at row 1 -Warning 1264 Out of range value adjusted for column 'c16' at row 1 -Warning 1264 Out of range value adjusted for column 'c17' at row 1 +Warning 1264 Out of range value for column 'c16' at row 1 +Warning 1264 Out of range value for column 'c17' at row 1 Warnings: -Warning 1264 Out of range value adjusted for column 'c13' at row 1 -Warning 1264 Out of range value adjusted for column 'c14' at row 1 +Warning 1264 Out of range value for column 'c13' at row 1 +Warning 1264 Out of range value for column 'c14' at row 1 Warning 1265 Data truncated for column 'c15' at row 1 -Warning 1264 Out of range value adjusted for column 'c16' at row 1 -Warning 1264 Out of range value adjusted for column 'c17' at row 1 +Warning 1264 Out of range value for column 'c16' at row 1 +Warning 1264 Out of range value for column 'c17' at row 1 Warnings: -Warning 1264 Out of range value adjusted for column 'c13' at row 1 -Warning 1264 Out of range value adjusted for column 'c14' at row 1 +Warning 1264 Out of range value for column 'c13' at row 1 +Warning 1264 Out of range value for column 'c14' at row 1 Warning 1265 Data truncated for column 'c15' at row 1 -Warning 1264 Out of range value adjusted for column 'c16' at row 1 -Warning 1264 Out of range value adjusted for column 'c17' at row 1 +Warning 1264 Out of range value for column 'c16' at row 1 +Warning 1264 Out of range value for column 'c17' at row 1 Warnings: -Warning 1264 Out of range value adjusted for column 'c13' at row 1 -Warning 1264 Out of range value adjusted for column 'c14' at row 1 +Warning 1264 Out of range value for column 'c13' at row 1 +Warning 1264 Out of range value for column 'c14' at row 1 Warning 1265 Data truncated for column 'c15' at row 1 -Warning 1264 Out of range value adjusted for column 'c16' at row 1 -Warning 1264 Out of range value adjusted for column 'c17' at row 1 +Warning 1264 Out of range value for column 'c16' at row 1 +Warning 1264 Out of range value for column 'c17' at row 1 Warnings: Warning 1265 Data truncated for column 'c15' at row 1 -Warning 1264 Out of range value adjusted for column 'c16' at row 1 -Warning 1264 Out of range value adjusted for column 'c17' at row 1 +Warning 1264 Out of range value for column 'c16' at row 1 +Warning 1264 Out of range value for column 'c17' at row 1 Warnings: Warning 1265 Data truncated for column 'c15' at row 1 -Warning 1264 Out of range value adjusted for column 'c16' at row 1 -Warning 1264 Out of range value adjusted for column 'c17' at row 1 +Warning 1264 Out of range value for column 'c16' at row 1 +Warning 1264 Out of range value for column 'c17' at row 1 Warnings: Warning 1265 Data truncated for column 'c15' at row 1 -Warning 1264 Out of range value adjusted for column 'c16' at row 1 -Warning 1264 Out of range value adjusted for column 'c17' at row 1 +Warning 1264 Out of range value for column 'c16' at row 1 +Warning 1264 Out of range value for column 'c17' at row 1 Warnings: Warning 1265 Data truncated for column 'c15' at row 1 -Warning 1264 Out of range value adjusted for column 'c16' at row 1 -Warning 1264 Out of range value adjusted for column 'c17' at row 1 +Warning 1264 Out of range value for column 'c16' at row 1 +Warning 1264 Out of range value for column 'c17' at row 1 select c1, c13, c14, c15, c16, c17 from t9 order by c1 ; c1 c13 c14 c15 c16 c17 20 1991-01-01 1991-01-01 01:01:01 1991-01-01 01:01:01 01:01:01 1991 |