From 1127cca30e977dd263e6c738bd24bdfef4061be9 Mon Sep 17 00:00:00 2001
From: Arun Isaac
Date: Sun, 30 Oct 2022 15:58:29 +0530
Subject: Document author list issues as database defects.

---
 issues/database-defects.gmi | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)

(limited to 'issues')

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 '%,';
+```
+
+
-- 
cgit v1.2.3