chai

chai copied to clipboard

I got a painc error when I creating the index

2

### What version of Genji are you using? $ genji version ```shell Genji v0.15.0 Genji CLI v0.15.0 ``` ### What did you do? ```sql CREATE SEQUENCE IF NOT EXISTS seq_cizu;...

startan

Paginations

1

I am trying to built a service that does pagination . I am not sure of the syntax that is appropriate for this . The docs don’t mention anything so...

gedw99

Add `len` function for array type

2

### Proposal Currently, it’s not possible to compute the length of array type in Genji

icexin

select: return error if field doesn't exist on tables with strict schema

1

This PR fixes #465.

tzzed

### Proposal Currently user can't extend the function of Genji except to submit PR to Genji repo, can we expose the custom function api to user? ### Motivation Add custom...

icexin

SELECT: If the schema is strict and a projected field doesn't exist, we should return an error

5

```sql genji> create table foo(a int); genji> insert into foo (a) values (1); genji> select a, b from foo; { "a": 1, "b": null } ``` An error should be...

asdine

Even though it is technically possible to pass expressions to LIMIT and OFFSET, the `docs.Take` and `docs.Skip` operators expect integers, which doesn't make them very flexible. The docs.Take and docs.Skip...

asdine

```sql CREATE TABLE foo(a, b); INSERT INTO foo(a, b, c) VALUES (1, 2, 3); -- error -- this notation is fine, it allows inserting large documents but only keeping the...

asdine

Given the following table: ```sql CREATE TABLE foo (a INT PRIMARY KEY); ``` ```sql genji> explain select * from foo where a > 10 AND a < 100; { "plan":...

asdine

```sql -- as a field constraint CREATE TABLE foo( a INT PRIMARY KEY DESC, b INT, c INT ) -- as a table constraint CREATE TABLE foo( a INT, b...

asdine