diff options
| author | Arun Isaac | 2022-10-30 15:58:29 +0530 |
|---|---|---|
| committer | Arun Isaac | 2022-10-30 15:58:58 +0530 |
| commit | 1127cca30e977dd263e6c738bd24bdfef4061be9 (patch) | |
| tree | 998330438e74367e6d2d8b116296f6d7a7fda347 | |
| parent | 65b82505fa432dcf95b6eb43267ca1de4223b1fe (diff) | |
| download | gn-gemtext-1127cca30e977dd263e6c738bd24bdfef4061be9.tar.gz | |
Document author list issues as database defects.
| -rw-r--r-- | issues/database-defects.gmi | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/issues/database-defects.gmi b/issues/database-defects.gmi index 270f421..37ad644 100644 --- a/issues/database-defects.gmi +++ b/issues/database-defects.gmi @@ -53,3 +53,20 @@ At least one last name is encoded incorrectly and appear as unprintable characte ``` 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 '%,'; +``` + + |