diff options
| author | CommanderRoot <CommanderRoot@users.noreply.github.com> | 2023-01-01 14:06:57 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-01-01 05:06:57 -0800 |
| commit | c2280e94cf21dc5736b9f0c6c07ef611c8ed67c4 (patch) | |
| tree | 94c2a1864d9ef3be3fb44ef5e69a3c53c2776af2 | |
| parent | 265a56630b41c70fe0ae8c0dd9707de3c43f446d (diff) | |
| download | seaweedfs-c2280e94cf21dc5736b9f0c6c07ef611c8ed67c4.tar.xz seaweedfs-c2280e94cf21dc5736b9f0c6c07ef611c8ed67c4.zip | |
filer.store.mysql: Replace deprecated upsert syntax (#4096)
| -rw-r--r-- | weed/command/scaffold/filer.toml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/weed/command/scaffold/filer.toml b/weed/command/scaffold/filer.toml index d8833a917..423d0914e 100644 --- a/weed/command/scaffold/filer.toml +++ b/weed/command/scaffold/filer.toml @@ -61,7 +61,7 @@ connection_max_lifetime_seconds = 0 interpolateParams = false # if insert/upsert failing, you can disable upsert or update query syntax to match your RDBMS syntax: enableUpsert = true -upsertQuery = """INSERT INTO `%s` (dirhash,name,directory,meta) VALUES(?,?,?,?) ON DUPLICATE KEY UPDATE meta = VALUES(meta)""" +upsertQuery = """INSERT INTO `%s` (`dirhash`,`name`,`directory`,`meta`) VALUES (?,?,?,?) AS `new` ON DUPLICATE KEY UPDATE `meta` = `new`.`meta`""" [mysql2] # or memsql, tidb enabled = false @@ -85,7 +85,7 @@ connection_max_lifetime_seconds = 0 interpolateParams = false # if insert/upsert failing, you can disable upsert or update query syntax to match your RDBMS syntax: enableUpsert = true -upsertQuery = """INSERT INTO `%s` (dirhash,name,directory,meta) VALUES(?,?,?,?) ON DUPLICATE KEY UPDATE meta = VALUES(meta)""" +upsertQuery = """INSERT INTO `%s` (`dirhash`,`name`,`directory`,`meta`) VALUES (?,?,?,?) AS `new` ON DUPLICATE KEY UPDATE `meta` = `new`.`meta`""" [postgres] # or cockroachdb, YugabyteDB # CREATE TABLE IF NOT EXISTS filemeta ( |