diff mbox series

[1/3] location-importer.in: avoid violating NOT NULL constraints during JOIN

Message ID 3e511a13-07cc-d5a2-1bd4-2bfc7285990d@ipfire.org
State Superseded
Headers
Series [1/3] location-importer.in: avoid violating NOT NULL constraints during JOIN |

Commit Message

Peter Müller Sept. 6, 2020, 9:47 a.m. UTC 
  Signed-off-by: Peter Müller <peter.mueller@ipfire.org>
---
 src/python/location-importer.in | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)
diff mbox series

Patch

diff --git a/src/python/location-importer.in b/src/python/location-importer.in
index f5ae4a9..77952f2 100644
--- a/src/python/location-importer.in
+++ b/src/python/location-importer.in
@@ -360,7 +360,7 @@  class CLI(object):
 					ON COMMIT DROP;
 				CREATE UNIQUE INDEX _autnums_number ON _autnums(number);
 
-				CREATE TEMPORARY TABLE _organizations(handle text, name text)
+				CREATE TEMPORARY TABLE _organizations(handle text, name text NOT NULL)
 					ON COMMIT DROP;
 				CREATE UNIQUE INDEX _organizations_handle ON _organizations(handle);
 			""")
@@ -373,7 +373,7 @@  class CLI(object):
 			self.db.execute("""
 				INSERT INTO autnums(number, name)
 					SELECT _autnums.number, _organizations.name FROM _autnums
-						LEFT JOIN _organizations ON _autnums.organization = _organizations.handle
+						JOIN _organizations ON _autnums.organization = _organizations.handle
 				ON CONFLICT (number) DO UPDATE SET name = excluded.name;
 			""")