kawasin73

Search the TODO comment with "IndexInfo should hold ValueCmp instead of ConstantValue".

apply `"%!.15g"` printf format to the float value. * https://github.com/kawasin73/prsqlite/issues/7#issuecomment-1685411093 * https://github.com/kawasin73/prsqlite/issues/7#issuecomment-1685418559

alphabets, digits, `_`, `$` are supported for identifier * `tokenize.c` ``` /* ** If X is a character that can be used in an identifier then ** IdChar(X) will be...

numeric-literal except hexadecimal is done by #13 https://www.sqlite.org/lang_expr.html#literal_values_constants_ https://www.sqlite.org/syntax/numeric-literal.html

* SQLite supports using utf8 characters (even non ascii) for identifiers (e.g. table name). * text should be handled by `&str` or `String`. However validating utf8 sequence to convert `&[u8]`...

The table map consider the table name as case insensitive. The table map in Schema is `tables: HashMap` which requires the table name to be cloned and clone the search...

Parse sqlite_schema

2

sqlite_schema is used to know table information.

Investigate sqlite spec

4

* [SQLite Documentation](https://www.sqlite.org/docs.html) * https://github.com/sqlite/sqlite main important document * [Architecture of SQLite](https://www.sqlite.org/arch.html) * [The SQLite Bytecode Engine](https://www.sqlite.org/opcode.html)

sqlite computes the b-tree page header by ternary operator. ```c first = hdr + ((flags&PTF_LEAF)==0 ? 12 : 8); ``` https://github.com/sqlite/sqlite/blob/e17cac189fb40f4b1ccca04e54bf8163de555ae3/src/btree.c#L2162 But we can compute it without conditional branch. ```rust...