query-engine

Need to migrate trino-maven-plugin to use GitHub actions instead of Travis CI. See trinodb/trino#6859 for some guidance.

I'm not sure how feasible this may be, but the old logparser program from Microsoft supported queries like

Select * from test.csv

And it would read from test.csv, without needing any config files.

Calling db.Drop when a bucket does not exist returns "bucket not found" and that error is directly from bolt's bolt.ErrBucketNotFound, I believe this error should be translated to storm.ErrNotFound.

TPC-DS has many queries with IN predicates where all elements are constants. It's a low-hanging fruit if we could implement an InSet function for this all constants value case.

While implementing this, we could either use a hashtable or a chain of if-elif-else, depending on the length and the type of the constants array.

Q8:

 WHERE substr(ca_zip, 1, 5) IN (
               '2412

Spinning up an instance;

import (
	"github.com/dolthub/go-mysql-server/auth"
	"github.com/dolthub/go-mysql-server/memory"
	"github.com/dolthub/go-mysql-server/server"
	"github.com/dolthub/go-mysql-server/sql"
	"github.com/dolthub/go-mysql-server/sql/information_schema"
)

func main() {
	engine := sqle.NewDefault(
		sql.NewDatabaseProvider(
			memory.NewDatabase(TEST_DB_MYSQL_DAT

Per discussion in #2743 this class is mis-named.

Also, rename LinkStreamValue to just plain LinkStream.