← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_in.test

  • Committer: Brian Aker
  • Date: 2008-10-02 19:18:43 UTC
  • mto: (438.4.1 drizzle-clean-code)
  • mto: This revision was merged to the branch mainline in revision 435.
  • Revision ID: brian@tangent.org-20081002191843-tw3nnufik8qwf9rz
Removed UNSIGNED from parser.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/func_in.test
237
237
#   "unsigned_keypart NOT IN(negative_number,...)" 
238
238
#   (introduced in fix BUG#15872) 
239
239
create table t1 (
240
 
  some_id int(5) unsigned,
 
240
  some_id int(5),
241
241
  key (some_id)
242
242
);
243
243
insert into t1 values (1),(2);
246
246
select some_id from t1 where some_id not in(-4,-1,3423534,2342342);
247
247
 
248
248
#
249
 
# BUG#24261: crash when WHERE contains NOT IN ('<negative value>') for unsigned column type
 
249
# BUG#24261: crash when WHERE contains NOT IN ('<negative value>') for column type
250
250
#
251
251
 
252
252
select some_id from t1 where some_id not in('-1', '0');
292
292
DROP TABLE t1,t2,t3,t4;  
293
293
 
294
294
#
295
 
# BUG#19342: IN works incorrectly for BIGINT UNSIGNED values
 
295
# BUG#19342: IN works incorrectly for BIGINT values
296
296
#
297
297
CREATE TABLE t1(a BIGINT UNSIGNED);
298
298
INSERT INTO t1 VALUES (0xFFFFFFFFFFFFFFFF);