shunwang / redisql

Automatically exported from code.google.com/p/redisql
0 stars 0 forks source link

support more SQL #3

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

The following SQL functionality is planned for the next release

1.) ORDER BY indexed_column - only a single ordering and only on indexed columns
2.) WHERE index_column IN (x,yz)
3.) WHERE indexed_column LIKE "pattern*" - no "*" or "%" at beginning
4.) SCANSELECT full table joins
5.) SCANSELECT ... STORE
6.) SELECT MIN(), MAX(), COUNT(*) - but w/o grouping
7.) CREATE TABLE (column auto increment)
8.) multiple column indices

Original issue reported on code.google.com by jaksprats on 22 Sep 2010 at 8:33

GoogleCodeExporter commented 9 years ago
1 and 2 are done

6 and 7 will be done by the end of Oct

Original comment by jaksprats on 21 Oct 2010 at 8:49

GoogleCodeExporter commented 9 years ago
1 and 2 are done

6 and 7 will be done by the end of Oct

Original comment by jaksprats on 21 Oct 2010 at 8:49

GoogleCodeExporter commented 9 years ago
SELECT COUNT(*) has been done for a while

the next up are
A.) Order By Multiple column sorting
B.) Multiple Column Indexing

looks like the end of October prediction was just BAD

Original comment by jaksprats on 4 Jan 2011 at 7:38

GoogleCodeExporter commented 9 years ago
"Order By Multiple column sorting" is DONE

Original comment by jaksprats on 12 Jan 2011 at 10:34