Description:
Two identical Falcon servers are unable to agree on the correct result for queries on FLOAT and DOUBLE field types.
So far, this failire is most pronounced on the Windows PB2 machine, test falcon_compare_self, and the binary produced from that machine, however it may not be platform or endian-related at all.
No transactions, indexes or LIMIT is involved.
How to repeat:
RQG YY file:
query:
select | update;
select:
SELECT * FROM _table WHERE _field sign value ;
update:
UPDATE _table SET _field = value WHERE _field sign value ;
sign:
< | > | = ;
value:
_year ;
RQG ZZ file:
$tables = {
pk => [ undef ]
};
$fields = {
types => [ 'float' ],
indexes => [ undef ],
sign => [ 'signed' ]
};
$data = {
numbers => [ 'year', 'tinyint'],
};
Command:
$ perl runall.pl \
--basedir=c:/sources/mysql-6.0.11-alpha-win-x86 \
--grammar=conf/bug.yy \
--gendata=conf/bug.zz \
--vardir1=c:/tmp/vardir/falcon-vardir1 \
--vardir2=c:/tmp/vardir/falcon-vardir2 \
--threads=1 \
--reporters= \
--duration=1200 \
--mysqld=--log-output=file \
--queries=100000 \
--engine=falcon
Description: Two identical Falcon servers are unable to agree on the correct result for queries on FLOAT and DOUBLE field types. So far, this failire is most pronounced on the Windows PB2 machine, test falcon_compare_self, and the binary produced from that machine, however it may not be platform or endian-related at all. No transactions, indexes or LIMIT is involved. How to repeat: RQG YY file: query: select | update; select: SELECT * FROM _table WHERE _field sign value ; update: UPDATE _table SET _field = value WHERE _field sign value ; sign: < | > | = ; value: _year ; RQG ZZ file: $tables = { pk => [ undef ] }; $fields = { types => [ 'float' ], indexes => [ undef ], sign => [ 'signed' ] }; $data = { numbers => [ 'year', 'tinyint'], }; Command: $ perl runall.pl \ --basedir=c:/sources/mysql-6.0.11-alpha-win-x86 \ --grammar=conf/bug.yy \ --gendata=conf/bug.zz \ --vardir1=c:/tmp/vardir/falcon-vardir1 \ --vardir2=c:/tmp/vardir/falcon-vardir2 \ --threads=1 \ --reporters= \ --duration=1200 \ --mysqld=--log-output=file \ --queries=100000 \ --engine=falcon