search

DataflareApp / Dataflare

Simple, easy-to-use database manager
https://dataflare.app
151 stars 2 forks source link

[BUG] query error on Editor #110

Open wldbest opened 3 weeks ago

wldbest commented 3 weeks ago

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 commented 3 weeks ago

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 commented 2 weeks ago

Hi, check about this:

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