Fossil SCM
Repair completely bogus sql that was erroneously copy/pasted
Commit
fe7ac3931ac09a03180702ef225fffc0459d9016
Parent
d55e797ac0d9433…
1 file changed
+2
-2
+2
-2
| --- src/vfile.c | ||
| +++ src/vfile.c | ||
| @@ -125,12 +125,12 @@ | ||
| 125 | 125 | */ |
| 126 | 126 | static int test_isexe(const char *zFilename, int vid){ |
| 127 | 127 | static Stmt s; |
| 128 | 128 | int isexe; |
| 129 | 129 | db_static_prepare(&s, |
| 130 | - "UPDATE vfile SET isexe=:isexe" | |
| 131 | - " WHERE vid=:vid AND pathname=:path AND isexe!=:isexe" | |
| 130 | + "SELECT isexe" | |
| 131 | + " FROM vfile where vid=:vid AND pathname=:path" | |
| 132 | 132 | ); |
| 133 | 133 | db_bind_int(&s, ":vid", vid); |
| 134 | 134 | db_bind_text(&s, ":path", zFilename); |
| 135 | 135 | db_step(&s); |
| 136 | 136 | isexe = db_column_int(&s, 0); |
| 137 | 137 |
| --- src/vfile.c | |
| +++ src/vfile.c | |
| @@ -125,12 +125,12 @@ | |
| 125 | */ |
| 126 | static int test_isexe(const char *zFilename, int vid){ |
| 127 | static Stmt s; |
| 128 | int isexe; |
| 129 | db_static_prepare(&s, |
| 130 | "UPDATE vfile SET isexe=:isexe" |
| 131 | " WHERE vid=:vid AND pathname=:path AND isexe!=:isexe" |
| 132 | ); |
| 133 | db_bind_int(&s, ":vid", vid); |
| 134 | db_bind_text(&s, ":path", zFilename); |
| 135 | db_step(&s); |
| 136 | isexe = db_column_int(&s, 0); |
| 137 |
| --- src/vfile.c | |
| +++ src/vfile.c | |
| @@ -125,12 +125,12 @@ | |
| 125 | */ |
| 126 | static int test_isexe(const char *zFilename, int vid){ |
| 127 | static Stmt s; |
| 128 | int isexe; |
| 129 | db_static_prepare(&s, |
| 130 | "SELECT isexe" |
| 131 | " FROM vfile where vid=:vid AND pathname=:path" |
| 132 | ); |
| 133 | db_bind_int(&s, ":vid", vid); |
| 134 | db_bind_text(&s, ":path", zFilename); |
| 135 | db_step(&s); |
| 136 | isexe = db_column_int(&s, 0); |
| 137 |