.read bug

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

.read bug

DONALD LEUNG
hello,

.read name.sql has a bug for mac os x 10.10 for the latest edition of SQLITE on Jan 20th


I can confirm that I have created table C.


INPUT

From Script.sql in home folder with database.db file

INSERT INTO "C” (Names) VALUES (‘Al‘);
INSERT INTO "C” (Names) VALUES (‘Ale‘);



OUTPUT:

copying and pasting into sqlite3 error

Error: near line 1: no such table: “C”
Error: near line 2: no such column: ‘Al‘
Error: near line 3: no such column: ‘Ale‘
Error: near line 4: no such column: ‘Andy‘
Error: near line 5: near "‘": syntax error
Error: near line 6: no such column: ‘Anti'
Error: near line 7: no such column: ‘Atina‘
Error: near line 8: no such column: ‘Armen‘
Error: near line 9: no such column: ‘Austy‘
Error: near line 10: no such column: ‘Azer‘
Error: near line 11:
Error: incomplete SQL: INSERT INTO "C” (Names) VALUES (‘Candy’);



—————
Another thing is when I copy and paste from OS X sqlite3, the script:
INSERT INTO “C” (Names) VALUE (‘names’);

the paste looks turns out different, and becomes INSERT INTO “C” (Names) VALUE  );’names’ (

Please tell me what to do and how to fix.


d

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: .read bug

Stephan Beal-3
The problem is that you are using unusual quotes. Use only standard
double-quotes for identifiers and single-quotes for strings. Your example
uses "fancy" quotes commonly seen in word processors.

----- stephan
Sent from a mobile device, possibly from bed. Please excuse brevity, typos,
and top-posting.
On Jan 21, 2016 14:18, "DONALD LEUNG" <[hidden email]> wrote:

> hello,
>
> .read name.sql has a bug for mac os x 10.10 for the latest edition of
> SQLITE on Jan 20th
>
>
> I can confirm that I have created table C.
>
>
> INPUT
>
> From Script.sql in home folder with database.db file
>
> INSERT INTO "C” (Names) VALUES (‘Al‘);
> INSERT INTO "C” (Names) VALUES (‘Ale‘);
>
>
>
> OUTPUT:
>
> copying and pasting into sqlite3 error
>
> Error: near line 1: no such table: “C”
> Error: near line 2: no such column: ‘Al‘
> Error: near line 3: no such column: ‘Ale‘
> Error: near line 4: no such column: ‘Andy‘
> Error: near line 5: near "‘": syntax error
> Error: near line 6: no such column: ‘Anti'
> Error: near line 7: no such column: ‘Atina‘
> Error: near line 8: no such column: ‘Armen‘
> Error: near line 9: no such column: ‘Austy‘
> Error: near line 10: no such column: ‘Azer‘
> Error: near line 11:
> Error: incomplete SQL: INSERT INTO "C” (Names) VALUES (‘Candy’);
>
>
>
> —————
> Another thing is when I copy and paste from OS X sqlite3, the script:
> INSERT INTO “C” (Names) VALUE (‘names’);
>
> the paste looks turns out different, and becomes INSERT INTO “C” (Names)
> VALUE  );’names’ (
>
> Please tell me what to do and how to fix.
>
>
> d
>
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users