gistfile1.txt

    def nan_infinity_test(self):
        cursor = self.prepare()

        cursor.execute("CREATE TABLE test (f float PRIMARY KEY)")

        cursor.execute("INSERT INTO test(f) VALUES (NaN)")
        cursor.execute("INSERT INTO test(f) VALUES (-NaN)")
        cursor.execute("INSERT INTO test(f) VALUES (Infinity)")
        cursor.execute("INSERT INTO test(f) VALUES (-Infinity)")

        assert_all(cursor, "SELECT * FROM test",
                   [[float("nan")], [float("inf")], [float("-inf")]])

gistfile2.txt

-> assert list_res == expected, "Expected %s from %s, but got %s" % (expected, query, list_res)
(Pdb) list_res
[[nan], [inf], [-inf]]
(Pdb) list_res[0][0]
nan
(Pdb) list_res[0][0]
nan
(Pdb) expected[0][0]
nan
(Pdb) list_res[0][0] == expected[0][0]
False

gistfile3.txt

>>> float('nan') == float('nan')
False