Code: Select all
dbadmin=> select * from configuration_parameters where default_value = 1;
ERROR 2826: Could not convert "/opt/vertica/log/annotatedExplainSQL.sql" from column cp.default_value to a float8
Moderator: NorbertKrupa
Code: Select all
dbadmin=> select * from configuration_parameters where default_value = 1;
ERROR 2826: Could not convert "/opt/vertica/log/annotatedExplainSQL.sql" from column cp.default_value to a float8
Code: Select all
dbadmin=> SELECT column_name, data_type FROM system_columns WHERE table_name = 'configuration_parameters' ORDER BY ordinal_position;
column_name | data_type
-------------------------------+---------------
node_name | varchar(128)
parameter_name | varchar(128)
current_value | varchar(8192)
default_value | varchar(8192)
change_under_support_guidance | boolean
change_requires_restart | boolean
description | varchar(8192)
Code: Select all
select * from configuration_parameters where default_value = '1';
Code: Select all
dbadmin=> create table test (t varchar(1));
CREATE TABLE
dbadmin=> insert into test values ('A');
OUTPUT
--------
1
(1 row)
dbadmin=> select * from test where t = 1;
ERROR 2826: Could not convert "A" from column test.t to a float8
Code: Select all
-- Vertica Analytic Database v7.0.1-0
dbadmin=> SELECT * FROM configuration_parameters WHERE default_value = 1;
ERROR 2826: Could not convert "/opt/vertica/log/annotatedExplainSQL.sql" from column cp.default_value to a float8
-- Vertica Analytic Database v6.1.2-0
dbadmin=> SELECT * FROM configuration_parameters WHERE default_value = 1;
ERROR 2826: Could not convert "" from column cp.default_value to a float8
-- Vertica Analytic Database v6.0.1-0
dbadmin=> SELECT * FROM configuration_parameters WHERE default_value = 1;
ERROR 2826: Could not convert "" from column cp.default_value to a float8
I will be pleasantly surprised.sKwa wrote:Will see if will be any movement.