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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
#! /bin/bash
run_test ./drive_sql "select startswith('.foo', '.')"
check_output "" <<EOF
Row 0:
Column startswith('.foo', '.'): 1
EOF
run_test ./drive_sql "select startswith('foo', '.')"
check_output "" <<EOF
Row 0:
Column startswith('foo', '.'): 0
EOF
run_test ./drive_sql "select endswith('foo', '.')"
check_output "" <<EOF
Row 0:
Column endswith('foo', '.'): 0
EOF
run_test ./drive_sql "select endswith('foo.', '.')"
check_output "" <<EOF
Row 0:
Column endswith('foo.', '.'): 1
EOF
run_test ./drive_sql "select endswith('foo.txt', '.txt')"
check_output "" <<EOF
Row 0:
Column endswith('foo.txt', '.txt'): 1
EOF
run_test ./drive_sql "select endswith('a', '.txt')"
check_output "" <<EOF
Row 0:
Column endswith('a', '.txt'): 0
EOF
run_test ./drive_sql "select regexp('abcd', 'abcd')"
check_output "" <<EOF
Row 0:
Column regexp('abcd', 'abcd'): 1
EOF
run_test ./drive_sql "select regexp('bc', 'abcd')"
check_output "" <<EOF
Row 0:
Column regexp('bc', 'abcd'): 1
EOF
run_test ./drive_sql "select regexp('[e-z]+', 'abcd')"
check_output "" <<EOF
Row 0:
Column regexp('[e-z]+', 'abcd'): 0
EOF
run_test ./drive_sql "select regexp('[e-z]+', 'ea')"
check_output "" <<EOF
Row 0:
Column regexp('[e-z]+', 'ea'): 1
EOF
run_test ./drive_sql "select regexp_replace('test 1 2 3', '\\d+', 'N')"
check_output "" <<EOF
Row 0:
Column regexp_replace('test 1 2 3', '\d+', 'N'): test N N N
EOF
|
