diff options
| -rw-r--r-- | manifest | 14 | ||||
| -rw-r--r-- | manifest.uuid | 2 | ||||
| -rw-r--r-- | test/tkt3824.test | 13 |
3 files changed, 20 insertions, 9 deletions
@@ -1,5 +1,5 @@ -C Dequote\sthe\s"from"\stable\sin\sa\sFOREIGN\sKEY\sdefinition\s(affects\sthe\soutput\sof\s"pragma\sforeign_key_list).\sFix\sfor\s#3800.\s(CVS\s6547) -D 2009-04-24T18:06:09 +C Add\sanother\stest\scase\sfor\sthe\s"x\sIS\sNULL"\suniqueness\sproblem\sof\sticket\s#3824.\nNo\schanges\sto\scode.\s\sThis\sjust\sdouble-checks\sthat\severything\sis\sworking\snow.\s(CVS\s6548) +D 2009-04-24T20:32:31 F Makefile.arm-wince-mingw32ce-gcc fcd5e9cd67fe88836360bb4f9ef4cb7f8e2fb5a0 F Makefile.in 583e87706abc3026960ed759aff6371faf84c211 F Makefile.linux-gcc d53183f4aa6a9192d249731c90dbdffbd2c68654 @@ -643,7 +643,7 @@ F test/tkt3762.test 2a9f3b03df44ec49ec0cfa8d5da6574c2a7853df F test/tkt3773.test 430b06567ce40285dfd2c4834a2a61816403efeb F test/tkt3791.test a6624b9a80b216a26cf473607f42f3e51898c267 F test/tkt3793.test 3aa2efe55bc31fc9459618feea2016ea9a52b2af -F test/tkt3824.test df7c288c9b50c0ef531e56907bb2eed4aa1a4705 +F test/tkt3824.test 3da2f5c81b057e3ff355f5dfc9aa0cf0a92e0206 F test/tokenize.test ce430a7aed48fc98301611429595883fdfcab5d7 F test/trace.test 19ffbc09885c3321d56358a5738feae8587fb377 F test/trans.test 8b79967a7e085289ec64890c6fdf9d089e1b4a5f @@ -724,7 +724,7 @@ F tool/speedtest16.c c8a9c793df96db7e4933f0852abb7a03d48f2e81 F tool/speedtest2.tcl ee2149167303ba8e95af97873c575c3e0fab58ff F tool/speedtest8.c 2902c46588c40b55661e471d7a86e4dd71a18224 F tool/speedtest8inst1.c 293327bc76823f473684d589a8160bde1f52c14e -P 98606bee9e41b8969fb639fc43864e230185ca43 -R 7355728ce767986b1d7d16dc86db48ff -U danielk1977 -Z 795d85bf9579d5df19980eca484a5a46 +P 600482d1619c07690b6517ded9655462bdab7538 +R 71d404284132ce2fe7a2834055b5d726 +U drh +Z 1cf62362f2b3736c4e9a302fbf33112d diff --git a/manifest.uuid b/manifest.uuid index bebc21a14..899cd0338 100644 --- a/manifest.uuid +++ b/manifest.uuid @@ -1 +1 @@ -600482d1619c07690b6517ded9655462bdab7538
\ No newline at end of file +3ceae3579bc42974865cf6fe0bc42001e786e894
\ No newline at end of file diff --git a/test/tkt3824.test b/test/tkt3824.test index 1dccd9e69..5b447bff4 100644 --- a/test/tkt3824.test +++ b/test/tkt3824.test @@ -15,7 +15,7 @@ # is not necessarily UNIQUE. Make sure the optimizer does not assume # uniqueness. # -# $Id: tkt3824.test,v 1.1 2009/04/24 14:51:42 drh Exp $ +# $Id: tkt3824.test,v 1.2 2009/04/24 20:32:31 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl @@ -85,4 +85,15 @@ do_test tkt3824-3.1 { } } {234 567} +do_test tkt3824-4.1 { + db eval { + CREATE TABLE t4(x,y); + INSERT INTO t4 SELECT a, b FROM t1; + INSERT INTO t4 VALUES(234,567); + CREATE UNIQUE INDEX t4y ON t4(y); + UPDATE t4 SET rowid=rowid+100 WHERE y IS NULL; + SELECT rowid, x FROM t4 ORDER BY rowid; + } +} {6 234 101 1 102 9 103 5 104 123 105 -10} + finish_test |