[BUG] query error on Editor

[wldbest]

Describe the bug

SELECT id, glyph FROM emojis WHERE glyph = "🇨🇶";
Makes error
'non terminated literal'

It works on the main row list filtering, but not works in the SQL Query Editor.

Platform and Database

libsql(Turso) up-to-date version
windows 10

[wyhaya]

Hi @wldbest , Thank you for your feedback! Could you provide more detailed information?

I am unable to reproduce this error.

CREATE TABLE emojis (id integer PRIMARY KEY, glyph text);
SELECT id, glyph FROM emojis WHERE glyph = "🇨🇶";
-- No error

[wldbest]

Hi, check about this:

CREATE TABLE emojis3 (id integer PRIMARY KEY, glyph text, glyph_2 text);
SELECT id, glyph FROM emojis WHERE glyph = "🇨🇶";