()
| 96 | |
| 97 | #[test] |
| 98 | fn test_simple_join_aggregate() { |
| 99 | let conn = setup_test_db(); |
| 100 | |
| 101 | // First test simple aggregate with alias |
| 102 | let sql = "SELECT AVG(o.total) FROM orders o"; |
| 103 | let result = rewrite_query(&conn, sql).unwrap(); |
| 104 | println!("Simple alias aggregate rewritten to: {result}"); |
| 105 | assert!(result.contains("decimal_from_text")); |
| 106 | |
| 107 | // Then test join aggregate |
| 108 | let sql2 = "SELECT c.name, AVG(o.total) FROM customers c JOIN orders o ON c.id = o.customer_id GROUP BY c.name"; |
| 109 | let result2 = rewrite_query(&conn, sql2).unwrap(); |
| 110 | println!("Join aggregate rewritten to: {result2}"); |
| 111 | assert!(result2.contains("decimal_from_text")); |
| 112 | } |
| 113 | |
| 114 | #[test] |
| 115 | fn test_simple_subquery_in_select() { |
nothing calls this directly
no test coverage detected