Version 2.1.2-release, 10 oct 2013

New features

  • added FLUSH RAMCHUNK statement
  • added SHOW PLAN statement
  • added support for GROUP BY on multiple attributes
  • added BM25F() function to SELECT expressions (now works with the expression based ranker)
  • added indextool --fold command and -q switch
  • added JSON debug check for RT index RAM chunk
  • added LENGTH() function for MVA
  • added missing rt_attr_bool directive
  • added support for selecting over 250 columns via SphinxQL
  • deprecated custom sort mode, and str2ordinal and str2wordcount attribute types
  • optimized SELECT, UPDATE for indexes with many attributes (up to 3.5x speedup in extreme cases)
  • JSON attributes (up to 5-20% faster SELECTs using JSON objects)
  • optimized xmlpipe2 indexing (up to 9 times faster on some schemas)

Bug fixes

  • fixed #1684, COUNT(DISTINCT smth) with implicit GROUP BY returns correct value now
  • fixed #1672, exact token AOT vs lemma (indexer skips exact form of token that passed AOT through tokenizer)
  • fixed #1659, fail while loading empty infix dictionary with dict=keywords
  • fixed #1638, force explicit JSON type conversion for aggregate functions
  • fixed #1628, GROUP_CONCAT() and GROUPBY() support for distributed agents
  • fixed #1619, INTEGER() conversion function doesn't support signed integers
  • fixed #1615, global IDF vs exact term (=term) fixed global IDF for missed terms fixed SphinxQL global_idf=0 option
  • fixed #1607, now ignoring binlog when running daemon with --console flag
  • fixed #1606, hard interruption of the daemon by Ctrl+C (SIGINT) signal
  • fixed #1592, duplicates vs expression ranker
  • fixed #1578, SORT BY string attribute via API attr_asc \ attr_desc
  • fixed #1575, crash of daemon on MVA receive from agents with dist_threads enabled
  • fixed #1574, agent got kill list of local indexes of distributed index
  • fixed #1573, ranker expression vs expanded terms
  • fixed #1572, BM25F vs negative terms
  • fixed #1550, float got cut at full-text part of a query
  • fixed #1541, BM25F expression in distributes indexes
  • fixed #1508, #1522, distributed index query lasts up to agent_connect_timeout with epoll path
  • fixed #1508, master failed to connect waiting agents up to agent_connect_timeout time
  • fixed #1489, filtering by integer field in JSON using floating point precision
  • fixed #1485, index_exact_words vs keyword dict with infix
  • fixed #1484, INSERT into RT vs no JSON attribute
  • fixed #1478, memory leaks at daemon PACKEDFACTORS() as UDF argument, index query tokenizer, expression ranker SUM()
  • fixed #1470, broken UDF unpack (since r3738 UDF version 2)
  • fixed #1468, multiple conditions in WHERE for JSON attributes
  • fixed #1466, index_field_lengths vs XML data source
  • fixed #1463, daemon shutdown vs RT index optimize (added forced terminate of long merging operation)
  • fixed #1460, aggregate functions AVG(), MAX(), MIN(), SUM() do not work for JSON attributes
  • fixed #1459, BM25F doesn't work with field_string fields
  • fixed #1458, factors to copy field_tf at UDF
  • fixed #1450, garbage in JSON fields when selecting them from a RT index
  • fixed #1449, broken build on Mac OS X
  • fixed #1446, WEIGHT() did not work in SELECT expressions
  • fixed #1445, field-start/field-end modifiers did not work for star-expanded keywords
  • fixed #1443, morphology=lemmatizer_ru_all now works with index_exact_words=1 (exact forms can be matches)
  • fixed #1442, incorrect COUNT(*) value in queries to distributed indexes with implicit GROUP BY
  • fixed #1439, filters on float values in JSON issue, string values quoting issue
  • fixed #1399, filter error message on string attribute
  • fixed #1384, added possibility to define any own DSN line with source=mssql (like as in source=odbc)
  • fixed ATTACH vs wordforms or stopwords; after daemon was restarted this setting was getting lost in RT indexes
  • fixed balancing of agents in HA
  • fixed co-working of index_exact_word + AOT lemmatizer
  • fixed epoll invoking and turned on by default
  • fixed incorrect handling of wildcards in tokenizer
  • fixed infix indexing with dict=keywords
  • fixed max_predicted_time integer overflows
  • fixed memory error in tokenizer
  • fixed several memory leaks
  • fixed PACKEDFACTORS() to work in different GROUP BY queries
  • fixed preprocessor definitions for RE2 in VS solution
  • fixed rotation of global IDF for workers=threads and seamless_rotate=1
  • fixed rotation of old indexes
  • fixed RT kill list survives TRUNCATE and works in newly ATTACHed index
  • fixed saving id32 RT index with id64 daemon
  • fixed stemmer vs RT index INSERT
  • fixed string case error with JSON attributes in select list of a query
  • fixed TOP_COUNT usage in misc/suggest and updated to PHP 5.3 and UTF-8
News
Downloads
Services
Community
Resources
About