github.com/lmorg/murex@v0.0.0-20240217211045-e081c89cd4ef/docs/changelog/v2.5.md (about) 1 # v2.5 2 3 This release introduces a number of new builtins, fixes some regression bugs and supercharges the `select` optional builtin (which I plan to include into the core builtins for non-Windows users in the next release). 4 5 ### Features: 6 7 * `alter` now supports `--sum` where structures are merged and numeric values are added together 8 9 * New builtin `count`. This has deprecated `len` however `len` will stick around as an alias for backwards compatibility 10 11 * New operators added to `let`: `+=`, `-=`, `/=`, `*=` 12 13 * New builtin `addheading` for adding headings to lists 14 15 * Compiled profile will now always execute even if Murex flags set to ignore the modules/user profile. This is so that aliases like `len` get set and thus Murex can still move forward with changes to builtins but without breaking backwards compatibility 16 17 * `autocomplete` now passes `ISMETHOD` variable to dynamic completions so those dynamic completions are aware if a command requesting auto-completion suggestions is being invoked as a method (mid-pipeline) or function (start of a pipeline) 18 19 * Index, `[`, now supports inlining element, `[[`, lookups. eg `[ a b [/map/c] ]` 20 21 * Dynamic auto-completions that include `@IncFiles` or `@IncDirs` will now automatically append files and/or directories to their auto-completion suggestions 22 23 * New `autocomplete` directives: `IncExeAll` (like `IncExePath` but includes builtins, functions, aliases), `IncManPage` (include results from the `man` page parser -- usually suppressed when `autocomplete` config is set) 24 25 * Disabled 'Loading default profile' message -- this was always pretty redundant but now that the compiled profile is being loaded all the time (eg `murex -c 'command'` or when called in a shebang), it's also now ugly too 26 27 * `select` now supports passing a file in the **FROM** syntax. eg `select * FROM ./example.csv`. The caveat here is this breaks currently auto-complete on column names 28 29 * `select` now supports multiple tables using either named pipes (eg `select * FROM <table1>, <table2>`) or variables (eg `select * FROM \$table1, \$table2`) passed in the **FROM** syntax. Variables should be escaped and you cannot mix and match between named pipes, file names nor variables. You can use any number of tables from 1 to 2^63-1 (64bit systems) or 1 to 2^31-1 (32bit systems). Which should be more than enough ;) 30 31 * `config` option for `select` to define default output data type where multiple tables are imported 32 33 * Lots of new and updated documentation! 34 35 ### Non-user facing changes (internal changes to the Murex code base): 36 37 * `open` functions can now be called by other functions to take advantage of auto-typing and auto gunzip etc. 38 39 * `tmp.Close()` should return `err`. This isn't a bug but it might catch future bugs 40 41 * `LazyLogging` created to speed up writing tests against data structures 42 43 * `utils/List` package created to handle list / array / map functions. Also makes testing more complex routines easier 44 45 ### Bug fixes: 46 47 * Regression bug fixed where `prepend` was invoking `append` 48 49 * `streams.ReadCloser` not setting context 50 51 * `parameters.StringArray()` should copy values instead of a pointer to ensure the underlying parameters are immutable 52 53 <hr> 54 55 Published: 12.02.2022 at 16:16 56 57 ## See Also 58 59 * [Pipeline](../user-guide/pipeline.md): 60 Overview of what a "pipeline" is 61 * [`<read-named-pipe>`](../parser/namedpipe.md): 62 Reads from a Murex named pipe 63 * [`alter`](../commands/alter.md): 64 Change a value within a structured data-type and pass that change along the pipeline without altering the original source input 65 * [`autocomplete`](../commands/autocomplete.md): 66 Set definitions for tab-completion in the command line 67 * [`config`](../commands/config.md): 68 Query or define Murex runtime settings 69 * [`count`](../commands/count.md): 70 Count items in a map, list or array 71 * [`let`](../commands/let.md): 72 Evaluate a mathematical function and assign to variable (deprecated) 73 * [`pipe`](../commands/pipe.md): 74 Manage Murex named pipes 75 * [`select`](../optional/select.md): 76 Inlining SQL into shell pipelines 77 * [`set`](../commands/set.md): 78 Define a local variable and set it's value 79 80 <hr/> 81 82 This document was generated from [gen/changelog/v2.5_doc.yaml](https://github.com/lmorg/murex/blob/master/gen/changelog/v2.5_doc.yaml).