blob: 37ad6440e69f25d936e03c31dac86413bf095ed2 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
# Errors, defects and missing data in the database
There are a number of errors in the database, which we try to track in this issue. These are best fixed directly in the database rather than by working around them in code.
## LRS values listed as 0.000
Some LRS values in the database are wrongly listed as 0.000. They should be NULLs.
```
MariaDB> SELECT COUNT(*) FROM ProbeSetXRef WHERE LRS=0;
+----------+
| COUNT(*) |
+----------+
| 237327 |
+----------+
MariaDB> SELECT COUNT(*) FROM PublishXRef WHERE LRS=0;
+----------+
| COUNT(*) |
+----------+
| 1687 |
+----------+
```
## Years are sometimes blank or other strings
Some years are blank strings or strings that contain text other than the year. These should be fixed and the year field must be made an integer.
```
MariaDB> SELECT COUNT(*) FROM Publication WHERE CONVERT(Year, UNSIGNED)=0;
+----------+
| COUNT(*) |
+----------+
| 854 |
+----------+
```
## E-mail IDs with spaces
At least one e-mail IDs has spaces in it.
```
MariaDB> SELECT * FROM Investigators WHERE Email LIKE '% %';
```
## Blank E-mail IDs
At least one e-mail ID is blank.
```
MariaDB> SELECT * FROM Investigators WHERE Email="";
```
## Encodings and unprintable characters
At least one last name is encoded incorrectly and appear as unprintable characters.
```
MariaDB> SELECT LastName FROM Investigators WHERE FirstName='Yohan';
```
## Author list is not always a comma-separated string
The list of authors is not always a strictly comma-separated string. Sometimes, there is an "and" at the end instead of a comma.
```
MariaDB> SELECT Authors FROM Publication WHERE Authors LIKE '% and %';
```
Sometimes, not all authors are listed by name. They are only mentioned as "and colleagues".
```
MariaDB> SELECT Authors FROM Publication WHERE Authors LIKE '%colleagues%';
```
At other times, there is a trailing comma at the end of the string.
```
MariaDB> SELECT Authors FROM Publication WHERE Authors LIKE '%,';
```
|
