duckdb / duckdb/duckdb-sqlite

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

Open
#155 0 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.