mirrors/limbo
1
0
Fork 0
mirror of https://github.com/tursodatabase/limbo.git synced 2025-07-09 21:45:00 +00:00
Code Issues Projects Releases Packages Wiki Activity Actions 20
limbo/testing
History
Exact
Pekka Enberg c6ef19396d Merge 'Add support for pragma table-valued functions' from Piotr Rżysko 
This PR adds support for table-valued functions for PRAGMAs (see the
[PRAGMA functions section](https://www.sqlite.org/pragma.html)).
Additionally, it introduces built-in table-valued functions. I
considered using extensions for this, but there are several reasons in
favor of a dedicated mechanism:
* It simplifies the use of internal functions, structs, etc. For
example, when implementing `json_each` and `json_tree`, direct access to
internals was necessary:
https://github.com/tursodatabase/limbo/pull/1088
* It avoids FFI overhead. [Benchmarks](https://github.com/piotrrzysko/li
mbo/blob/pragma_vtabs_bench/core/benches/pragma_benchmarks.rs) on my
hardware show that `pragma_table_info()` implemented as an extension is
2.5× slower than the built-in version.

Reviewed-by: Jussi Saurio <jussi.saurio@gmail.com>

Closes #1642
2025-06-04 09:08:10 +03:00
..
cli_tests Merge 'Add support for pragma table-valued functions' from Piotr Rżysko 2025-06-04 09:08:10 +03:00
test_files Fix import csv failing when single quote is in string 2025-01-11 13:48:21 +05:30
wal testing: Add test database + WAL file 2024-08-03 12:16:34 +03:00
agg-functions.test Add tcl test for non-groupby distinct aggregation 2025-05-17 15:33:55 +03:00
all.test make values work in subquery 2025-05-23 00:30:04 +08:00
alter_table.test feat: initial implementation of ALTER TABLE 2025-05-08 09:24:56 -03:00
boolean.test Fix incompatibility AND Expression 2025-04-13 22:38:43 -03:00
changes.test Created basic tcl tests for changes and total_changes 2025-01-19 20:51:16 -05:00
cmdlineshell.test refactor(testing): move .table tests to shelltests.py 2024-12-18 09:10:37 +02:00
coalesce.test extend TCL tests for COALESCE 2025-02-09 22:01:33 +04:00
collate.test only pass collations for index in cursor + adhere to order of columns in index 2025-05-19 15:22:55 -03:00
compare.test Add Null comparision tests 2025-01-19 00:39:10 +05:30
concat.test Added Concat Opcode 2025-01-21 00:29:23 +05:30
create_table.test add tests 2025-05-18 12:43:11 -03:00
default_value.test core/translate: Add support for default values in INSERT statements 2025-04-04 01:32:13 -03:00
delete.test Fix cursors not being opened for indexes in DELETE 2025-06-03 14:45:01 +03:00
drop_index.test Test DROP INDEX 2025-05-04 12:18:36 +03:00
drop_table.test Test that DROP TABLE also deletes the related indices 2025-05-03 12:41:19 +03:00
gen-database.py testing: update testing with products table and cross join test 2024-07-09 18:08:16 +02:00
glob.test Fix glob 2024-12-30 17:02:31 +05:30
groupby.test Support distinct aggregates in GROUP BY 2025-05-17 15:33:55 +03:00
insert.test Convert u64 rowid to i64 2025-05-30 13:07:31 +02:00
join.test Fix bug: left join null flag not being cleared 2025-04-19 13:56:52 +03:00
json.test make tests pass 2025-03-30 18:58:38 +03:00
like.test Escape character is ignored in LIKE function #1051 2025-03-01 18:32:09 +01:00
literal.test handle int64 overflow by f64 2025-05-08 22:22:55 +08:00
math.test Merge 'Parse hex integers 2' from Anton Harniakou 2025-04-16 11:13:01 +03:00
null.test Support isnull and notnull expr 2025-05-11 23:47:30 +08:00
offset.test Created TCL tests for select queries with offset 2025-01-26 16:40:30 -05:00
orderby.test Add another test 2025-05-23 14:33:55 +03:00
pragma.test Add support for pragma table-valued functions 2025-06-01 10:25:42 +02:00
pyproject.toml post rebase adjustments to accomodate new instructions that were created before the merge conflicts 2025-05-19 15:22:15 -03:00
README.md setup uv for limbo 2025-04-15 12:45:46 -03:00
scalar-functions-datetime.test Bump julian_day_converter to 0.4.5 2025-04-14 20:57:54 +08:00
scalar-functions-printf.test test fix 2025-02-04 21:02:51 +05:30
scalar-functions.test correctly handle edge cases 2025-04-11 08:34:29 +05:30
select.test UNION 2025-05-25 21:23:04 +03:00
subquery.test Add basic select distinct TCL test 2025-05-22 16:51:03 +03:00
tester.tcl Get the table correctly from the connection instead of table_references + test to confirm unique constraint 2025-05-19 15:22:55 -03:00
testing.db index scan wip foo doesnt work yet 2024-10-05 18:25:04 +03:00
testing_norowidalias.db Run all tcl tests on 2 separate dbs (1. with rowid aliases 2. without rowid aliases) 2024-12-14 17:13:45 +02:00
testing_small.db implement is and is not where constraints 2025-01-31 23:01:49 -05:00
testing_small.db-wal implement is and is not where constraints 2025-01-31 23:01:49 -05:00
testing_user_version_10.db Add read implementation of user_version pragma with ReadCookie opcode 2025-02-07 09:23:48 -05:00
time.test extensions/time: normalize offset_sec 2025-02-19 21:25:14 +08:00
total-changes.test Created basic tcl tests for changes and total_changes 2025-01-19 20:51:16 -05:00
transactions.test Implement deferred transactions 2025-03-17 10:01:00 -03:00
update.test return_io when restoring context 2025-06-01 03:07:16 -03:00
values.test simpify values when it's subquery 2025-05-23 17:45:56 +08:00
vector.test testing: Add few TCL tests for vector extensions 2025-01-28 14:24:09 +02:00
where.test Add TCL regression test 2025-04-12 11:13:32 +03:00

README.md

Limbo Testing