Function test_split_part

src/functions/string_functions.rs:274–300

()

    
    #[test]
    fn test_split_part() {
        let conn = Connection::open_in_memory().unwrap();
        register_string_functions(&conn).unwrap();
        
        let result: String = conn.query_row(
            "SELECT split_part('abc,def,ghi', ',', 2)",
            [],
            |row| row.get(0)
        ).unwrap();
        assert_eq!(result, "def");
        
        // Test out of bounds
        let result: String = conn.query_row(
            "SELECT split_part('abc,def,ghi', ',', 5)",
            [],
            |row| row.get(0)
        ).unwrap();
        assert_eq!(result, "");
        
        // Test negative index
        let result: String = conn.query_row(
            "SELECT split_part('abc,def,ghi', ',', -1)",
            [],
            |row| row.get(0)
        ).unwrap();
        assert_eq!(result, "");
    }
    
    #[test]
    fn test_translate() {