/ Check-in [963eb24f]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix an incorrect testcase for the round() function. All tests are passing now, including new real->text->real round-trip tests.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | floating-point-conversions
Files: files | file ages | folders
SHA1:963eb24f737f184d5fcdcd92ebf90466f818cfd8
User & Date: drh 2012-06-19 03:59:30
Context
2012-06-19
04:36
Move variable declaration to fix compilation with MSVC. check-in: d45f7a01 user: mistachkin tags: floating-point-conversions
03:59
Fix an incorrect testcase for the round() function. All tests are passing now, including new real->text->real round-trip tests. check-in: 963eb24f user: drh tags: floating-point-conversions
03:35
Round-trip conversions of real->text->real are now lossless on x64 with GCC. Untested on other platforms so far. Still a corner-case problem with round(). check-in: fd7bd4a5 user: drh tags: floating-point-conversions
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/func.test.

   308    308     do_test func-4.36 {
   309    309       execsql {SELECT round(99999999999994.5);}
   310    310     } {99999999999995.0}
   311    311     do_test func-4.37 {
   312    312       execsql {SELECT round(9999999999999.55,1);}
   313    313     } {9999999999999.6}
   314    314     do_test func-4.38 {
   315         -    execsql {SELECT round(9999999999999.555,2);}
          315  +    execsql {SELECT round(9999999999999.556,2);}
   316    316     } {9999999999999.56}
   317    317   }
   318    318   
   319    319   # Test the upper() and lower() functions
   320    320   #
   321    321   do_test func-5.1 {
   322    322     execsql {SELECT upper(t1) FROM tbl1}