elliotchance/eagle

🦅 Eagle is a highly parallel column-oriented embedded SQL database engine.

eagle's Issues

All *_Delete() functions must allow NULL input.

A NULL input will cause _Delete() to crash in some situations.

Comparison operators

=
!=
>
<
>=
<=

Check for missing docs

Doxygen does not warn when documentation is missing from C. Maybe there is another command line tool out there to do this?

Move functions from bison to EagleDbParser

Keep the parser and lexer clean.

Implement some kind of checkstyle/static analyser

Add the clang static analyser to the release target. Look into adding a static analyser as well.

Auto install git hook for issue number

github executable should setup a pre commit hook that adds the issue number to the commit message if on an issue branch like:

[#34] Some commit message.

Analyze is not stopping makefile

When there are clang analyzer problems it does not stop the release.

Enforce docblocks and param direction.

All functions need a doc block and their params need [in], [out] etc

MemorySuite for malloc failures

Every malloc() must be tested as failing. Code must be recoverable with zero leaks.

Need to run test suite under normal conditions as well

A bug has been found the SQL fuzz suite that only occurs when guard malloc and scribble is turned of. This means that tests must be run under these two alternate environments.

Makefile coverage is not calculating properly

I don't know why but the percentage calculated from the HTML coverage is coming out wrong because the order in the file has changed. It need to be a bit smarted than it is now to handle this.

Create tests for parser problems

There is no sanity checking on when parser limits like yyobj are reached.

DESCRIBE grammar

For displaying the definition of a table.

Better code coverage without SQLSuite

Don't rely on SQLSuite to get code coverage.

Allow maximum memory usage

Support NULLs

Verify operator precedence

Make sure that all operators are in the correct mathematical precedence. Some complex testing will need to be setup.

UPDATE syntax

Turn allocated/used into linked list

Many of the resizable arrays in structs use this, they should be a linked list where possible

Synchronize yyparse()

This must be synchronized since it's not thread safe.

Enforce minimum coverage percentage

At the moment coverage data generated at release does not require a minimum percentage.

Make suites selectable on eagle_test

By default eagle_test should print out a help message. Each argument is a test suite, or "all" like:

eagle_test all
eagle_test memory sqlfuzz

Improve AddSuite

It's annoying to write tests and have to add the test names to a separate list, this can all be done in the same macro.

Fuzz testing for SELECT, INSERT etc

At the moment it only tests fuzz on SELECT.

100% code coverage

Disallow "./github fix" on with staged changes

The repository must be clean to allow this.

Check memory management

There is some confusion about variables that go into constructors being freed with their parent object when they shouldn't be. Check all objects to make sure they do not free memory or objects that they did not specifically create.

Doxygen warnings need to be errors

When doxygen prints out warnings it still returns a success code.

Support * operator in SELECT

To select all the fields in a table.

Safe macro for strcat()

There needs to be a safe macro for strcat() and strncat()

Better fuzz testing on SQL

Need more testing on unexpected tokens for stability and memory leaks. Some situations do cause the parser to crash.

Create custom getters for EagleLinkedList_get()

Where this is used it can often be replaced with a more appropriate getter function for that object.

Need a logger

Proper logging suite

INSERT syntax for bulk

INSERT INTO table (a, b, c) VALUES (1, 2, 3), (4, 5, 6), ...

Upload gh-pages on fix

Should upload the latest gh-pages docs and coverage when an issue is fixed.

Add README for GitHub.

Create database schema framework

There is a virtual schema called eagledb and there is a concrete default schema.

The "database" is the instance. Since the SQL standard says databases can never interact each database will require its own independent EagleDbInstance.

SQL statements must end in ;

THis is at the parser level and is important for the console.

Add TEXT data type

Disallow reserved words for tables etc

Stop tables, columns, etc from being named reserved words.

Create virtual `eagledb.table`

This will return all the tables in all the schemas.

SQL keywords should not be case sensitive

DELETE syntax

Safe malloc() and free()

Need macros for safe malloc(), calloc() that will throw a signal if failed. Also free() needs to reset the pointer to NULL.

Add branch coverage information

HTML coverage report needs to include branch data.

Create benchmark suite

A testing suite for benchmarking.

CREATE TABLE syntax

INSERT syntax

Arithmetic operators

+
-
*
/
%

Do not allow committing to master

Also the hook that gets the issue number and puts it in the commit message should only do so if its an issue branch.