summaryrefslogtreecommitdiffstats
path: root/src/share
diff options
context:
space:
mode:
authorThomas Markwalder <tmark@isc.org>2024-10-28 18:09:52 +0100
committerThomas Markwalder <tmark@isc.org>2024-10-28 18:09:52 +0100
commit52797cb71f51ae7c1c48c6ec2d8c9043ae886a82 (patch)
treefba8641006bb2ffca7dd50cf50baeebac6b035fc /src/share
parent[#3587] Add update type update to create scripts (diff)
downloadkea-52797cb71f51ae7c1c48c6ec2d8c9043ae886a82.tar.xz
kea-52797cb71f51ae7c1c48c6ec2d8c9043ae886a82.zip
[#3587] Fixed sql scripts and fuzzing
Changes to be committed: modified: ../../../fuzz/fuzz.h modified: ../../lib/dhcpsrv/ip_range_permutation.h modified: ../../lib/util/bigints.h modified: ../../share/database/scripts/mysql/dhcpdb_create.mysql modified: ../../share/database/scripts/mysql/upgrade_025_to_026.sh.in modified: ../../share/database/scripts/pgsql/dhcpdb_create.pgsql modified: ../../share/database/scripts/pgsql/upgrade_025_to_026.sh.in
Diffstat (limited to 'src/share')
-rw-r--r--src/share/database/scripts/mysql/dhcpdb_create.mysql2
-rw-r--r--src/share/database/scripts/mysql/upgrade_025_to_026.sh.in2
-rw-r--r--src/share/database/scripts/pgsql/dhcpdb_create.pgsql2
-rw-r--r--src/share/database/scripts/pgsql/upgrade_025_to_026.sh.in2
4 files changed, 4 insertions, 4 deletions
diff --git a/src/share/database/scripts/mysql/dhcpdb_create.mysql b/src/share/database/scripts/mysql/dhcpdb_create.mysql
index f5aea7d8b3..c1ba285340 100644
--- a/src/share/database/scripts/mysql/dhcpdb_create.mysql
+++ b/src/share/database/scripts/mysql/dhcpdb_create.mysql
@@ -6032,7 +6032,7 @@ ALTER TABLE dhcp4_options
ALTER TABLE dhcp6_options
ADD COLUMN client_classes LONGTEXT DEFAULT NULL;
-UPDATE option_def_data_type SET name='int8' where id = 3;
+UPDATE option_def_data_type SET name='int8' WHERE id = 3;
-- Rename require_client_classes and only_if_required.
ALTER TABLE dhcp4_shared_network
diff --git a/src/share/database/scripts/mysql/upgrade_025_to_026.sh.in b/src/share/database/scripts/mysql/upgrade_025_to_026.sh.in
index aa41e9a995..b9f322fb8a 100644
--- a/src/share/database/scripts/mysql/upgrade_025_to_026.sh.in
+++ b/src/share/database/scripts/mysql/upgrade_025_to_026.sh.in
@@ -63,7 +63,7 @@ ALTER TABLE dhcp4_options
ALTER TABLE dhcp6_options
ADD COLUMN client_classes LONGTEXT DEFAULT NULL;
-UPDATE option_def_data_type SET name='int8' where id = 3;
+UPDATE option_def_data_type SET name='int8' WHERE id = 3;
-- Rename require_client_classes and only_if_required.
ALTER TABLE dhcp4_shared_network
diff --git a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
index ba1e97926c..a25a800024 100644
--- a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
+++ b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
@@ -6493,7 +6493,7 @@ ALTER TABLE dhcp4_options
ALTER TABLE dhcp6_options
ADD COLUMN client_classes TEXT DEFAULT NULL;
-UPDATE option_def_data_type SET name='int8' where id = 3;
+UPDATE option_def_data_type SET name='int8' WHERE id = 3;
-- Rename require_client_classes and only_if_required.
ALTER TABLE dhcp4_shared_network
diff --git a/src/share/database/scripts/pgsql/upgrade_025_to_026.sh.in b/src/share/database/scripts/pgsql/upgrade_025_to_026.sh.in
index d93c294497..0443541356 100644
--- a/src/share/database/scripts/pgsql/upgrade_025_to_026.sh.in
+++ b/src/share/database/scripts/pgsql/upgrade_025_to_026.sh.in
@@ -46,7 +46,7 @@ ALTER TABLE dhcp4_options
ALTER TABLE dhcp6_options
ADD COLUMN client_classes TEXT DEFAULT NULL;
-UPDATE option_def_data_type SET name='int8' where id = 3;
+UPDATE option_def_data_type SET name='int8' WHERE id = 3;
-- Rename require_client_classes and only_if_required.
ALTER TABLE dhcp4_shared_network