Bonsoir
J ai cr?? une base
Sqlite3 dbtest1.db
J ai cr?? une table
CREATE TABLE table 1 (idsas (5) PRIMARY KEY NOT NULL);
Je veux inporter un gros fichier 10000 lignes :
siren.txt sans ent?te ni nom de colonnes avec s?parateur de ; et un champ avec
4000 caracteres.
Je n y arrive pas pouvez vous m aider.
Merci pour votre r?ponse
Lucie
-------- Message original --------
Objet : Re: [sqlite] index broken by insert
De : Roman Fleysher
? : General Discussion of SQLite Database
Cc :
Dear Richard,
Dear Simon,
Dear SQLiters,
It is such a pleasure to deal with smart people. Pure joy. How quickly Simon
figured out the problem and how Richard narrowed it down and fixing it.
Thank you for the work around. I implemented my own, stupid, work around:
execute offending insert using 5 year old version of sqlite that we have on
our system.
How will i know the patch/new version is available? By checking ticket link?
Thank you,
Roman
Sent from my T-Mobile 4G LTE Device
-------- Original message --------
From: Richard Hipp <d...@sqlite.org>
Date: 05/19/2015 3:37 PM (GMT-05:00)
To: General Discussion of SQLite Database <sqlite-users at
mailinglists.sqlite.org>
Subject: Re: [sqlite] index broken by insert
On 5/19/15, Roman Fleysher <roman.fleysher at einstein.yu.edu> wrote:
> CREATE TRIGGER demographicInsert AFTER INSERT ON subject FOR EACH ROW BEGIN
> INSERT INTO Exam (subjectID, examID, examType) VALUES (NEW.subjectID,
> NEW.subjectID, 'demographicExam');
Your workaround is to change the insert into examID to cast it to type
TEXT. Like this:
.. VALUES(New.subjectID, CAST(New.subjectID AS TEXT), 'demographicExam');
This should be automatic. We are testing the bug fix now. The
work-around is simply to get you going until we can get a patch
release out.
> INSERT INTO wave (subjectID, examType, waveID, examID) VALUES
> (NEW.subjectID, 'demographicExam', 'time1', NEW.subjectID);
> END;
>
--
D. Richard Hipp
drh at sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
