From 4f59995242d894baa041a8171d420a18b43ceb8c Mon Sep 17 00:00:00 2001
From: Boris Kolpackov <boris@codesynthesis.com>
Date: Wed, 18 Jul 2012 12:07:19 +0200
Subject: Convert NULLs to NaNs in SQLite for float and double

This makes it consistent with SQLite behavior which converts NaNs to NULLs.
---
 sqlite/types/test.hxx | 16 ++++++++++------
 1 file changed, 10 insertions(+), 6 deletions(-)

(limited to 'sqlite/types/test.hxx')

diff --git a/sqlite/types/test.hxx b/sqlite/types/test.hxx
index 6d9fc1c..7ed1a8c 100644
--- a/sqlite/types/test.hxx
+++ b/sqlite/types/test.hxx
@@ -29,24 +29,27 @@ struct object
   #pragma db id
   unsigned long id_;
 
-  #pragma db type ("BOOL")
+  #pragma db type("BOOL")
   bool bool_;
 
-  #pragma db type ("INTEGER")
+  #pragma db type("INTEGER")
   int integer_;
 
-  #pragma db type ("REAL")
+  #pragma db type("REAL")
   double real_;
 
-  #pragma db type ("TEXT")
+  #pragma db type("REAL") null
+  double nan_;
+
+  #pragma db type("TEXT")
   std::string text_;
 
-  #pragma db type ("BLOB")
+  #pragma db type("BLOB")
   std::vector<char> blob_;
 
   // Test NULL value.
   //
-  #pragma db type ("TEXT") null
+  #pragma db type("TEXT") null
   string_ptr null_;
 
   bool
@@ -57,6 +60,7 @@ struct object
       bool_ == y.bool_ &&
       integer_ == y.integer_ &&
       real_ == y.real_ &&
+      nan_ != nan_ &&
       text_ == y.text_ &&
       blob_ == y.blob_ &&
       ((null_.get () == 0 && y.null_.get () == 0) || *null_ == *y.null_);
-- 
cgit v1.1