single quote and double quote

mithrandie / csvq

SQL-like query language for csv

https://mithrandie.github.io/csvq

MIT License

1.5k stars 65 forks source link

Closed alitrack closed 4 years ago

alitrack commented 4 years ago

Version 1.13.3

create table winsales(
salesid,
dateid,
sellerid,
buyerid,
qty,
qty_shipped);

insert into winsales values(30001, '8/2/2003', 3, 'b', 10, 10);

got error

[L:1 C:49] field b does not exist

insert into winsales values(30001, '8/2/2003', 3, "b", 10, 10);

got

30001,0.00199700449326011,3,b,10,10

insert into winsales values(30001, "8/2/2003", 3, "b", 10, 10);

got what I want.

both are correct

select "3+5"

select '3+5'

mithrandie commented 4 years ago

On my system, it seems to be working well.

Can you tell me about the following information?

OS and the version.
How to install csvq. (Whether you downloaded the binary, used a package manager, or built it yourself?)
How to execute the query. (Whether it was executed as a command argument, in the REPL, or by loading the file with the SOURCE command)

alitrack commented 4 years ago

I just tested on macOS terminal, it works,

this issue I met is jupyter notebook, maybe is the issue of jupyter notebook, let me check it again.