SQLite: Check-in [963eb24f]

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}