schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/032-fix-supplements-enhances.sql.postgresql
| 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 8dadb6de15cbf6e2cf6bbeabe7a77de2b05da110
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Thu Oct 24 10:32:47 2013 +0200
schema upgrade fix: explicit cast for bit-wise operand
This is to fix the following error:
psql:/var/log/spacewalk/schema-upgrade/20131022-181452-script.sql:4949: ERROR:
operator does not exist: numeric & integer
LINE 4: where (s.sense & 134217728) != 134217728;
^
HINT: No operator matches the given name and argument type(s). You might need to add
explicit type casts.
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/032-fix-supplements-enhances.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/032-fix-supplements-enhances.sql.postgresql
index d563b23..d441545 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/032-fix-supplements-enhances.sql.postgresql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/032-fix-supplements-enhances.sql.postgresql
@@ -3,7 +3,7 @@
insert into rhnPackageEnhances (package_id, capability_id, sense)
select s.package_id, s.capability_id, s.sense
from rhnPackageSupplements s
- where (s.sense & 134217728) != 134217728;
+ where (s.sense::bigint & 134217728) != 134217728;
-- 134217728 == (1 << 27) STRONG FLAG in RPM
delete from rhnPackageSupplements
Show replies by date