Release v0.5.0

[andyfengHKU]

Description

This issue tracks the list of features we are planning to release early next month

• MVCC
• Attach/Detach remote database
  • Performance benchmark
• DECIMAL data type
• API
  • Python UDF
  • Scanning from polars
  • C-API improvement
• Extension
  • User defined types
  • SQLite scanner
  • JSON
• Performance improvement
  • Hash index
  • Zone map
  • Remote file system cache
  • BM eviction queue rework
  • COPY rel mem usage optimization (optional)
• Others
  • SEQUENCE (and SERIAL)
  • CREATE TABLE IF NOT EXISTS
  • Support multiple statements in one query
  • current_date(), current_timestamp(), string_split(), string_part()
• Explorer
  • Progress bar
• Join Hint documentation and testing
• Compression
  • BIGINT
  • Decimal
• Documentation
  • Concurrency
  • Attach/Detach remote database
  • DECIMAL
  • Python UDF
  • Scanning from Polars
  • COPY from DataFrame
  • C-API
  • User defined types extension
  • SQLite scanner
  • JSON
  • SEQUENCE
  • DROP/(CREATE) TABLE IF (NOT) EXISTS
  • Multiple statements in one query
  • Clarify subquery in DDL vs. Cypher
  • New functions: current_date(), current_timestamp(), string_split(), string_part()
  • SKIP lines in COPY and LOAD FROM
• Issues
  • Bug: LOAD FROM queries in demo_db/demo_db.test fail with "Load from multiple files is not supported" #3840
  • Bug: Using explain for export database ran the query #3786
  • Bug: MATCH path with recursive relation returns nodes/rels in wrong order #3785
  • Feature: Add DROP IF EXISTS for node/rel tables #3775
  • Bug: update_rel~set_ldbc_sf01.SetLikeComment non deterministic failing in CI #3756
  • Feature: Support COPY from DataFrame #3744
  • Bug: Filtering recursive relationships: WHERE ... leads to infinite loop #3691
  • Bug: Typo in AccHashJoinOptimizer #3686
  • Bug: Issue with Kuzu to Networkx #3640
  • [Proposal]: Unify REL TABLE GROUP with REL TABLE #3627
  • Feature: Expose Decimal to Rust and (possibly) NodeJS API #3619
  • Bug: Materialized SERIAL causes RDF test to sometimes fail #3616
  • Bug: Cannot create rel table group with single group #3608
  • Bug: Unstable query in Kuzu Nightly Builds 0.4.3.23 #3605
  • Bug: Failed tests when compression is disabled #3602
  • Bug: IndexError: _Map_base::at in Kuzu v0.4.2 when executing Cypher query #3560
  • RuntimeError: Binder exception: Variable __existence already exists. #3510
  • Binder exception: Cannot retrieve child type of type ANY. LIST or ARRAY is expected. #3507
  • Binder Exception when reading ARRAY type from Parquet (for embeddings) #3481
  • Issues importing from CSVs that contain strings with quotes #3461
  • On-disk size of data.kz is large when using multiple CREATE statements #3411
  • ExpressionVisitor::isConstant failed to check constant CASE_ELSE expression #3386
  • CASE on NULL value #3097
  • Nodes not printing properly after large output. #2992
  • Missing primitive type supports for UDF/CSV writer #2513
  • Implement implicit cast when reading/exporting from/to parquet. #2345
  • Bug: Numpy version issue causes Jupyter notebook kernel crash when outputting results as Pandas #3761
  • [Python API] Using trailing , results in infinite loop / hanging #3002
  • Feature: Show data row on data load exception #3771
• Optional issues
  • Performance Bug: Scan rel is slow when bound node offsets are random #3787
  • Bug: Literal Evaluator Multiple Evaluations #3763
  • Optimization: Rel batch insert memory usage improvement #3698
  • Feature: Change range defaults and add generate_series function #3678