sqle/sqle

[DEPRECATED] See https://github.com/src-d/go-mysql-server

sqle

Installation

The import path for the package is gopkg.in/sqle/sqle.v0.

To install it, run:

go get gopkg.in/sqle/sqle.v0

Documentation

• sqle godoc

SQL syntax

We are continuously adding more functionality to gitql. We support a subset of the SQL standard, currently including:

	Supported
Comparison expressions	!=, ==, >, <, >=,<=
Null check expressions	IS NULL, IS NOT NULL
Grouping expressions	COUNT, FIRST
Standard expressions	ALIAS, LITERAL, STAR (*)
Statements	CROSS JOIN, DESCRIBE, FILTER (WHERE), GROUP BY, LIMIT, SELECT, SHOW TABLES, SORT

Powered by sqle

• gitquery

License

sqle is licensed under the MIT License.

sqle's Issues

NULL support

moved from src-d/gitbase#81

Add support for NULL values:

• A field in a schema should have a "nullable bool" field.
• Internal representation of types should use pointers (e.g. *string, not string).

add LIKE support

moved from src-d/gitbase#99

incorrect results from GROUP BY + ORDER BY

moved from gitql: src-d/gitbase#115

Panic executing: SELECT author_name from commits order by COUNT(*);

--> Executing query: SELECT author_name from commits order by COUNT(*);

panic: interface conversion: interface is string, not int32

goroutine 1 [running]:
panic(0x9839e0, 0xc420fb87c0)
	/usr/local/go/src/runtime/panic.go:500 +0x1a1
github.com/gitql/gitql/sql.(*integerType).Compare(0xd5d788, 0x949d20, 0xc4201ef910, 0x949d20, 0xc429cec240, 0xc429cec240)
	<autogenerated>:45 +0x82
github.com/gitql/gitql/sql/plan.(*sorter).Less(0xc42811bf20, 0x0, 0x1792, 0x0)
	/home/antonio/work/src/github.com/gitql/gitql/sql/plan/sort.go:156 +0x1e5
sort.medianOfThree(0xcf59c0, 0xc42811bf20, 0x0, 0x1792, 0x2f24)
	/usr/local/go/src/sort/sort.go:74 +0x49
sort.doPivot(0xcf59c0, 0xc42811bf20, 0x0, 0xbc97, 0x53a887, 0xc42006c400)
	/usr/local/go/src/sort/sort.go:99 +0x601
sort.quickSort(0xcf59c0, 0xc42811bf20, 0x0, 0xbc97, 0x1f)
	/usr/local/go/src/sort/sort.go:188 +0x83
sort.Sort(0xcf59c0, 0xc42811bf20)
	/usr/local/go/src/sort/sort.go:222 +0x80
github.com/gitql/gitql/sql/plan.(*sortIter).computeSortedRows(0xc4219fe540, 0x1, 0xb)
	/home/antonio/work/src/github.com/gitql/gitql/sql/plan/sort.go:126 +0x292
github.com/gitql/gitql/sql/plan.(*sortIter).Next(0xc4219fe540, 0xc425fc24d0, 0xc4201ef610, 0xc42030d9e0, 0x4a19fc, 0xc425fc2480)
	/home/antonio/work/src/github.com/gitql/gitql/sql/plan/sort.go:92 +0xd9
github.com/gitql/gitql/sql/plan.(*iter).Next(0xc42571f940, 0xc4201ef600, 0x1, 0x1, 0x0, 0x0)
	/home/antonio/work/src/github.com/gitql/gitql/sql/plan/project.go:65 +0x38
main.(*cmdQueryBase).printQuery(0xc4201d6b40, 0xc42571f960, 0x1, 0x1, 0xcf2700, 0xc42571f940, 0xa34a17, 0x6, 0x0, 0x0)
	/home/antonio/work/src/github.com/gitql/gitql/cmd/gitql/query_base.go:65 +0x222
main.(*CmdShell).Execute(0xc4201d6b40, 0xc4201a96c0, 0x0, 0x1, 0x1, 0x1)
	/home/antonio/work/src/github.com/gitql/gitql/cmd/gitql/shell.go:75 +0xa5a
github.com/jessevdk/go-flags.(*Parser).ParseArgs(0xc420022a20, 0xc42000c5f0, 0x1, 0x1, 0x4, 0x2, 0xc42001c900, 0xc4200ab080, 0xc4200aaf48)
	/home/antonio/work/src/github.com/jessevdk/go-flags/parser.go:316 +0x8e6
github.com/jessevdk/go-flags.(*Parser).Parse(0xc420022a20, 0xa36250, 0x7, 0xa44624, 0x1d, 0x0)
	/home/antonio/work/src/github.com/jessevdk/go-flags/parser.go:186 +0x74
main.main()
	/home/antonio/work/src/github.com/gitql/gitql/cmd/gitql/main.go:16 +0x38b

support prepared statements

moved from src-d/gitbase#94