diff options
| author | Frederick Muriuki Muriithi | 2024-03-22 10:23:31 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2024-03-22 10:23:31 +0300 |
| commit | 9a15bae9743972d2aef5d3a4368104387bf8f78c (patch) | |
| tree | c7c02ae78351ca8e095f751b9777d76b39670963 /issues/database-ProbeSetSE-schema-bug.gmi | |
| parent | dd5aab0bcddbbfaaf94a9eb03e5c8f6f4580e703 (diff) | |
| download | gn-gemtext-9a15bae9743972d2aef5d3a4368104387bf8f78c.tar.gz | |
Database: Provide query to solve issue.
Diffstat (limited to 'issues/database-ProbeSetSE-schema-bug.gmi')
| -rw-r--r-- | issues/database-ProbeSetSE-schema-bug.gmi | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/issues/database-ProbeSetSE-schema-bug.gmi b/issues/database-ProbeSetSE-schema-bug.gmi index a451002..39d02f8 100644 --- a/issues/database-ProbeSetSE-schema-bug.gmi +++ b/issues/database-ProbeSetSE-schema-bug.gmi @@ -50,3 +50,12 @@ MariaDB [db_webqtl]> DESC ProbeSetSE; From this, you can see that "ProbeSetSE" has the column "StrainId" but with a different size integer (smaller) than that in table "Strain". This could at best, cause errors when inserting data, if the strain exceeds the value 65535, or at worst, do a silent conversion of inserted "StrainId" values into a value in the range [0, 65535] leading to data corruption. The schema needs to be updated accordingly. + + +## Solution + +Run this query against the database: + +``` +ALTER TABLE ProbeSetSE MODIFY StrainId INT(20) NOT NULL; +``` |