Shirly Radco has uploaded a new change for review.
Change subject: History: Fixed ad_domain datatype
......................................................................
History: Fixed ad_domain datatype
Made a mistake in configuring the datatype in views to preserve the
views legacy.
This fixes the issue.
Change-Id: I49708d50e29e04a11e343c8f69508301dfe67254
Signed-off-by: Shirly Radco <sra...@redhat.com>
---
M packaging/dbscripts/create_views_3_0.sql
M packaging/dbscripts/create_views_3_1.sql
M packaging/dbscripts/create_views_3_2.sql
M packaging/dbscripts/create_views_3_3.sql
4 files changed, 8 insertions(+), 8 deletions(-)
git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/99/24499/1
diff --git a/packaging/dbscripts/create_views_3_0.sql
b/packaging/dbscripts/create_views_3_0.sql
index 5418d6c..002c798 100644
--- a/packaging/dbscripts/create_views_3_0.sql
+++ b/packaging/dbscripts/create_views_3_0.sql
@@ -440,7 +440,7 @@
number_of_sockets as number_of_sockets,
memory_size_mb as memory_size_mb,
operating_system as operating_system,
- NULL as ad_domain,
+ cast(NULL as VARCHAR(40)) as ad_domain,
default_host as default_host,
high_availability as high_availability,
initialized as initialized,
@@ -471,7 +471,7 @@
number_of_sockets as number_of_sockets,
memory_size_mb as memory_size_mb,
operating_system as operating_system,
- NULL as ad_domain,
+ cast(NULL as VARCHAR(40)) as ad_domain,
default_host as default_host,
high_availability as high_availability,
initialized as initialized,
diff --git a/packaging/dbscripts/create_views_3_1.sql
b/packaging/dbscripts/create_views_3_1.sql
index 5bc10f7..6f39e2f 100644
--- a/packaging/dbscripts/create_views_3_1.sql
+++ b/packaging/dbscripts/create_views_3_1.sql
@@ -444,7 +444,7 @@
number_of_sockets as number_of_sockets,
memory_size_mb as memory_size_mb,
operating_system as operating_system,
- NULL as ad_domain,
+ cast(NULL as VARCHAR(40)) as ad_domain,
default_host as default_host,
high_availability as high_availability,
initialized as initialized,
@@ -475,7 +475,7 @@
number_of_sockets as number_of_sockets,
memory_size_mb as memory_size_mb,
operating_system as operating_system,
- NULL as ad_domain,
+ cast(NULL as VARCHAR(40)) as ad_domain,
default_host as default_host,
high_availability as high_availability,
initialized as initialized,
diff --git a/packaging/dbscripts/create_views_3_2.sql
b/packaging/dbscripts/create_views_3_2.sql
index 8868c76..adb2f94 100644
--- a/packaging/dbscripts/create_views_3_2.sql
+++ b/packaging/dbscripts/create_views_3_2.sql
@@ -447,7 +447,7 @@
number_of_sockets as number_of_sockets,
memory_size_mb as memory_size_mb,
operating_system as operating_system,
- NULL as ad_domain,
+ cast(NULL as VARCHAR(40)) as ad_domain,
default_host as default_host,
high_availability as high_availability,
initialized as initialized,
@@ -477,7 +477,7 @@
number_of_sockets as number_of_sockets,
memory_size_mb as memory_size_mb,
operating_system as operating_system,
- NULL as ad_domain,
+ cast(NULL as VARCHAR(40)) as ad_domain,
default_host as default_host,
high_availability as high_availability,
initialized as initialized,
diff --git a/packaging/dbscripts/create_views_3_3.sql
b/packaging/dbscripts/create_views_3_3.sql
index 816dd81..de3ccf7 100644
--- a/packaging/dbscripts/create_views_3_3.sql
+++ b/packaging/dbscripts/create_views_3_3.sql
@@ -447,7 +447,7 @@
number_of_sockets as number_of_sockets,
memory_size_mb as memory_size_mb,
operating_system as operating_system,
- NULL as ad_domain,
+ cast(NULL as VARCHAR(40)) as ad_domain,
default_host as default_host,
high_availability as high_availability,
initialized as initialized,
@@ -479,7 +479,7 @@
number_of_sockets as number_of_sockets,
memory_size_mb as memory_size_mb,
operating_system as operating_system,
- NULL as ad_domain,
+ cast(NULL as VARCHAR(40)) as ad_domain,
default_host as default_host,
high_availability as high_availability,
initialized as initialized,
--
To view, visit http://gerrit.ovirt.org/24499
To unsubscribe, visit http://gerrit.ovirt.org/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I49708d50e29e04a11e343c8f69508301dfe67254
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-dwh
Gerrit-Branch: master
Gerrit-Owner: Shirly Radco <sra...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches
