[Bug 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-10 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

Reedy  changed:

   What|Removed |Added

 CC||s...@reedyboy.net
Version|1.12.x  |unspecified

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-10 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

Reedy  changed:

   What|Removed |Added

 Depends on||33638

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-10 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #2 from Reedy  2012-01-10 14:23:49 UTC ---
No PK (but has unique index):
categorylinks
change_tag
imagelinks
interwiki
iwlinks
langlinks
log_search
module_deps
msg_resource
msg_resource_links
page_props
oagelinks
protected_titles
querycache_info
searchindex
site_stats
tag_summary
templatelinks
transcache
user_former_groups
user_groups

No PK or unique index:
archive
externallinks
hitcounter
l10n_cache
oldimage
querycache
querycachetwo
user_newtalk

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-10 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

Reedy  changed:

   What|Removed |Added

 CC||mueller062001-...@yahoo.de

--- Comment #3 from Reedy  2012-01-10 15:23:17 UTC ---
*** Bug 33228 has been marked as a duplicate of this bug. ***

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-12 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #4 from Joerg  2012-01-12 15:43:31 UTC 
---
It is important that really Primary Keys are used and not just any index.
Otherwise you might get into trouble trying to edit table data. Programmes like
MySQL Workbench do not allow you to edit table data, if the table does not have
a Primary Key.

I spoke to domas yesterday and as far as missing PKs cause problems he proposed
to convert keys to Primary Keys to fix this issue.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-12 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #5 from Reedy  2012-01-12 17:47:23 UTC ---
(In reply to comment #4)
> It is important that really Primary Keys are used and not just any index.
> Otherwise you might get into trouble trying to edit table data. Programmes 
> like
> MySQL Workbench do not allow you to edit table data, if the table does not 
> have
> a Primary Key.
> 
> I spoke to domas yesterday and as far as missing PKs cause problems he 
> proposed
> to convert keys to Primary Keys to fix this issue.

Cool, thanks for checking. Did he advise if there was a nice way to convert
between them? Other than dropping the index, and recreating it as a PK?

Obviously fixing the ones with no PK or unique key is more easily done

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-12 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #6 from Joerg  2012-01-12 19:36:55 UTC 
---
No, he did not. Basically what I wrote above is everything he told me.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-12 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

Reedy  changed:

   What|Removed |Added

   Priority|Low |Normal
 CC||domas.mitu...@gmail.com

--- Comment #7 from Reedy  2012-01-12 23:51:47 UTC ---
Fancy commenting Domas?

Is there a nice way to convert a unique key to a PK without having to drop and
re-add it?

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-13 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #8 from Fabien Coelho  2012-01-13 
10:11:49 UTC ---
(In reply to comment #5)
> Obviously fixing the ones with no PK or unique key is more easily done

ISTM that you are a little bit optimistic here. If the data do not really
comply to a key (say there is a bug in the application which did not respect an
implicit key, and the key was not checked by the database because the
constraint was not declared), then the addition of the constraint will fail.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-13 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #9 from Fabien Coelho  2012-01-13 
10:20:33 UTC ---
(In reply to comment #7)

> Is there a nice way to convert a unique key to a PK without having to drop and
> re-add it?

AFAIK, not for PostgreSQL.

For the order, it seems safer to add first the PK constraint and then to drop
the UNIQUE, rather than the other way around.

A PK is a UNIQUE + NOT NULL. You must hope that the data do not use a NULL for
some reason.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-13 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #10 from Joerg  2012-01-13 13:41:58 UTC 
---
I could not find anything on changing an existing index into a PK in the MySQL
docs.

Also professional DB Tools like MySQL GUI Tools, MySQL Workbench (and also
phpMyAdmin) just DROP the old index and ADD the new Primary Key (also when you
do both at the same time).

This is an according example output:
ALTER TABLE `x` 
ADD PRIMARY KEY (`field`), 
DROP INDEX `field`;

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-13 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #11 from Sam Reed (reedy)  2012-01-13 17:02:36 
UTC ---
(In reply to comment #10)
> 
> This is an according example output:
> ALTER TABLE `x` 
> ADD PRIMARY KEY (`field`), 
> DROP INDEX `field`;

On that note, someone was going to log a bug about that.

When we do them as individual statements (ie alter table drop, then alter table
add), we actually are creating more overhead as mysql rebuilds the table twice.

It's done for SQLite comparability, but the "overhead" of having a file each is
probably worth it

(In reply to comment #8)
> (In reply to comment #5)
> > Obviously fixing the ones with no PK or unique key is more easily done
> 
> ISTM that you are a little bit optimistic here. If the data do not really
> comply to a key (say there is a bug in the application which did not respect 
> an
> implicit key, and the key was not checked by the database because the
> constraint was not declared), then the addition of the constraint will fail.

The generic fallback is then to just add a PK of an int per row, which MySQL
has already done internally anyway (or something along those lines)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-13 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #12 from Tim Landscheidt  2012-01-14 
00:33:33 UTC ---
(In reply to comment #9)
> > Is there a nice way to convert a unique key to a PK without having to drop 
> > and
> > re-add it?

> AFAIK, not for PostgreSQL.

There seems to be a way described at
http://archives.postgresql.org/pgsql-general/2004-12/msg01161.php.  On any
database smaller than WMF's, I would opt for DROP + ADD, though.

> For the order, it seems safer to add first the PK constraint and then to drop
> the UNIQUE, rather than the other way around.

> A PK is a UNIQUE + NOT NULL. You must hope that the data do not use a NULL for
> some reason.

Well, you can also test that :-).

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-13 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #13 from Fabien Coelho  2012-01-14 
06:52:36 UTC ---
(In reply to comment #12)

> There seems to be a way described at
> http://archives.postgresql.org/pgsql-general/2004-12/msg01161.php.  On any
> database smaller than WMF's, I would opt for DROP + ADD, though.

Indeed, that is a fun one, just updating the metadata!

  CREATE TABLE foo(id INT UNIQUE NOT NULL, data TEXT);
  -- ...
  UPDATE pg_index SET indisprimary=TRUE WHERE indexrelid=106702;
  UPDATE pg_constraint SET contype='p' WHERE conname='foo_id_key';
  # \d+ foo
"foo_id_key" PRIMARY KEY, btree (id)

However, you may need an admin to do that, while the add/drop would only
require to own the table.

> Well, you can also test that :-).

Sure.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-15 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #14 from Domas Mituzas  2012-01-15 
14:15:41 UTC ---
small note: we don't use workbench to edit data in WMF deployment, and we
shouldn't ;-)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-01-15 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #15 from Joerg  2012-01-15 23:01:52 UTC 
---
Workbench was just an example. I know that you prefer the command line. ;-)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-10-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

Nathan Larson  changed:

   What|Removed |Added

 CC||nathanlarson3...@gmail.com

--- Comment #17 from Nathan Larson  2012-11-01 
00:10:25 UTC ---
Gerrit change #Iafdee06e will add a PK for archive and externallinks. Is there
any reason not to also add PKs for:
* change_tag
* hitcounter
* l10n_cache
* oldimage
* querycache
* querycachetwo
* user_newtalk
* user_properties

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-07-25 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

Brylie Oxley  changed:

   What|Removed |Added

   Keywords||postgresql, schema-change

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2013-03-16 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

MZMcBride  changed:

   What|Removed |Added

 CC||b...@mzmcbride.com

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2012-05-16 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

Asher Feldman  changed:

   What|Removed |Added

 CC||afeld...@wikimedia.org

--- Comment #16 from Asher Feldman  2012-05-16 18:00:41 
UTC ---
(In reply to comment #2)
The following tables in enwiki don't have a primary or unique key defined:

mysql> select table_schema,table_name from information_schema.columns where
table_schema='enwiki' group by table_name having sum(if(column_key in
('PRI','UNI'), 1,0)) = 0;
+--++
| table_schema | table_name |
+--++
| enwiki   | archive|
| enwiki   | archive_old|
| enwiki   | change_tag |
| enwiki   | click_tracking |
| enwiki   | click_tracking_user_properties |
| enwiki   | edit_page_tracking |
| enwiki   | exarchive  |
| enwiki   | exlogging  |
| enwiki   | externallinks  |
| enwiki   | hashs  |
| enwiki   | hidden |
| enwiki   | hitcounter |
| enwiki   | l10n_cache |
| enwiki   | logging_old|
| enwiki   | long_run_profiling |
| enwiki   | namespaces |
| enwiki   | oldimage   |
| enwiki   | oldimage_old   |
| enwiki   | old_growth |
| enwiki   | querycache |
| enwiki   | querycachetwo  |
| enwiki   | querycache_old |
| enwiki   | securepoll_lists   |
| enwiki   | user_newtalk   |
| enwiki   | user_properties|
| enwiki   | validate   |
+--++
26 rows in set (0.03 sec)

This is especially vexing for the large tables (archive, externallinks) which
I'd like to be able to perform online schema migrations against.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- 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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2013-08-17 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

Sean Pringle  changed:

   What|Removed |Added

 CC||sprin...@wikimedia.org
   Assignee|wikibugs-l@lists.wikimedia. |sprin...@wikimedia.org
   |org |

-- 
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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2013-08-17 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #18 from Tyler Romeo  ---
If this is being actively worked on, I'd like to note one other thing that
should probably be changed along with this: a lot of our tables have primary
keys, but also don't at the same time. Basically, the maintenance/tables.sql
file doesn't list the table as having a primary key, but MySQL behavior is to
choose the first non-null unique key as use it as a primary key anyway. In
other words, the tables don't *look* like they have primary keys in their
definitions, but they actually do when created. It'd be simpler and less
misleading to just explicitly declare the primary keys.

Also, I'd like to note one thing about primary keys with InnoDB: all tables
have primary keys. If you don't specify one, as I said, MySQL will try and
choose a unique non-null index. But even if there is none of those, it will
create it's own "hidden primary key" using a custom 6-byte row id.
Unfortunately, this is really slow because the value for the next row id is not
per-table, but per-database. In other words, when inserting into any table
without an actual primary key, MySQL has to lock out all other similar tables
first in order to get a row id.

-- 
You are receiving this mail because:
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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2013-08-20 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #19 from Domas Mituzas  ---
There are no global/database/table locking implications with hidden row key. It
does not have to be synchronized with any other subsystem, so the cost of
row-id is zero. Adding auto-increment key would increase locking contention,
not decrease it.

-- 
You are receiving this mail because:
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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2013-08-20 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #20 from Tyler Romeo  ---
(In reply to comment #19)
> There are no global/database/table locking implications with hidden row key.
> It
> does not have to be synchronized with any other subsystem, so the cost of
> row-id is zero. Adding auto-increment key would increase locking contention,
> not decrease it.

http://blog.jcole.us/2013/05/02/how-does-innodb-behave-without-a-primary-key/

Have things changed since May 2?

-- 
You are receiving this mail because:
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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2013-08-20 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #21 from Domas Mituzas  ---
Oh, with that thinking I can point out fifty other global locks that are
touched when executing queries. The question is for what duration and are there
truly any locking implications there or do they apply to a running system.

-- 
You are receiving this mail because:
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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2013-12-05 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

Daniel Kinzler  changed:

   What|Removed |Added

 CC||daniel.kinz...@wikimedia.de
   See Also||https://bugzilla.wikimedia.
   ||org/show_bug.cgi?id=58032

-- 
You are receiving this mail because:
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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2013-10-17 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

--- Comment #22 from Gerrit Notification Bot  ---
Change 51675 merged by jenkins-bot:
Add archive, externallinks PK

https://gerrit.wikimedia.org/r/51675

-- 
You are receiving this mail because:
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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2013-10-28 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

Gerrit Notification Bot  changed:

   What|Removed |Added

 Status|NEW |PATCH_TO_REVIEW

-- 
You are receiving this mail because:
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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2014-02-14 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

Andre Klapper  changed:

   What|Removed |Added

 Status|PATCH_TO_REVIEW |NEW

--- Comment #25 from Andre Klapper  ---
[No patches to merge left - resetting bug status]

-- 
You are receiving this mail because:
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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2014-05-13 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

Liangent  changed:

   What|Removed |Added

   See Also||https://bugzilla.wikimedia.
   ||org/show_bug.cgi?id=65251

-- 
You are receiving this mail because:
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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2014-05-13 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

Brad Jorsch  changed:

   What|Removed |Added

 Blocks||65264

-- 
You are receiving this mail because:
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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2014-11-02 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Bug 15441 depends on bug 33638, which changed state.

Bug 33638 Summary: Math table doesn't have a PK
https://bugzilla.wikimedia.org/show_bug.cgi?id=33638

   What|Removed |Added

 Status|ASSIGNED|RESOLVED
 Resolution|--- |FIXED

-- 
You are receiving this mail because:
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 15441] Some tables lack unique or primary keys, may allow confusing duplicate data

2014-09-23 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441

Nathan Larson  changed:

   What|Removed |Added

 Depends on||71198

-- 
You are receiving this mail because:
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