/
githubmirror
/
ydb-jdbc-driver
Обзор
Документация
Войти
/
githubmirror
/
ydb-jdbc-driver
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
jdbc/src/test/resources/sql/init.sql
190 строк
4 KB
Alexandr Gorshenin
feat: tests for Date32, Datetime64, Timestamp64, Interval64
23 май 2025, 14:32
Не верифицирован
23 май 2025, 14:32
38d119d
Код
Авторство
О чём код?
upsert into #tableName ( key, c_Bool, c_Int8, c_Int16, c_Int32, c_Int64, c_Uint8, c_Uint16, c_Uint32, c_Uint64, c_Float, c_Double, c_Bytes, c_Text, c_Json, c_JsonDocument, c_Yson, c_Uuid, c_Date, c_Datetime, c_Timestamp, c_Interval, c_Date32, c_Datetime64, c_Timestamp64, c_Interval64, c_Decimal, c_BigDecimal, c_BankDecimal ) values (1, true, cast(101 as Int8), cast(20001 as Int16), cast(2000000001 as Int32), cast(2000000000001 as Int64), cast(100 as Uint8), cast(20002 as Uint16), cast(2000000002 as Uint32), cast(2000000000002 as Uint64), -- TODO: check very large uint64? How it should fit to JVM long value? cast(123456.78 as Float), cast(123456789.123456789 as Double), cast ('bytes array' as Bytes), cast ('text text text' as Text), cast ('{"key": "value Json"}' as Json), cast ('{"key": "value JsonDocument"}' as JsonDocument), Yson(@@{key="value yson"}@@), cast ('6E73B41C-4EDE-4D08-9CFB-B7462D9E498B' as Uuid), cast (3111 as Date), cast (311111156 as DateTime), cast (311111223342 as Timestamp), cast (3111113 as Interval), cast (-3111 as Date32), cast (-311111156 as DateTime64), cast (-311111223342 as Timestamp64), cast (-3111113 as Interval64), Decimal('3.335', 22, 9), Decimal('12345678901234567890123456789012345', 35, 0), Decimal('9999999999999999999999.999999999', 31, 9) ), (2, false, cast(-101 as Int8), cast(-20001 as Int16), cast(-2000000001 as Int32), cast(-2000000000001 as Int64), cast(200 as Uint8), cast(40002 as Uint16), cast(4000000002 as Uint32), cast(4000000000002 as Uint64), cast(-123456.78 as Float), cast(-123456789.123456789 as Double), cast ('' as Bytes), cast ('' as Text), cast ('' as Json), cast ('' as JsonDocument), Yson(@@""@@), cast ('' as Uuid), cast (3112 as Date), cast (211211100 as DateTime), cast (111111223342 as Timestamp), cast (3112113 as Interval), cast (-3112 as Date32), cast (-211211100 as DateTime64), cast (-111111223342 as Timestamp64), cast (-3112113 as Interval64), Decimal('-3.335', 22, 9), Decimal('-98765432109876543210987654321098765', 35, 0), Decimal('-9999999999999999999999.999999999', 31, 9) ), (3, false, cast(0 as Int8), cast(0 as Int16), cast(0 as Int32), cast(0 as Int64), cast(0 as Uint8), cast(0 as Uint16), cast(0 as Uint32), cast(0 as Uint64), cast(0 as Float), cast(0 as Double), cast ('0' as Bytes), cast ('0' as Text), cast ('' as Json), cast ('' as JsonDocument), Yson(@@0@@), cast ('' as Uuid), cast (0 as Date), cast (0 as DateTime), cast (0 as Timestamp), cast (0 as Interval), cast (0 as Date32), cast (0 as DateTime64), cast (0 as Timestamp64), cast (0 as Interval64), Decimal('0', 22, 9), Decimal('0', 35, 0), Decimal('0', 31, 9) ), (4, true, cast(1 as Int8), cast(1 as Int16), cast(1 as Int32), cast(1 as Int64), cast(1 as Uint8), cast(1 as Uint16), cast(1 as Uint32), cast(1 as Uint64), cast(1 as Float), cast(1 as Double), cast ('file:///tmp/report.txt' as Bytes), cast ('https://ydb.tech' as Text), cast ('{}' as Json), cast ('{}' as JsonDocument), Yson(@@1@@), cast ('00000000-0000-0000-0000-000000000000' as Uuid), cast (1 as Date), cast (1 as DateTime), cast (1 as Timestamp), cast (1 as Interval), cast (-1 as Date32), cast (-1 as DateTime64), cast (-1 as Timestamp64), cast (-1 as Interval64), Decimal('1', 22, 9), Decimal('1', 35, 0), Decimal('1', 31, 9) ), (5, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null )