Lines Matching refs:affinity

176 # This next block of tests - in3-3.* - verify that column affinity is
189     CREATE UNIQUE INDEX t1_i1 ON t1(a);        /* no affinity */
190     CREATE UNIQUE INDEX t1_i2 ON t1(b);        /* numeric affinity */
191     CREATE UNIQUE INDEX t1_i3 ON t1(c);        /* text affinity */
194     CREATE UNIQUE INDEX t2_i1 ON t2(x);        /* no affinity */
195     CREATE UNIQUE INDEX t2_i2 ON t2(y);        /* numeric affinity */
196     CREATE UNIQUE INDEX t2_i3 ON t2(z);        /* text affinity */
204   # No affinity is applied before comparing "x" and "a". Therefore
209   # Logically, numeric affinity is applied to both sides before 
214   # No affinity is applied before the comparison takes place. Making
220   # Numeric affinity should be applied to each side before the comparison
221   # takes place. Therefore we cannot use index t1_i1, which has no affinity.
225   # Numeric affinity is applied to both sides before 
230   # Numeric affinity is applied before the comparison takes place.