SQLite

Check-in [fba24aec23]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add support for PostgreSQL UPSERT syntax and functionality.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: fba24aec235dd6f124c1ece66cdac485c9d96e0578c4fbacd8f49d7b767a5b4a
User & Date: drh 2018-04-18 16:03:36.712
Context
2018-04-18
17:52
Fix a problem in the sqlite3ExprCompare() function that caused two dissimilar expressions to match if they have the same "COLLATE name" at the outer layer. (check-in: fb16348a5b user: drh tags: trunk)
16:03
Add support for PostgreSQL UPSERT syntax and functionality. (check-in: fba24aec23 user: drh tags: trunk)
15:33
Fix the build for SQLITE_OMIT_UPSERT (Closed-Leaf check-in: 3295651917 user: drh tags: upsert)
11:35
Enhance ALTER TABLE ADD COLUMN to support "DEFAULT true" and "DEFAULT false". (check-in: 594ebc6955 user: drh tags: trunk)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to Makefile.in.
Changes to Makefile.msc.
Changes to main.mk.
Changes to src/expr.c.
Changes to src/insert.c.
Changes to src/parse.y.
Changes to src/resolve.c.
Changes to src/sqliteInt.h.
Changes to src/trigger.c.
Changes to src/update.c.
Added src/upsert.c.
Changes to src/vdbe.h.
Changes to src/vdbeaux.c.
Changes to test/distinct.test.
Added test/upsert1.test.
Added test/upsert2.test.
Added test/upsert3.test.
Added test/upsert4.test.
Changes to tool/mkkeywordhash.c.
Changes to tool/mksqlite3c.tcl.