Fossil SCM
On windows, use COLLATE NOCASE instead of LIKE to do case insensitive comparisons - to avoid issues with wildcards. Ticket [80d3ba8b0ff].
Commit
d97a4cdf8dce617efde281f5a265e53b41910bd4
Parent
355d37ca8c93ca2…
1 file changed
+4
-2
+4
-2
| --- src/add.c | ||
| +++ src/add.c | ||
| @@ -53,12 +53,14 @@ | ||
| 53 | 53 | }else{ |
| 54 | 54 | if( !file_is_simple_pathname(zPath) ){ |
| 55 | 55 | fossil_fatal("filename contains illegal characters: %s", zPath); |
| 56 | 56 | } |
| 57 | 57 | #ifdef __MINGW32__ |
| 58 | - if( db_exists("SELECT 1 FROM vfile WHERE pathname LIKE %Q", zPath) ){ | |
| 59 | - db_multi_exec("UPDATE vfile SET deleted=0 WHERE pathname LIKE %Q", zPath); | |
| 58 | + if( db_exists("SELECT 1 FROM vfile" | |
| 59 | + " WHERE pathname=%Q COLLATE nocase", zPath) ){ | |
| 60 | + db_multi_exec("UPDATE vfile SET deleted=0" | |
| 61 | + " WHERE pathname=%Q COLLATE nocase", zPath); | |
| 60 | 62 | } |
| 61 | 63 | #else |
| 62 | 64 | if( db_exists("SELECT 1 FROM vfile WHERE pathname=%Q", zPath) ){ |
| 63 | 65 | db_multi_exec("UPDATE vfile SET deleted=0 WHERE pathname=%Q", zPath); |
| 64 | 66 | } |
| 65 | 67 |
| --- src/add.c | |
| +++ src/add.c | |
| @@ -53,12 +53,14 @@ | |
| 53 | }else{ |
| 54 | if( !file_is_simple_pathname(zPath) ){ |
| 55 | fossil_fatal("filename contains illegal characters: %s", zPath); |
| 56 | } |
| 57 | #ifdef __MINGW32__ |
| 58 | if( db_exists("SELECT 1 FROM vfile WHERE pathname LIKE %Q", zPath) ){ |
| 59 | db_multi_exec("UPDATE vfile SET deleted=0 WHERE pathname LIKE %Q", zPath); |
| 60 | } |
| 61 | #else |
| 62 | if( db_exists("SELECT 1 FROM vfile WHERE pathname=%Q", zPath) ){ |
| 63 | db_multi_exec("UPDATE vfile SET deleted=0 WHERE pathname=%Q", zPath); |
| 64 | } |
| 65 |
| --- src/add.c | |
| +++ src/add.c | |
| @@ -53,12 +53,14 @@ | |
| 53 | }else{ |
| 54 | if( !file_is_simple_pathname(zPath) ){ |
| 55 | fossil_fatal("filename contains illegal characters: %s", zPath); |
| 56 | } |
| 57 | #ifdef __MINGW32__ |
| 58 | if( db_exists("SELECT 1 FROM vfile" |
| 59 | " WHERE pathname=%Q COLLATE nocase", zPath) ){ |
| 60 | db_multi_exec("UPDATE vfile SET deleted=0" |
| 61 | " WHERE pathname=%Q COLLATE nocase", zPath); |
| 62 | } |
| 63 | #else |
| 64 | if( db_exists("SELECT 1 FROM vfile WHERE pathname=%Q", zPath) ){ |
| 65 | db_multi_exec("UPDATE vfile SET deleted=0 WHERE pathname=%Q", zPath); |
| 66 | } |
| 67 |