/ Check-in [fba24aec]
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 | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:fba24aec235dd6f124c1ece66cdac485c9d96e0578c4fbacd8f49d7b767a5b4a
User & Date: drh 2018-04-18 16:03:36
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: fb16348a user: drh tags: trunk
16:03
Add support for PostgreSQL UPSERT syntax and functionality. check-in: fba24aec user: drh tags: trunk
15:33
Fix the build for SQLITE_OMIT_UPSERT Closed-Leaf check-in: 32956519 user: drh tags: upsert
11:35
Enhance ALTER TABLE ADD COLUMN to support "DEFAULT true" and "DEFAULT false". check-in: 594ebc69 user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs 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.