Insert succeeds with error

45 views
Skip to first unread message

Serg

unread,
Mar 21, 2023, 11:01:15 AM3/21/23
to click...@googlegroups.com
I am using DateTime64 - let's assume a timestamp field, which is
calculated like follows:
fromUnixTimestamp64Nano(CAST(1679409792.9786744*1000000000, 'Int64'))

When inserting automatically using rsyslog, this produces error
CANNOT_PARSE_INPUT_ASSERTION_FAILED (checked with `SELECT * FROM
system.errors`). Even though, the row is still inserted into the table.

When trying to insert row manually, no error is produced:

:) INSERT INTO logging.caddy_logs (timestamp) VALUES
(fromUnixTimestamp64Nano(CAST(1679409792.9786744*1000000000, 'Int64')));

INSERT INTO logging.caddy_logs (timestamp) FORMAT Values

Query id: 7adc3ebc-c3a0-4a50-bc17-aacba684643c

Ok.

1 row in set. Elapsed: 0.004 sec.

Information regarding environment:
ClickHouse client version 23.2.4.12 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 23.2.4 revision 54461.
Reply all
Reply to author
Forward
0 new messages