[Bug 56542] Database::upsert does not handle sequences for the insert
https://bugzilla.wikimedia.org/show_bug.cgi?id=56542 db duplicate...@googlemail.com changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #5 from db duplicate...@googlemail.com --- For upsert on Oracle bug 53710 exists, postgres has no problem, so there is no need to keep this open (but it is not a real dup, so marking INVALID) -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56542] Database::upsert does not handle sequences for the insert
https://bugzilla.wikimedia.org/show_bug.cgi?id=56542 Umherirrender umherirrender_de...@web.de changed: What|Removed |Added CC||umherirrender_de...@web.de --- Comment #1 from Umherirrender umherirrender_de...@web.de --- This can be done already by adding the sequence value to the insert rows given to upsert, but that means more sequence numbers are used, because not all rows must be inserted. But when nextval on a INSERT IGNORE will also reserve the next sequence number for ignored rows, than there is no different as given it outside. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56542] Database::upsert does not handle sequences for the insert
https://bugzilla.wikimedia.org/show_bug.cgi?id=56542 Umherirrender umherirrender_de...@web.de changed: What|Removed |Added See Also||https://bugzilla.wikimedia. ||org/show_bug.cgi?id=38916 --- Comment #2 from Umherirrender umherirrender_de...@web.de --- Maybe something like done in DatabaseOracle can be used, where the field for the sequence is added automatically to the insert part, this avoids changes to the rest of core. triggers on oracle maybe another option. I have no oracle to do this. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56542] Database::upsert does not handle sequences for the insert
https://bugzilla.wikimedia.org/show_bug.cgi?id=56542 --- Comment #3 from Aaron Schulz aschulz4...@gmail.com --- Doesn't Postgres have DEFAULT NEXTVAL('some_seq') and SERIAL columns? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56542] Database::upsert does not handle sequences for the insert
https://bugzilla.wikimedia.org/show_bug.cgi?id=56542 --- Comment #4 from Umherirrender umherirrender_de...@web.de --- Postgres is using DEFAULT NEXTVAL, but not Oracle. I found that Oracle will support DEFAULT NEXTVAL with version 12c, but MediaWiki supports Oracle 9.0.1 or later at the moment. Mssql also has sequence support (Implemented Database::nextSequenceValue), but I do not know how that works there (looks not like nativ sequences). -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 56542] Database::upsert does not handle sequences for the insert
https://bugzilla.wikimedia.org/show_bug.cgi?id=56542 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Priority|Unprioritized |Normal Severity|normal |major -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l