Igor created IGNITE-25330:
-----------------------------
Summary: TIME datatype does not support hh:mm syntax while insert
Key: IGNITE-25330
URL: https://issues.apache.org/jira/browse/IGNITE-25330
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 3.1
Reporter: Igor
*Steps to reproduce:*
{code:java}
[defaultNode]> sql
sql-cli> create zone if not exists "DEFAULT_ZONE" with
storage_profiles='default'
Updated 0 rows.
sql-cli> create table
eight_different_types_TINYINT_TIME_TIME_TINYINT_TINYINT_TIME_TIME_TINYINT(keyTINYINT0
TINYINT not null, keyTIME1 TIME not null, keyTIME2 TIME not null, keyTINYINT3
TINYINT not null, keyTINYINT4 TINYINT not null, keyTIME5 TIME not null,
keyTIME6 TIME not null, keyTINYINT7 TINYINT not null, val INTEGER not null,
primary key (keyTINYINT0, keyTIME1, keyTIME2, keyTINYINT3, keyTINYIN
T4, keyTIME5, keyTIME6, keyTINYINT7)) ZONE "DEFAULT_ZONE"
Updated 0 rows.
sql-cli> insert into
eight_different_types_TINYINT_TIME_TIME_TINYINT_TINYINT_TIME_TIME_TINYINT(keyTINYINT0,
keyTIME1, keyTIME2, keyTINYINT3, keyTINYINT4, keyTIME5, keyTIME6, keyTINYINT7,
val) values (-90::TINYINT, '07:55:55'::TIME, '07:55:56'::TIME, -87::TINYINT,
-86::TINYINT, '07:55:59'::TIME, '07:56'::TIME, -83::TINYINT, 116519::INTEGER)
SQL query execution error
Invalid TIME value, '07:56'
{code}
*Extra info:*
Documentation says this syntax is supported:
[https://www.gridgain.com/docs/gridgain9/latest/sql-reference/data-types#time]
The problem is reproduced since 01.05.2025.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
