| Subject: | |
| Date: | Mon, 26 Feb 2018 18:29:12 -0500 |
| To: | bug-HTTP-ClickHouse [...] rt.cpan.org |
| From: | Valeriy Filatov <vfilatov [...] gmail.com> |
#!/usr/bin/env perl
# Driver fails if you want to place a string that looks like number
("1E02") into String field
use strict;
use HTTP::ClickHouse;
my $chdb = HTTP::ClickHouse->new(
host => '127.0.0.1',
user => 'Harry',
password => 'Alohomora',
);
$chdb->do("CREATE TABLE my_table (id UInt8, f1 String, f2 String) engine =
Memory");
$chdb->do("INSERT INTO my_table (id, f1, f2) VALUES",
[1, "Gryffindor", "a546825467 1861834657416875469"],
[2, "Hufflepuff", "a18202568975170758 46717657846"],
[3, "Ravenclaw", "a678 2527258545746575410210547"],
[4, "Slytherin", "a1068267496717456 878134788953"],
[5, "1E02", "a1068267496717456 878134788953"]
);
__END__
Output:
at ./2.pl line 15.
$VAR1 = [
[
'Code: 53, e.displayText() = DB::Exception: Type mismatch in IN
or VALUES section. Expected: String. Got: Float64, e.what() = DB::Exception'
]
];
at ./2.pl line 15.