DROP TABLE IF EXISTS `t1_2`;
Warnings:
Note	1051	Unknown table 't1_2'
CREATE TABLE `t1_2` (
`aux1` bigint(20) default NULL,
`aux2` bigint(20) default NULL,
`my_bigint` bigint(20) default NULL,
`my_varchar` varchar(50) default NULL,
`my_bit` tinyint(1) default NULL,
`my_decimal_64` decimal(64,30) default NULL,
`my_decimal_big` decimal(100,0) default NULL,
KEY `I1_my_decimal_64_1_2` (`my_decimal_64`),
KEY `I2_my_decimal_64_1_2` (`my_decimal_64`,`aux1`),
KEY `I3_my_decimal_64_1_2` (`aux2`,`my_decimal_64`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `t1_2` VALUES 
(10001,10001,9223372036854775807, '12345678901234567890123456789012345678901234567890',127,
'10000000000000001761595319084122112.000000000000000000000000000000',
'10000000000000000470601344959054695891559601407866630764278709534898249531392'),
(10001,10001,9223372036854775807,'12345678901234567890123456789012345678901234567890',127,
'10000000000000000608673814477275136.000000000000000000000000000000',
'10000000000000000470601344959054695891559601407866630764278709534898249531392');
SELECT my_decimal_64, my_bigint FROM t1_2;
my_decimal_64	my_bigint
10000000000000001761595319084122112.000000000000000000000000000000	9223372036854775807
10000000000000000608673814477275136.000000000000000000000000000000	9223372036854775807
SELECT my_decimal_64
FROM t1_2 FORCE INDEX(I1_my_decimal_64_1_2)
WHERE my_decimal_64 = 9999999999999999999999999999999999.999999999999999999999999999999 ;
my_decimal_64
10000000000000001761595319084122112.000000000000000000000000000000
SELECT my_decimal_64
FROM t1_2 FORCE INDEX(I2_my_decimal_64_1_2)
WHERE my_decimal_64 = 9999999999999999999999999999999999.999999999999999999999999999999 ;
my_decimal_64
10000000000000001761595319084122112.000000000000000000000000000000
SELECT my_decimal_64
FROM t1_2 FORCE INDEX(I3_my_decimal_64_1_2)
WHERE my_decimal_64 = 9999999999999999999999999999999999.999999999999999999999999999999 ;
my_decimal_64
10000000000000000608673814477275136.000000000000000000000000000000
10000000000000001761595319084122112.000000000000000000000000000000
SELECT my_decimal_64
FROM t1_2 FORCE INDEX(I1_my_decimal_64_1_2)
WHERE my_decimal_64 BETWEEN 9999999999999999999999999999999999.999999999999999999999999999999 * (1 - 1.0E-15)
AND 9999999999999999999999999999999999.999999999999999999999999999999 * (1 + 1.0E-15);
my_decimal_64
10000000000000000608673814477275136.000000000000000000000000000000
10000000000000001761595319084122112.000000000000000000000000000000
SELECT my_decimal_64
FROM t1_2 FORCE INDEX(I2_my_decimal_64_1_2)
WHERE my_decimal_64 BETWEEN 9999999999999999999999999999999999.999999999999999999999999999999 * (1 - 1.0E-15)
AND 9999999999999999999999999999999999.999999999999999999999999999999 * (1 + 1.0E-15);
my_decimal_64
10000000000000000608673814477275136.000000000000000000000000000000
10000000000000001761595319084122112.000000000000000000000000000000
SELECT my_decimal_64
FROM t1_2 FORCE INDEX(I3_my_decimal_64_1_2)
WHERE my_decimal_64 BETWEEN 9999999999999999999999999999999999.999999999999999999999999999999 * (1 - 1.0E-15)
AND 9999999999999999999999999999999999.999999999999999999999999999999 * (1 + 1.0E-15);
my_decimal_64
10000000000000000608673814477275136.000000000000000000000000000000
10000000000000001761595319084122112.000000000000000000000000000000
DROP INDEX I1_my_decimal_64_1_2 ON t1_2;
DROP INDEX I2_my_decimal_64_1_2 ON t1_2;
DROP INDEX I3_my_decimal_64_1_2 ON t1_2;
SELECT my_decimal_64
FROM t1_2
WHERE my_decimal_64 = 9999999999999999999999999999999999.999999999999999999999999999999 ;
my_decimal_64
10000000000000001761595319084122112.000000000000000000000000000000
10000000000000000608673814477275136.000000000000000000000000000000
SELECT my_decimal_64
FROM t1_2
WHERE my_decimal_64 BETWEEN 9999999999999999999999999999999999.999999999999999999999999999999 * (1 - 1.0E-15)
AND 9999999999999999999999999999999999.999999999999999999999999999999 * (1 + 1.0E-15);
my_decimal_64
10000000000000001761595319084122112.000000000000000000000000000000
10000000000000000608673814477275136.000000000000000000000000000000