sql-tests/inputs/comparator.sql

0001 -- binary type
0002 select x'00' < x'0f';
0003 select x'00' < x'ff';
0004
0005 -- trim string to numeric
0006 select '1 ' = 1Y;
0007 select '\t1 ' = 1Y;
0008 select '1 ' = 1S;
0009 select '1 ' = 1;
0010 select ' 1' = 1L;
0011 select ' 1' = cast(1.0 as float);
0012 select ' 1.0 ' = 1.0D;
0013 select ' 1.0 ' = 1.0BD;