Failed to resolve the where condition

[Scholar-Li]

	query = `select date, path, splitByChar('/', path)[2] as path_b
from(
	select 'pathA/pathB/pathC' as path, '2024-09-10' as date
) 
where toDate(date) = '2024-09-01' and '2024-09-30'
and splitByChar('/', path)[1] = 'pathA'`
	parser := clickhouse.NewParser(strings.TrimSpace(query))

	// Parse query into AST
	statements, err := parser.ParseStmts()
	if err != nil {
		panic(err.Error())
	}

Both where conditions will report errors.

 [recovered]
	panic: line 4:19 <EOF> or ';' was expected, but got: "between"
where toDate(date) between '2024-09-01' and '2024-09-30'

 [recovered]
	panic: line 5:30 <EOF> or ';' was expected, but got: "="
and splitByChar('/', path)[1] = 'pathA'

[git-hulk]

@Scholar-Li Thanks for your report, will fix it soon.