DuckDB failed with `near "~": syntax error` while creating a view with a string-like operation.

[wayhoowang]

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?

• 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?

• I agree