Changeset: 39b489088a31 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/39b489088a31
Modified Files:
sql/test/proto_loader/odbc/Tests/monetodbc_datatypes.test
sql/test/sys-schema/Tests/webExamplesUrlFunctions.test
Branch: Mar2025
Log Message:
Add tests for URL and JSON datatypes
diffs (96 lines):
diff --git a/sql/test/proto_loader/odbc/Tests/monetodbc_datatypes.test
b/sql/test/proto_loader/odbc/Tests/monetodbc_datatypes.test
--- a/sql/test/proto_loader/odbc/Tests/monetodbc_datatypes.test
+++ b/sql/test/proto_loader/odbc/Tests/monetodbc_datatypes.test
@@ -137,14 +137,14 @@ 12345678901234567890.123456789
onlyif has-hugeint
query I
-select cast(-92345678901234567890123456789.123456789 as decimal(38,9)) as
dec16_val
+select cast(-923456789012345678901234567890.12345678 as decimal(38,8)) as
dec16_val
----
--92345678901234567890123456789
+-923456789012345678901234567890
--query T
---select * from 'odbc:DSN=MonetDB-Test;QUERY=select
cast(-92345678901234567890123456789.123456789 as decimal(38,9)) as dec16_val'
+--select * from 'odbc:DSN=MonetDB-Test;QUERY=select
cast(-923456789012345678901234567890.12345678 as decimal(38,8)) as dec16_val'
----
--- -92345678901234567890123456789.123456789
+-- -923456789012345678901234567890.12345678
---- REAL ----
@@ -484,3 +484,34 @@ EDA7B0743E0F4BEFBDEC19C61BEDB18F
BEEFC4F7026447359B7A75FD371EF8030001020304FCFDFEFF
NULL
+---- URL ----
+
+query TTT
+select
cast('https://[email protected]:458/Doc/Abc.html?lang=nl&sort=asc#example'
as url) as val1, cast('https://me:[email protected]/Doc' as url) as val2,
cast(NULL as url) as valnil
+----
+https://[email protected]:458/Doc/Abc.html?lang=nl&sort=asc#example
+https://me:[email protected]/Doc
+NULL
+
+query TTT
+select * from 'odbc:DSN=MonetDB-Test;QUERY=select
cast(''https://[email protected]:458/Doc/Abc.html?lang=nl&sort=asc#example''
as url) as val1, cast(''https://me:[email protected]/Doc'' as url) as val2,
cast(NULL as url) as valnil'
+----
+https://[email protected]:458/Doc/Abc.html?lang=nl&sort=asc#example
+https://me:[email protected]/Doc
+NULL
+
+---- JSON ----
+
+query TTT
+select cast('{"a":"abc", "b":"def", "c" : ["abc2", "def2"]}' as json) as val1,
cast('{"track":{"segments":[{"location":[ 47.763,13.4034 ],"start
time":"2018-10-14 10:05:14","HR":73},{"location":[ 47.706,13.2635 ],"start
time":"2018-10-14 10:39:21","HR":135}]}}' as json) as val2, cast(NULL as json)
as valnil
+----
+{"a":"abc","b":"def","c":["abc2","def2"]}
+{"track":{"segments":[{"location":[47.763,13.4034],"start time":"2018-10-14
10:05:14","HR":73},{"location":[47.706,13.2635],"start time":"2018-10-14
10:39:21","HR":135}]}}
+NULL
+
+query TTT
+select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''{"a":"abc",
"b":"def", "c" : ["abc2", "def2"]}'' as json) as val1,
cast(''{"track":{"segments":[{"location":[ 47.763,13.4034 ],"start
time":"2018-10-14 10:05:14","HR":73},{"location":[ 47.706,13.2635 ],"start
time":"2018-10-14 10:39:21","HR":135}]}}'' as json) as val2, cast(NULL as json)
as valnil'
+----
+{"a":"abc","b":"def","c":["abc2","def2"]}
+{"track":{"segments":[{"location":[47.763,13.4034],"start time":"2018-10-14
10:05:14","HR":73},{"location":[47.706,13.2635],"start time":"2018-10-14
10:39:21","HR":135}]}}
+NULL
diff --git a/sql/test/sys-schema/Tests/webExamplesUrlFunctions.test
b/sql/test/sys-schema/Tests/webExamplesUrlFunctions.test
--- a/sql/test/sys-schema/Tests/webExamplesUrlFunctions.test
+++ b/sql/test/sys-schema/Tests/webExamplesUrlFunctions.test
@@ -5,12 +5,12 @@ statement ok
create table urlt (c url)
statement ok
-insert into urlt values
('https://[email protected]:458/Doc/Abc.html?lang=nl&sort=asc#example')
+insert into urlt values
('https://me:[email protected]:458/Doc/Abc.html?lang=nl&sort=asc#example')
query T nosort
select c from urlt
----
-https://[email protected]:458/Doc/Abc.html?lang=nl&sort=asc#example
+https://me:[email protected]:458/Doc/Abc.html?lang=nl&sort=asc#example
query T nosort
select sys.getanchor(c) from urlt
@@ -65,7 +65,7 @@ lang=nl&sort=asc
query T nosort
select sys.getroboturl(c) from urlt
----
-https://[email protected]:458/robots.txt
+https://me:[email protected]:458/robots.txt
query T nosort
select sys.getuser(c) from urlt
@@ -78,9 +78,9 @@ select sys.isaurl(c) from urlt
1
query T nosort
-select sys.newurl('https', '[email protected]:123', 'docs/index.html')
+select sys.newurl('https', 'usr:[email protected]:123', 'docs/index.html')
----
-https://[email protected]:123/docs/index.html
+https://usr:[email protected]:123/docs/index.html
query T nosort
select sys.newurl('https', 'www.a.com', 5567, 'docs/index.html')
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
