~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/heap_hash.test

  • Committer: Brian Aker
  • Date: 2008-10-18 15:43:20 UTC
  • mto: (492.3.20 drizzle-clean-code)
  • mto: This revision was merged to the branch mainline in revision 530.
  • Revision ID: brian@tangent.org-20081018154320-jc9jyij3mdf08abp
Updating tests.

Show diffs side-by-side

added added

removed removed

Lines of Context:
268
268
# Check that HASH indexes disregard trailing spaces when comparing 
269
269
# strings with binary collations
270
270
 
271
 
CREATE TABLE t1(col1 VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, 
272
 
                col2 VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, 
 
271
CREATE TABLE t1(col1 VARCHAR(32) COLLATE utf8_bin NOT NULL, 
 
272
                col2 VARCHAR(32) COLLATE utf8_bin NOT NULL, 
273
273
                UNIQUE KEY key1 USING HASH (col1, col2)) ENGINE=MEMORY;
274
274
INSERT INTO t1 VALUES('A', 'A');
275
275
--error ER_DUP_ENTRY
276
276
INSERT INTO t1 VALUES('A ', 'A ');
277
277
DROP TABLE t1;
278
 
CREATE TABLE t1(col1 VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, 
279
 
                col2 VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, 
 
278
CREATE TABLE t1(col1 VARCHAR(32) COLLATE utf8_bin NOT NULL, 
 
279
                col2 VARCHAR(32) COLLATE utf8_bin NOT NULL, 
280
280
                UNIQUE KEY key1 USING HASH (col1, col2)) ENGINE=MEMORY;
281
281
INSERT INTO t1 VALUES('A', 'A');
282
282
--error ER_DUP_ENTRY