File: gh-4697-scalar-bool-sort-cmp.result

package info (click to toggle)
tarantool 2.6.0-1.2
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 85,396 kB
  • sloc: ansic: 513,775; cpp: 69,493; sh: 25,650; python: 19,190; perl: 14,973; makefile: 4,176; yacc: 1,329; sql: 1,074; pascal: 620; ruby: 190; awk: 18; lisp: 7
file content (53 lines) | stat: -rw-r--r-- 1,116 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
-- test-run result file version 2
CREATE TABLE test (s1 INTEGER PRIMARY KEY, s2 SCALAR UNIQUE, s3 SCALAR);
 | ---
 | - row_count: 1
 | ...
INSERT INTO test VALUES (0, 1, 1);
 | ---
 | - row_count: 1
 | ...
INSERT INTO test VALUES (1, 1.1, 1.1);
 | ---
 | - row_count: 1
 | ...
INSERT INTO test VALUES (2, true, true);
 | ---
 | - row_count: 1
 | ...
INSERT INTO test VALUES (3, NULL, NULL);
 | ---
 | - row_count: 1
 | ...

--
-- gh-4679: Make sure that boolean precedes any number within
-- scalar. Result with order by indexed (using index) and
-- non-indexed (using no index) must be the same.
--
SELECT s2, typeof(s2) FROM test ORDER BY s2;
 | ---
 | - metadata:
 |   - name: S2
 |     type: scalar
 |   - name: COLUMN_1
 |     type: string
 |   rows:
 |   - [null, 'boolean']
 |   - [true, 'boolean']
 |   - [1, 'integer']
 |   - [1.1, 'double']
 | ...
SELECT s3, typeof(s3) FROM test ORDER BY s3;
 | ---
 | - metadata:
 |   - name: S3
 |     type: scalar
 |   - name: COLUMN_1
 |     type: string
 |   rows:
 |   - [null, 'boolean']
 |   - [true, 'boolean']
 |   - [1, 'integer']
 |   - [1.1, 'double']
 | ...