SQLite

Check-in [bb8ee3b140]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Disable tests for json_each() and json_tree() on builds where virtual tables are not supported
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: bb8ee3b140a0a8b7c89f5debf22369f204ceef0b
User & Date: drh 2015-09-10 15:22:35.046
Context
2015-09-10
15:24
Make the sqlite3ext.h header file responsive to -DSQLITE_OMIT_LOAD_EXTENSION. (check-in: 47a46a9fa4 user: drh tags: trunk)
15:22
Disable tests for json_each() and json_tree() on builds where virtual tables are not supported (check-in: bb8ee3b140 user: drh tags: trunk)
15:20
Fix the --help option on test/releasetest.tcl. Also fix the final error count so that it includes a count of subtest crashes. (check-in: 9ecf684dfe user: drh tags: trunk)
Changes
Unified Diff Show Whitespace Changes Patch
Changes to test/json102.test.
133
134
135
136
137
138
139

140
141
142
143
144
145
146
do_execsql_test json102-470 {
  SELECT json_valid('{"x":35}');
} {{1}}
do_execsql_test json102-480 {
  SELECT json_valid('{"x":35'); -- }
} {{0}}


do_execsql_test json102-500 {
  CREATE TABLE user(name,phone);
  INSERT INTO user(name,phone) VALUES
     ('Alice','["919-555-2345","804-555-3621"]'),
     ('Bob','["201-555-8872"]'),
     ('Cindy','["704-555-9983"]'),
     ('Dave','["336-555-8421","704-555-4321","803-911-4421"]');







>







133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
do_execsql_test json102-470 {
  SELECT json_valid('{"x":35}');
} {{1}}
do_execsql_test json102-480 {
  SELECT json_valid('{"x":35'); -- }
} {{0}}

ifcapable vtab {
do_execsql_test json102-500 {
  CREATE TABLE user(name,phone);
  INSERT INTO user(name,phone) VALUES
     ('Alice','["919-555-2345","804-555-3621"]'),
     ('Bob','["201-555-8872"]'),
     ('Cindy','["704-555-9983"]'),
     ('Dave','["336-555-8421","704-555-4321","803-911-4421"]');
229
230
231
232
233
234
235
236
237
238
} {123}
do_execsql_test json102-632 {
  SELECT DISTINCT json_extract(big.json,'$.id')
    FROM big, json_tree(big.json)
   WHERE json_tree.key='uuid'
     AND json_tree.value='6fa5181e-5721-11e5-a04e-57f3d7b32808';
} {123}


finish_test







|


230
231
232
233
234
235
236
237
238
239
} {123}
do_execsql_test json102-632 {
  SELECT DISTINCT json_extract(big.json,'$.id')
    FROM big, json_tree(big.json)
   WHERE json_tree.key='uuid'
     AND json_tree.value='6fa5181e-5721-11e5-a04e-57f3d7b32808';
} {123}
} ;# end ifcapable vtab

finish_test