SeaweedFS is a distributed storage system for object storage (S3), file systems, Iceberg table buckets, and Lance vector buckets, designed to handle billions of files with O(1) disk access and effortless horizontal scaling.
Go blob-storagecloud-drivedistributed-file-systemdistributed-storageerasure-codingfusehadoop-hdfshdfskuberneteslancelancedbobject-storageposixs3s3-storageseaweedfstiered-file-systemvector-search
package engine
import (
"context"
"testing"
)
// TestArithmeticWithFunctions tests arithmetic operations with function calls
// This validates the complete AST parser and evaluation system for column-level calculations
func TestArithmeticWithFunctions(t *testing.T) {
engine := NewTestSQLEngine()
testCases := []struct {
name string
sql string
expected string
desc string
}{
{
name: "Simple function arithmetic",
sql: "SELECT LENGTH('hello') + 10 FROM user_events LIMIT 1",
expected: "15",
desc: "Basic function call with addition",
},
{
name: "Nested functions with arithmetic",
sql: "SELECT length(trim(' hello world ')) + 12 FROM user_events LIMIT 1",
expected: "23",
desc: "Complex nested functions with arithmetic operation (user's original failing query)",
},
{
name: "Function subtraction",
sql: "SELECT LENGTH('programming') - 5 FROM user_events LIMIT 1",
expected: "6",
desc: "Function call with subtraction",
},
{
name: "Function multiplication",
sql: "SELECT LENGTH('test') * 3 FROM user_events LIMIT 1",
expected: "12",
desc: "Function call with multiplication",
},
{
name: "Multiple nested functions",
sql: "SELECT LENGTH(UPPER(TRIM(' hello '))) FROM user_events LIMIT 1",
expected: "5",
desc: "Triple nested functions",
},
}
for _, tc := range testCases {
t.Run(tc.name, func(t *testing.T) {
result, err := engine.ExecuteSQL(context.Background(), tc.sql)
if err != nil {
t.Errorf("Query failed: %v", err)
return
}
if result.Error != nil {
t.Errorf("Query result error: %v", result.Error)
return
}
if len(result.Rows) == 0 {
t.Error("Expected at least one row")
return
}
actual := result.Rows[0][0].ToString()
if actual != tc.expected {
t.Errorf("%s: Expected '%s', got '%s'", tc.desc, tc.expected, actual)
} else {
t.Logf("PASS %s: %s → %s", tc.desc, tc.sql, actual)
}
})
}
}