Jd/Release

From J Wiki
Jump to: navigation, search
Jd | Overview | General | Ops | Admin | Guide | Technical | Release | License | Support

The Jd wiki is dynamic. It has the latest corrections, expansions, and changes. It reflects not just the latest release, but development work that hasn't been finalized or released. It reflects the bleeding edge and may not be relevant for the version you are running.

A snapshot of Jd wiki is converted to htm and included in a release.

For the latest on Jd, use the wiki. For details relevant to your release, see doc/index.htm.

2017 April 27 - version 3.3

  • Jd wiki - latest Jd documentation at: http://code.jsoftware.com/wiki/Jd/Index
  • Jd wiki snapshot (release specific) at: ~addons/data/ide/doc/Index.htm
  • update bug - bad shape deleted record
  • modify bug - bad shape truncated byte data
  • info validate/validate - col c marks bad tlen - col s marks bad fsize
  • new jd shared library version 7
  • db log.txt limited in size to 16mb
  • table... changes - srcdan removed as arg from all except tablemove
  • csv column names - bugs in utf8 and special chars fixed
  • csv cdefs cols names can now be any valid Jd col name
  • csv BOM UTF8 (239 187 191{.a.) skipped
  • csv cdefs # starts a comment line
  • csv csvcdefs creates cdefs with default " and NO for escape
  • csv cdefs AUTO no longer supported (handled in csvcdefs)
  • csvprobe op to examine csv file
  • csvscan - scans csv file and updates cdefs to have proper byte widths
  • csvcdefs /u no longer takes value - value is derived from data
  • csv tutorial reworked
  • csv_load tutorial added

2016 May 12 - version 3.2

  • partitioned table - significant new facility - see tutorial ptable
  • invalid epoch data passes precision assertions
  • default epoch and sfe display does not have Z suffix
  • table/column/dan name validation (General|Names)
  • read op parsing reworked and some bugs fixed
  • documentation of ops reorganized and improved
  • readtc requires jdtc clause (:::s::: no longer supported)
  • validate no longer done before/after insert/update/modify/delete
  • Tlen (active+deleted rows) maintained in table state
  • S_deleted (deleted rows) maintained in table state
  • info summary uses Tlen/S_deleted - fast as no read of jdactive
  • info improved and enhanced to handle ptable
  • csv loader bug with fields longer than 1000 fixed
  • where clause not bug fixed
  • datatune support removed
  • regex cd problem with linux debian installs fixed

2016 January 12 - version 3.1

  • showbox bug fixed for jconsole (non linedraw) box chars
  • showbox replaced by sptable (from simple project)
  • insert/update datatune bugs fixed
  • modify now does datatune
  • tutorial datatune updated
  • datatune doc
  • key enforced by shared library
  • Jd binary and code version match enforced
  • csv now supprts epoch cols (Ops csv)
  • csvrd default reads all rows (rather than just 10)
  • tutorial csv updated
  • install over previous install (orphans) now OK (scriptlists.ijs)
  • JAL version no longer tied to jd'list version'

2015 December 12 - version 2.2.11

  • dropcol does not update column_create_order.txt - bug fix
  • csvappend fails in some cases - bug fix
  • min-max/epochdt with no records works (not domain error)
  • logging and db validation improved (Technical|Damaged)
  • tutorial log
  • validate - detects db problems (Ops misc|validate)
  • info validate - info on all db mappings (Ops info)
  • info validatebad - validate mappings with problems (Ops misc|validate)
  • jdadmin does validate
  • validate done before/after insert/update/modify/delete
  • insert revert bug - detailed log and marks db damaged

2015 October 1 - version 2.2.10

2015 June 18 - version 2.2.9

  • where cola,colb = 1,2 doc and implementation bug fixed
  • jddropstop prevents drops (General|Drop/Delete)
  • jddeletefolder fails if criteria not met (General|Drop/Delete)
  • jddeletefolder more robust vs background tasks (Technical|Windows search service)
  • jddeletefolderok allows otherwise blocked jddeletefolder
  • welcome replaced by short message after jdtests run
  • modify with indexes as well as where clause - jdex_jd_'modify'
  • bugs fixed in where col in ()
  • rough version of pm (performance measurement) - pmhelp_jd_
  • droptable /reset (Ops manage|droptable)
  • info jd - info on jd... cols (Ops info)
  • better createhash/createunique performance
  • fix bug in createhash/createunique for multiple cols
  • libjd.so built with stable linux (RH 4/Centos 5) (Technical|libjd.so)

2015 May 11 - version 2.2.7

  • where cola range (23,64) - tutorial reads
  • where cola,colb = 1,2 - tutorial where
  • jdadminx'a' (single letter) bug fixed
  • new doc page (General)
  • consistent rules for dan/table/col names (General|Names)
  • modify bugs fixed
  • createtable /a option must be before table name (Ops manage|createtable)
  • create table from array - tutorial table_from_array
  • better error messages

2015 April 14 - version 2.2.6

  • CDEFSFILE (tutorial csv)
  • gethashlen bug fixed
  • where in () bug fixed
  • jdtests reports elapsed time
  • performance measurement - pmhelp_jd_
  • read.ijs sortfrom bug fixed
  • createcol shape validated
  • droptable allowed with hash (fails with reference)
  • some aggregates sped up
  • better error message for insert/update/modify
  • jdlast last line shuffled
  • renametable implemented
  • renamecol implemented
  • modify implemented - update in place
  • libjd_centos.so (Technical|libjd.so)

2015 March 10 - version 2.2.1

  • dropdynamic for specified columns
  • info unique

2015 March 9 - version 2.2

  • ref join - simpler than reference but with restrictions (tutorial join,Technical|Ref)
  • improved handle management and related errors (Technical|File handles)
  • epochdt new features - tutorial epochdt
  • epochdt allows blank (as well at T) as delimiter of time fields
  • epochdt bug with UTC offsets fixed
  • join with empty table bug fixed
  • join with createunique crash now signals error
  • csvrd bug with float .x vs 0.x fixed

2014 Jan 5 - version 2.1

  • key required to run Jd
  • epoch datetime col types (tutorial epochdt, General|Types)
  • smarter file allocation and resize (Ops manage|createtable)
  • all column files mapped when db is opened
  • list lists version and open databases (Ops info|list)
  • info works only on current database

2014 April 22 - version 2.0

  • Jd released as addon