TODO.org.txt

* TODO Need to get server output for 'l', 'r' versions from SQLCommand and/or SQLQuery
** Document these clearly in the docs folder.  Then decide how we can move the reading of the final 0 byte out of readResultSet
* TODO Write GitHub issue for stale GlobalProperties problem and possible solutions (including parsing of the queries and adding specific "create property" commands in the native API -> how does Java client do it?
* DONE Queries to try:
** DONE CREATE PROPERTY Cat.tags EMBEDDEDLIST STRING
** DONE ALTER PROPERTY Cat.gender REGEXP [M|F]
** DONE DROP PROPERTY Cat.gender  => feeds into the stale GlobalProperties problem
** DONE Try query: insert into Person content {"name": "Charlie", "age":10}
* DONE Write ReloadSchema in obinary/dbCommands
* TODO Learn what different fetchPlan options are in OrientDB and try those in ogonori
** I suspect any that pull links will fail, since I don't yet know how to support links
* TODO Run the go static analysis tool that checks for places not checking error return values
* TODO Write SerDe Serializer
* TODO Advanced queries to try:
** DONE INSERT INTO Diver SET name = 'Bill', buddy = (SELECT FROM Diver WHERE name = 'Max')
** DONE INSERT INTO Husband SET name = 'Wayne', wife = (INSERT into Diver name = 'Jill')
** DONE SELECT FROM [#10:3, #10:4, #10:5]
** DONE SELECT FROM Profile ORDER BY @rid DESC
** TODO SELECT FROM Profile 
   LET $city = address.city
   WHERE $city.name like '%Saint%' and 
        ($city.country.name = 'Italy' or $city.country.name = 'France')
* TODO [#C] ODatabase#ClustCfg is just a binary blob -> parse that and decide what to keep
* TODO [#C] Determine if result of SQLQuery needs a ResultSet cursor for large queries?  Review what Java client does.
* DONE Re-evaluate db/network reader API -> think about building better byteBuffer -> DONE for reader, NOT for writer
** See https://github.com/djherbis/buffer for ideas

* TODO Test with MANDATORY/NOT NULL fields
* TODO Test with documents that have different types for the same field (this is allowed - one could have a string and another an int, eg, as long as you haven't defined a schema property (?))

# ---[ Command Implementations ]--- #
* TODO REQUEST_SHUTDOWN                       = 1
* DONE REQUEST_CONNECT                        = 2
* DONE REQUEST_DB_OPEN                        = 3
* DONE REQUEST_DB_CREATE                      = 4
* DONE REQUEST_DB_CLOSE                       = 5
* DONE REQUEST_DB_EXIST                       = 6
* DONE REQUEST_DB_DROP                        = 7
* DONE REQUEST_DB_SIZE                        = 8
* DONE REQUEST_DB_COUNTRECORDS                = 9
* DONE REQUEST_DATACLUSTER_ADD                = 10
* DONE REQUEST_DATACLUSTER_DROP               = 11
* DONE REQUEST_DATACLUSTER_COUNT              = 12
* DONE REQUEST_DATACLUSTER_DATARANGE          = 13
* TODO REQUEST_DATACLUSTER_COPY               = 14
* TODO REQUEST_DATACLUSTER_LH_CLUSTER_IS_USED = 16 // since 1.2.0
* TODO REQUEST_DATASEGMENT_ADD                = 20
* TODO REQUEST_DATASEGMENT_DROP               = 21
* TODO REQUEST_RECORD_METADATA                = 29 // since 1.4.0
* DONE REQUEST_RECORD_LOAD                    = 30  => fully done ??
* TODO REQUEST_RECORD_CREATE                  = 31
* TODO REQUEST_RECORD_UPDATE                  = 32
* DONE REQUEST_RECORD_DELETE                  = 33
* TODO REQUEST_RECORD_COPY                    = 34
* TODO REQUEST_POSITIONS_HIGHER               = 36 // since 1.3.0
* TODO REQUEST_POSITIONS_LOWER                = 37 // since 1.3.0
* TODO REQUEST_RECORD_CLEAN_OUT               = 38 // since 1.3.0
* TODO REQUEST_POSITIONS_FLOOR                = 39 // since 1.3.0
* DEFERRED REQUEST_COUNT                      = 40 // DEPRECATED: USE REQUEST_DATACLUSTER_COUNT
* DONE REQUEST_COMMAND                 = 41
* TODO REQUEST_POSITIONS_CEILING              = 42 // since 1.3.0
* TODO REQUEST_RECORD_HIDE                    = 43 // since 1.7
* TODO REQUEST_TX_COMMIT                      = 60
* TODO REQUEST_CONFIG_GET                     = 70
* TODO REQUEST_CONFIG_SET                     = 71
* TODO REQUEST_CONFIG_LIST                    = 72
* TODO REQUEST_DB_RELOAD                      = 73 // SINCE 1.0rc4
* DONE REQUEST_DB_LIST                        = 74 // SINCE 1.0rc6
* TODO REQUEST_PUSH_DISTRIB_CONFIG            = 80
* TODO REQUEST_DB_COPY     = 90 // SINCE 1.0rc8
* TODO REQUEST_REPLICATION = 91 // SINCE 1.0
* TODO REQUEST_CLUSTER     = 92 // SINCE 1.0
* TODO REQUEST_DB_TRANSFER = 93 // SINCE 1.0.2
* TODO REQUEST_DB_FREEZE           = 94 // SINCE 1.1.0
* TODO REQUEST_DB_RELEASE          = 95 // SINCE 1.1.0
* TODO REQUEST_DATACLUSTER_FREEZE  = 96
* TODO REQUEST_DATACLUSTER_RELEASE = 97
* TODO REQUEST_CREATE_SBTREE_BONSAI            = 110
* TODO REQUEST_SBTREE_BONSAI_GET               = 111
* DONE REQUEST_SBTREE_BONSAI_FIRST_KEY         = 112
* DONE REQUEST_SBTREE_BONSAI_GET_ENTRIES_MAJOR = 113
* DONE REQUEST_RIDBAG_GET_SIZE                 = 114


Issues:

New REQUEST_TYPES in latest version of binary protocol ...

Multi-threading testing => properties look ups

Handling of OType.ANY