Skip to content

jdbc: metadata: provide nullsAreSorted*() #120

Closed
@Totktonada

Description

@Totktonada

DatabaseMetaData.

The following methods should return the following values:

  • nullsAreSortedAtEnd -- false
  • nullsAreSortedAtStart -- false
  • nullsAreSortedHigh -- false
  • nullsAreSortedLow -- true

Also we need to cover these methods with a test.

How to check:

box.cfg{}
\set language sql
create table t(id int primary key, v text);
insert into t values (1, 'a') 
insert into t values (2, 'b') 
insert into t values (3, 'c') 
insert into t values (4, null)
insert into t values (5, null)
insert into t values (6, null)
select * from T order by v
---
- - [4, null]
  - [5, null]
  - [6, null]
  - [1, 'a']
  - [2, 'b']
  - [3, 'c']
... 

select * from T order by v desc
---
- - [3, 'c']
  - [2, 'b']
  - [1, 'a']
  - [4, null]
  - [5, null]
  - [6, null]

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions