\set ECHO none ok 1..0 1..174 ok 1 - No NULL variants ok 2 - Verify result of cast '{-1.1,-1.1,1.1}'::float[] ok 3 - Verify result of cast '{-1.1,0.1,1.1}'::float[] ok 4 - Verify result of cast '{-1.1,1.1,1.1}'::float[] ok 5 - Verify result of cast '{NULL,-1.1,1.1}'::float[] ok 6 - Verify result of cast '{NULL,0.1,1.1}'::float[] ok 7 - Verify result of cast '{NULL,1.1,1.1}'::float[] ok 8 - Verify result of cast '{-1.1,NULL,1.1}'::float[] ok 9 - Verify result of cast NULL::float[] ok 10 - SET base_variant_b ok 11 - Verify text_in(text_out()) works for ("double precision[]","{-1.1,-1.1,1.1}") ok 12 - Verify text_in(text_out()) works for ("double precision[]","{-1.1,0.1,1.1}") ok 13 - Verify text_in(text_out()) works for ("double precision[]","{-1.1,1.1,1.1}") ok 14 - Verify text_in(text_out()) works for ("double precision[]","{NULL,-1.1,1.1}") ok 15 - Verify text_in(text_out()) works for ("double precision[]","{NULL,0.1,1.1}") ok 16 - Verify text_in(text_out()) works for ("double precision[]","{NULL,1.1,1.1}") ok 17 - Verify text_in(text_out()) works for ("double precision[]","{-1.1,NULL,1.1}") ok 18 - Verify text_in(text_out()) works for ("double precision[]",) ok 19 ok 20 ok 21 ok 22 ok 23 ok 24 ok 25 ok 26 ok 27 - No NULL variants ok 28 - Verify result of cast '{-1.1,0.1,1.1}'::float[] ok 29 - SET compare_variant_b ok 30 - Verify text_in(text_out()) works for ("double precision[]","{-1.1,0.1,1.1}") ok 31 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] < '{-1.1,-1.1,1.1}'::float[] ok 32 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] < '{-1.1,0.1,1.1}'::float[] ok 33 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] < '{-1.1,1.1,1.1}'::float[] ok 34 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] < '{-1.1,NULL,1.1}'::float[] ok 35 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] < '{NULL,-1.1,1.1}'::float[] ok 36 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] < '{NULL,0.1,1.1}'::float[] ok 37 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] < '{NULL,1.1,1.1}'::float[] ok 38 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] < NULL::float[] ok 39 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] <= '{-1.1,-1.1,1.1}'::float[] ok 40 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] <= '{-1.1,0.1,1.1}'::float[] ok 41 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] <= '{-1.1,1.1,1.1}'::float[] ok 42 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] <= '{-1.1,NULL,1.1}'::float[] ok 43 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] <= '{NULL,-1.1,1.1}'::float[] ok 44 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] <= '{NULL,0.1,1.1}'::float[] ok 45 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] <= '{NULL,1.1,1.1}'::float[] ok 46 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] <= NULL::float[] ok 47 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] = '{-1.1,-1.1,1.1}'::float[] ok 48 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] = '{-1.1,0.1,1.1}'::float[] ok 49 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] = '{-1.1,1.1,1.1}'::float[] ok 50 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] = '{-1.1,NULL,1.1}'::float[] ok 51 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] = '{NULL,-1.1,1.1}'::float[] ok 52 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] = '{NULL,0.1,1.1}'::float[] ok 53 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] = '{NULL,1.1,1.1}'::float[] ok 54 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] = NULL::float[] ok 55 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] >= '{-1.1,-1.1,1.1}'::float[] ok 56 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] >= '{-1.1,0.1,1.1}'::float[] ok 57 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] >= '{-1.1,1.1,1.1}'::float[] ok 58 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] >= '{-1.1,NULL,1.1}'::float[] ok 59 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] >= '{NULL,-1.1,1.1}'::float[] ok 60 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] >= '{NULL,0.1,1.1}'::float[] ok 61 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] >= '{NULL,1.1,1.1}'::float[] ok 62 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] >= NULL::float[] ok 63 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] > '{-1.1,-1.1,1.1}'::float[] ok 64 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] > '{-1.1,0.1,1.1}'::float[] ok 65 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] > '{-1.1,1.1,1.1}'::float[] ok 66 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] > '{-1.1,NULL,1.1}'::float[] ok 67 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] > '{NULL,-1.1,1.1}'::float[] ok 68 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] > '{NULL,0.1,1.1}'::float[] ok 69 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] > '{NULL,1.1,1.1}'::float[] ok 70 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] > NULL::float[] ok 71 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] != '{-1.1,-1.1,1.1}'::float[] ok 72 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] != '{-1.1,0.1,1.1}'::float[] ok 73 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] != '{-1.1,1.1,1.1}'::float[] ok 74 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] != '{-1.1,NULL,1.1}'::float[] ok 75 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] != '{NULL,-1.1,1.1}'::float[] ok 76 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] != '{NULL,0.1,1.1}'::float[] ok 77 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] != '{NULL,1.1,1.1}'::float[] ok 78 - check casted vs uncasted for '{-1.1,0.1,1.1}'::float[] != NULL::float[] ok 79 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] < '{-1.1,-1.1,1.1}'::float[] ok 80 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] < '{-1.1,0.1,1.1}'::float[] ok 81 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] < '{-1.1,1.1,1.1}'::float[] ok 82 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] < '{-1.1,NULL,1.1}'::float[] ok 83 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] < '{NULL,-1.1,1.1}'::float[] ok 84 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] < '{NULL,0.1,1.1}'::float[] ok 85 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] < '{NULL,1.1,1.1}'::float[] ok 86 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] < NULL::float[] ok 87 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] <= '{-1.1,-1.1,1.1}'::float[] ok 88 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] <= '{-1.1,0.1,1.1}'::float[] ok 89 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] <= '{-1.1,1.1,1.1}'::float[] ok 90 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] <= '{-1.1,NULL,1.1}'::float[] ok 91 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] <= '{NULL,-1.1,1.1}'::float[] ok 92 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] <= '{NULL,0.1,1.1}'::float[] ok 93 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] <= '{NULL,1.1,1.1}'::float[] ok 94 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] <= NULL::float[] ok 95 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] = '{-1.1,-1.1,1.1}'::float[] ok 96 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] = '{-1.1,0.1,1.1}'::float[] ok 97 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] = '{-1.1,1.1,1.1}'::float[] ok 98 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] = '{-1.1,NULL,1.1}'::float[] ok 99 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] = '{NULL,-1.1,1.1}'::float[] ok 100 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] = '{NULL,0.1,1.1}'::float[] ok 101 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] = '{NULL,1.1,1.1}'::float[] ok 102 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] = NULL::float[] ok 103 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] >= '{-1.1,-1.1,1.1}'::float[] ok 104 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] >= '{-1.1,0.1,1.1}'::float[] ok 105 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] >= '{-1.1,1.1,1.1}'::float[] ok 106 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] >= '{-1.1,NULL,1.1}'::float[] ok 107 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] >= '{NULL,-1.1,1.1}'::float[] ok 108 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] >= '{NULL,0.1,1.1}'::float[] ok 109 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] >= '{NULL,1.1,1.1}'::float[] ok 110 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] >= NULL::float[] ok 111 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] > '{-1.1,-1.1,1.1}'::float[] ok 112 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] > '{-1.1,0.1,1.1}'::float[] ok 113 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] > '{-1.1,1.1,1.1}'::float[] ok 114 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] > '{-1.1,NULL,1.1}'::float[] ok 115 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] > '{NULL,-1.1,1.1}'::float[] ok 116 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] > '{NULL,0.1,1.1}'::float[] ok 117 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] > '{NULL,1.1,1.1}'::float[] ok 118 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] > NULL::float[] ok 119 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] != '{-1.1,-1.1,1.1}'::float[] ok 120 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] != '{-1.1,0.1,1.1}'::float[] ok 121 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] != '{-1.1,1.1,1.1}'::float[] ok 122 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] != '{-1.1,NULL,1.1}'::float[] ok 123 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] != '{NULL,-1.1,1.1}'::float[] ok 124 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] != '{NULL,0.1,1.1}'::float[] ok 125 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] != '{NULL,1.1,1.1}'::float[] ok 126 - check variant vs uncasted for '{-1.1,0.1,1.1}'::float[] != NULL::float[] ok 127 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' < '''{-1.1,-1.1,1.1}''::float[]' ok 128 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' < '''{-1.1,0.1,1.1}''::float[]' ok 129 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' < '''{-1.1,1.1,1.1}''::float[]' ok 130 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' < '''{-1.1,NULL,1.1}''::float[]' ok 131 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' < '''{NULL,-1.1,1.1}''::float[]' ok 132 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' < '''{NULL,0.1,1.1}''::float[]' ok 133 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' < '''{NULL,1.1,1.1}''::float[]' ok 134 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' < 'NULL::float[]' ok 135 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' <= '''{-1.1,-1.1,1.1}''::float[]' ok 136 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' <= '''{-1.1,0.1,1.1}''::float[]' ok 137 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' <= '''{-1.1,1.1,1.1}''::float[]' ok 138 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' <= '''{-1.1,NULL,1.1}''::float[]' ok 139 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' <= '''{NULL,-1.1,1.1}''::float[]' ok 140 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' <= '''{NULL,0.1,1.1}''::float[]' ok 141 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' <= '''{NULL,1.1,1.1}''::float[]' ok 142 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' <= 'NULL::float[]' ok 143 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' = '''{-1.1,-1.1,1.1}''::float[]' ok 144 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' = '''{-1.1,0.1,1.1}''::float[]' ok 145 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' = '''{-1.1,1.1,1.1}''::float[]' ok 146 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' = '''{-1.1,NULL,1.1}''::float[]' ok 147 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' = '''{NULL,-1.1,1.1}''::float[]' ok 148 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' = '''{NULL,0.1,1.1}''::float[]' ok 149 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' = '''{NULL,1.1,1.1}''::float[]' ok 150 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' = 'NULL::float[]' ok 151 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' >= '''{-1.1,-1.1,1.1}''::float[]' ok 152 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' >= '''{-1.1,0.1,1.1}''::float[]' ok 153 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' >= '''{-1.1,1.1,1.1}''::float[]' ok 154 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' >= '''{-1.1,NULL,1.1}''::float[]' ok 155 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' >= '''{NULL,-1.1,1.1}''::float[]' ok 156 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' >= '''{NULL,0.1,1.1}''::float[]' ok 157 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' >= '''{NULL,1.1,1.1}''::float[]' ok 158 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' >= 'NULL::float[]' ok 159 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' > '''{-1.1,-1.1,1.1}''::float[]' ok 160 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' > '''{-1.1,0.1,1.1}''::float[]' ok 161 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' > '''{-1.1,1.1,1.1}''::float[]' ok 162 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' > '''{-1.1,NULL,1.1}''::float[]' ok 163 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' > '''{NULL,-1.1,1.1}''::float[]' ok 164 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' > '''{NULL,0.1,1.1}''::float[]' ok 165 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' > '''{NULL,1.1,1.1}''::float[]' ok 166 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' > 'NULL::float[]' ok 167 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' != '''{-1.1,-1.1,1.1}''::float[]' ok 168 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' != '''{-1.1,0.1,1.1}''::float[]' ok 169 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' != '''{-1.1,1.1,1.1}''::float[]' ok 170 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' != '''{-1.1,NULL,1.1}''::float[]' ok 171 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' != '''{NULL,-1.1,1.1}''::float[]' ok 172 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' != '''{NULL,0.1,1.1}''::float[]' ok 173 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' != '''{NULL,1.1,1.1}''::float[]' ok 174 - check variant vs casted for '''{-1.1,0.1,1.1}''::float[]' != 'NULL::float[]'