DuckDB failed with `near "~": syntax error` while creating a view with a string-like operation.
- Dominant language
- C
- Stars
- 291
- Forks
- 45
- Avg merge
- 10h 13m
- Merged PRs (30d)
- 18
Description
### What happens?
Error:
```
Invalid Error:
Failed to execute query "CREATE VIEW foo_view AS SELECT * FROM foo WHERE (baz ~~ '%')": near "~": syntax error
```
### To Reproduce
Command:
```
sqlite3 test.db "create table foo(baz text);";
duckdb test.db "create view foo_view as select * from foo where baz like '%'; select * from foo_view;"
```
### OS:
Linux
### SQLite Version:
3.45.3
### DuckDB Version:
v1.3.0
### DuckDB Client:
CLI
### Full Name:
Weihao Wang
### Affiliation:
Beijing Jiaotong University
### Have you tried this on the latest `main` branch?
- [x] I agree
### Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?
- [x] I agree
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.