Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | A few more tests for upsert. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
b78005b6d41640203c163ffde4faf933 |
User & Date: | dan 2018-04-21 14:11:18.088 |
Context
2018-04-21
| ||
20:24 | Enhance LEMON to track which symbols actually carry semantic content. Output the list of symbols that do not carry content at the end of the report, but do not (yet) do anything else with the information. (check-in: dcf2bafc15 user: drh tags: trunk) | |
14:11 | A few more tests for upsert. (check-in: b78005b6d4 user: dan tags: trunk) | |
13:51 | Add the %extra_context directive to lemon, as an alternative to %extra_argument. Use this to improve the performance of the parser. (check-in: be47a6f526 user: drh tags: trunk) | |
Changes
Changes to test/upsert4.test.
︙ | |||
327 328 329 330 331 332 333 | 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 | - + + + | DO UPDATE SET w = w||tbl.w; SELECT * FROM t1; } {c 1 1 1 bbbbbbbb 2 2 2} } foreach {tn sql} { 1 { |
︙ | |||
355 356 357 358 359 360 361 | 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 | - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + | } {a 1 1 1 b 2 2 2} do_execsql_test 8.$tn.2 { INSERT INTO excluded AS x1 VALUES('hello', 1, 1, NULL) ON CONFLICT(x, [a b]) DO UPDATE SET w=excluded.w; SELECT * FROM excluded; } {hello 1 1 1 b 2 2 2} |
Added test/upsertfault.test.
|