Function test_sign

src/functions/math_functions.rs:487–511

()

    
    #[test]
    fn test_sign() {
        let conn = Connection::open_in_memory().unwrap();
        register_math_functions(&conn).unwrap();
        
        let result: f64 = conn.query_row(
            "SELECT sign(5.5)",
            [],
            |row| row.get(0)
        ).unwrap();
        assert_eq!(result, 1.0);
        
        let result: f64 = conn.query_row(
            "SELECT sign(-3.2)",
            [],
            |row| row.get(0)
        ).unwrap();
        assert_eq!(result, -1.0);
        
        let result: f64 = conn.query_row(
            "SELECT sign(0.0)",
            [],
            |row| row.get(0)
        ).unwrap();
        assert_eq!(result, 0.0);
    }
    
    #[test]
    fn test_power_sqrt() {