[sqlite] constraint failed message and no clue what went wrong

[Bernd Lehmkuhl]

> Dominique Devienne <ddevienne at gmail.com> hat am 23. Mai 2016 um 11:20 
> geschrieben:
> 
> 
> On Mon, May 23, 2016 at 10:39 AM, Bernd Lehmkuhl <bernd.lehmkuhl at 
> mailbox.org
> > wrote:
> 
> > [...] What might cause a "constraint failed" message following this
> > command: [...]
> >
> 
> Which version of SQLite? More recent ones tell you which constraint failed,
> when they are named, which yours are (a good thing IMHO).

Most recent one - 3.12.2. Unfortunately without any name.

Microsoft Windows [Version 10.0.10586]
(c) 2015 Microsoft Corporation. Alle Rechte vorbehalten.

D:\Programmierung\NAS\Diverse Echtdaten\Schortens\2016-03-31>sqlite3 
000-0-katalog-1-3730-17851-2016-03-31-08-44-03_0000_postnas_grafik.db3
SQLite version 3.12.2 2016-04-18 17:30:31
Enter ".help" for usage hints.
sqlite> begin;
sqlite> INSERT INTO t_geometrie_index (id, xmin, xmax, ymin, ymax)
   ...> SELECT
   ...>   t.auto_id,
   ...>   sub.xmin,
   ...>   sub.xmax,
   ...>   sub.ymin,
   ...>   sub.ymax
   ...> FROM
   ...>   (
   ...>     SELECT
   ...>       k.id,
   ...>       k.x AS xmin,
   ...>       k.x AS xmax,
   ...>       k.y AS ymin,
   ...>       k.y AS ymax
   ...>     FROM
   ...>       t_geometrie_knoten k
   ...>
   ...>     UNION ALL
   ...>
   ...>     SELECT
   ...>       p.id,
   ...>       MIN(p.x),
   ...>       MAX(p.x),
   ...>       MIN(p.y),
   ...>       MAX(p.y)
   ...>     FROM
   ...>       t_geometrie_punkte p
   ...>     GROUP BY
   ...>       p.id
   ...>   ) sub JOIN t_geometrie_typ t
   ...>         ON   sub.id = t.id;
Error: constraint failed
sqlite> rollback;
sqlite> .quit

> 
> So using a newer version might help your troubleshooting. --DD
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users