Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-41018

DuckDB fails with WHERE condition using double quotes

    XMLWordPrintable

Details

    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

          Activity

            People

              drrtuy Roman
              f.bosch@genkgo.nl Frederik Bosch
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.