SET STORAGE_ENGINE = Falcon;
#
# Bug #22179: Falcon: decimal field has rounding errors
#
# See also: falcon_bug_225.test for similar test.
#
--echo *** Bug #22179 ***
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

CREATE TABLE t1 (a char(5) CHARACTER SET ucs2);
INSERT INTO t1 VALUES ('aa'), ('!'), ('aaa'), ('ab'), ('c');

CREATE INDEX i1 ON t1 (a);

SELECT * FROM t1 WHERE a LIKE '__a';
SELECT * FROM t1
  WHERE a = 'aa' OR a = '!' OR a = 'aaa' OR a = 'ab' OR a = 'c'
  ORDER BY a;
SELECT count(*) FROM t1;

# Final cleanup.
DROP TABLE t1;
