@@ -389,27 +389,28 @@ public async Task Tstzrange_array_as_array_of_Interval()
389389 {
390390 await using var conn = await OpenConnectionAsync ( ) ;
391391
392- await AssertType < Array > (
393- new [ ]
394- {
395- new Interval (
396- new LocalDateTime ( 1998 , 4 , 12 , 13 , 26 , 38 ) . InUtc ( ) . ToInstant ( ) ,
397- new LocalDateTime ( 1998 , 4 , 12 , 15 , 26 , 38 ) . InUtc ( ) . ToInstant ( ) ) ,
398- new Interval (
399- new LocalDateTime ( 1998 , 4 , 13 , 13 , 26 , 38 ) . InUtc ( ) . ToInstant ( ) ,
400- new LocalDateTime ( 1998 , 4 , 13 , 15 , 26 , 38 ) . InUtc ( ) . ToInstant ( ) ) ,
401- new Interval (
402- new LocalDateTime ( 1998 , 4 , 13 , 13 , 26 , 38 ) . InUtc ( ) . ToInstant ( ) ,
403- null ) ,
404- new Interval (
405- null ,
406- new LocalDateTime ( 1998 , 4 , 13 , 13 , 26 , 38 ) . InUtc ( ) . ToInstant ( ) ) ,
407- new Interval (
408- null ,
409- null )
410- } ,
411- """{"[\"1998-04-12 15:26:38+02\",\"1998-04-12 17:26:38+02\")","[\"1998-04-13 15:26:38+02\",\"1998-04-13 17:26:38+02\")","[\"1998-04-13 15:26:38+02\",)","(,\"1998-04-13 15:26:38+02\")","(,)"}""" ,
412- "tstzrange[]" , dataTypeInference : DataTypeInference . Nothing ) ;
392+ var value = new [ ]
393+ {
394+ new Interval (
395+ new LocalDateTime ( 1998 , 4 , 12 , 13 , 26 , 38 ) . InUtc ( ) . ToInstant ( ) ,
396+ new LocalDateTime ( 1998 , 4 , 12 , 15 , 26 , 38 ) . InUtc ( ) . ToInstant ( ) ) ,
397+ new Interval (
398+ new LocalDateTime ( 1998 , 4 , 13 , 13 , 26 , 38 ) . InUtc ( ) . ToInstant ( ) ,
399+ new LocalDateTime ( 1998 , 4 , 13 , 15 , 26 , 38 ) . InUtc ( ) . ToInstant ( ) ) ,
400+ new Interval (
401+ new LocalDateTime ( 1998 , 4 , 13 , 13 , 26 , 38 ) . InUtc ( ) . ToInstant ( ) ,
402+ null ) ,
403+ new Interval (
404+ null ,
405+ new LocalDateTime ( 1998 , 4 , 13 , 13 , 26 , 38 ) . InUtc ( ) . ToInstant ( ) ) ,
406+ new Interval (
407+ null ,
408+ null )
409+ } ;
410+ const string sqlLiteral = """{"[\"1998-04-12 15:26:38+02\",\"1998-04-12 17:26:38+02\")","[\"1998-04-13 15:26:38+02\",\"1998-04-13 17:26:38+02\")","[\"1998-04-13 15:26:38+02\",)","(,\"1998-04-13 15:26:38+02\")","(,)"}""" ;
411+
412+ await AssertTypeWrite ( conn , value , sqlLiteral , "tstzrange[]" , dataTypeInference : DataTypeInference . Nothing ) ;
413+ await AssertTypeRead < Array > ( conn , sqlLiteral , "tstzrange[]" , value ) ;
413414 }
414415
415416 [ Test ]
@@ -581,14 +582,15 @@ public async Task Daterange_array_as_array_of_DateInterval()
581582 {
582583 await using var conn = await OpenConnectionAsync ( ) ;
583584
584- await AssertType < Array > (
585- new [ ]
586- {
587- new DateInterval ( new ( 2002 , 3 , 4 ) , new ( 2002 , 3 , 5 ) ) ,
588- new DateInterval ( new ( 2002 , 3 , 8 ) , new ( 2002 , 3 , 10 ) )
589- } ,
590- """{"[2002-03-04,2002-03-06)","[2002-03-08,2002-03-11)"}""" ,
591- "daterange[]" , dataTypeInference : DataTypeInference . Nothing ) ;
585+ var value = new [ ]
586+ {
587+ new DateInterval ( new ( 2002 , 3 , 4 ) , new ( 2002 , 3 , 5 ) ) ,
588+ new DateInterval ( new ( 2002 , 3 , 8 ) , new ( 2002 , 3 , 10 ) )
589+ } ;
590+ const string sqlLiteral = """{"[2002-03-04,2002-03-06)","[2002-03-08,2002-03-11)"}""" ;
591+
592+ await AssertTypeWrite ( conn , value , sqlLiteral , "daterange[]" , dataTypeInference : DataTypeInference . Nothing ) ;
593+ await AssertTypeRead < Array > ( conn , sqlLiteral , "daterange[]" , value ) ;
592594 }
593595
594596 [ Test ]
0 commit comments