Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.8.9
-
None
-
None
Description
CREATE TABLE invoice (
id UUID DEFAULT(uuid()) PRIMARY KEY,
product VARCHAR(64),
amount DECIMAL(12,2),
sold_at TIMESTAMP ) ENGINE=DuckDB DEFAULT CHARSET utf8mb4;
INSERT INTO invoice (product, amount, sold_at)
VALUES ('MariaDB mug', 12.00, NOW()),
('DuckDB sticker', 2.50, NOW()),
('Sea lion plush', 25.00, NOW()),
('DuckDB sticker', 2.50, NOW());
SELECT id, product, amount FROM invoice WHERE product = "MariaDB mug";
SQL Error [1296] [HY000]: (conn=23427) Got error 122 'Binder Error: Referenced column "MariaDB mug" not found in FROM clause!
Candidate bindings: "id"
LINE 1: SELECT id, product, amount FROM invoice WHERE product = "MariaDB mug"
' from DuckDB
Attachments
Issue Links
- is blocked by
-
MDEV-41105 DuckDB: parse forwarded MariaDB SQL using a custom PEG frontend
-
- Open
-