def test_float_types(
self,
metadata,
connection,
):
specs = [
(DOUBLE_PRECISION(), DOUBLE_PRECISION()),
(Double(), DOUBLE_PRECISION()),
(REAL(), REAL()),
(BINARY_DOUBLE(), BINARY_DOUBLE()),
(BINARY_FLOAT(), BINARY_FLOAT()),
(oracle.FLOAT(5), oracle.FLOAT(5)),
(
Float(5).with_variant(
oracle.FLOAT(binary_precision=16), "oracle"
),
oracle.FLOAT(16),
), # using conversion
(FLOAT(), DOUBLE_PRECISION()),
# from https://docs.oracle.com/cd/B14117_01/server.101/b10758/sqlqr06.htm # noqa: E501
# DOUBLE PRECISION == precision 126
# REAL == precision 63
(oracle.FLOAT(126), DOUBLE_PRECISION()),
(oracle.FLOAT(63), REAL()),
]
self._run_test(metadata, connection, specs, ["precision"])
def test_float_types(self):
specs = [
(DOUBLE_PRECISION(), FLOAT()),
# when binary_precision is supported
# (DOUBLE_PRECISION(), oracle.FLOAT(binary_precision=126)),
(BINARY_DOUBLE(), BINARY_DOUBLE()),
(BINARY_FLOAT(), BINARY_FLOAT()),
(FLOAT(5), FLOAT()),
# when binary_precision is supported
# (FLOAT(5), oracle.FLOAT(binary_precision=5),),
(FLOAT(), FLOAT()),
# when binary_precision is supported
# (FLOAT(5), oracle.FLOAT(binary_precision=126),),
]
self._run_test(specs, ["precision"])