implement floating point number formatting which matches access

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1159 f203690c-595d-4dc9-a70b-905162fa7fd2

cleanup some fixmes

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1158 f203690c-595d-4dc9-a70b-905162fa7fd2

handle literal string default values

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1157 f203690c-595d-4dc9-a70b-905162fa7fd2

use decimal math context which matches access precision; tweak string to number conversion to match access

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1156 f203690c-595d-4dc9-a70b-905162fa7fd2

normalize decimals when used; convert number literals to decimal instead of double; handle int overflow for number literals

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1155 f203690c-595d-4dc9-a70b-905162fa7fd2

do not allow null result for conditions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1154 f203690c-595d-4dc9-a70b-905162fa7fd2

merge trunk changes through r1152

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1153 f203690c-595d-4dc9-a70b-905162fa7fd2

Create new usage map correctly when adding an index to an existing table.  fixes #147

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1152 f203690c-595d-4dc9-a70b-905162fa7fd2

knock out some fixmes; add support for custom function lookup and custom bindings passed into expression evaluation

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1151 f203690c-595d-4dc9-a70b-905162fa7fd2

Add some additional property keys and relevant enums for values

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1150 f203690c-595d-4dc9-a70b-905162fa7fd2

merge trunk changes through r1148

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1149 f203690c-595d-4dc9-a70b-905162fa7fd2

plug expr evaluation into columns/tables; create Identifier for tracking expression ids; support single quoting in expressions; tweak string to number coercion; implement topo sorter for calc col eval

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1148 f203690c-595d-4dc9-a70b-905162fa7fd2

start enforcing the required and no-zero len column properties

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1147 f203690c-595d-4dc9-a70b-905162fa7fd2

use specific exceptions for expr eval

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1146 f203690c-595d-4dc9-a70b-905162fa7fd2

fix null handling for string funcs

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1145 f203690c-595d-4dc9-a70b-905162fa7fd2

move rnd logic to RandomContext

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1144 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1143 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.1.11

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1141 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1140 f203690c-595d-4dc9-a70b-905162fa7fd2

merge trunk changes through r1138

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1139 f203690c-595d-4dc9-a70b-905162fa7fd2

update ddl flag for default properties even if type is explicitly provided.  fixes #146

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1138 f203690c-595d-4dc9-a70b-905162fa7fd2

Expose the ddl attribute on properties. Set the attribute appropriately for known builtin properties.  fixes issue #145

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1137 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1136 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.1.10

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1134 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1133 f203690c-595d-4dc9-a70b-905162fa7fd2

implement sql type to DataType conversions specific to access 2016 format

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1132 f203690c-595d-4dc9-a70b-905162fa7fd2

some more financial funcs, not all fully working

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1131 f203690c-595d-4dc9-a70b-905162fa7fd2

Add full support for access 2016 databases including the new 'Large Number' (aka Bigint) data type. Fixes feature #37

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1130 f203690c-595d-4dc9-a70b-905162fa7fd2

implement some financial functions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1129 f203690c-595d-4dc9-a70b-905162fa7fd2

more math unit tests

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1128 f203690c-595d-4dc9-a70b-905162fa7fd2

handle plus as a unary number modifier; handle precedence of plus/minus in more confusing math expressions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1127 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1126 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.1.9

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1124 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1123 f203690c-595d-4dc9-a70b-905162fa7fd2

Fix writing of property maps without any properties.  fixes #144

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1122 f203690c-595d-4dc9-a70b-905162fa7fd2

add support link to main page

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1121 f203690c-595d-4dc9-a70b-905162fa7fd2

long type should be int values; implement more date/time and misc other functions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1120 f203690c-595d-4dc9-a70b-905162fa7fd2

implement some date/time functions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1119 f203690c-595d-4dc9-a70b-905162fa7fd2

a few more number functions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1118 f203690c-595d-4dc9-a70b-905162fa7fd2

split out function groups; implement numeric functions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1117 f203690c-595d-4dc9-a70b-905162fa7fd2

bug fixes and unit tests

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1116 f203690c-595d-4dc9-a70b-905162fa7fd2

fix some cast functions; more unit tests

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1115 f203690c-595d-4dc9-a70b-905162fa7fd2

add some initial default function unit tests; fix some parse bugs

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1114 f203690c-595d-4dc9-a70b-905162fa7fd2

implement a bunch of functions which really need unit tests; add support for calculated field expressions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1113 f203690c-595d-4dc9-a70b-905162fa7fd2

implement various functions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1112 f203690c-595d-4dc9-a70b-905162fa7fd2

merge trunk changes through r1110

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1111 f203690c-595d-4dc9-a70b-905162fa7fd2

Handle more advanced query join constructs. fixes issue #141

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1110 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1109 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.1.8

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1107 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1106 f203690c-595d-4dc9-a70b-905162fa7fd2

handle missing table name for join expression

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1105 f203690c-595d-4dc9-a70b-905162fa7fd2

validate length of pre-defined relationship name

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1104 f203690c-595d-4dc9-a70b-905162fa7fd2

Add option to specify relationship name, fixes pull request #4

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1103 f203690c-595d-4dc9-a70b-905162fa7fd2

Fix parsing of certain internal-use queries.  Fixes issue #142

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1102 f203690c-595d-4dc9-a70b-905162fa7fd2

merge trunk changes through r1100

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1101 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1100 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.1.7

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1098 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1097 f203690c-595d-4dc9-a70b-905162fa7fd2

provide accessors for defaults config

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1096 f203690c-595d-4dc9-a70b-905162fa7fd2

Add CustomLinkResolver which facilitates loading linked tables from files which are not access databases.  fixes feature request #36

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1095 f203690c-595d-4dc9-a70b-905162fa7fd2

Allow inserting negative auto number fields, fixes pull request #3

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1094 f203690c-595d-4dc9-a70b-905162fa7fd2

Cover the GENERIC_JET4 format in unit tests, thanks to Gord Thompson

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1093 f203690c-595d-4dc9-a70b-905162fa7fd2

merge trunk changes through r1091

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1092 f203690c-595d-4dc9-a70b-905162fa7fd2

use actual implicit comp op subclass

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1091 f203690c-595d-4dc9-a70b-905162fa7fd2

better handling of non-conditional exprs as field validators

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1090 f203690c-595d-4dc9-a70b-905162fa7fd2

update parent pom

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1089 f203690c-595d-4dc9-a70b-905162fa7fd2

merge trunk changes through r1087

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1088 f203690c-595d-4dc9-a70b-905162fa7fd2

Implement support for partial index lookups.  Efficient IndexCursor lookups can now be done with multi-column indexes using only some of the columns in the index.

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1087 f203690c-595d-4dc9-a70b-905162fa7fd2

merge trunk changes through r1085

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1086 f203690c-595d-4dc9-a70b-905162fa7fd2

change regex to compile on first use; turn invalid pattern into unmatchable regex; add some like pattern tests

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1085 f203690c-595d-4dc9-a70b-905162fa7fd2

add more type coercion, string and date to num

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1084 f203690c-595d-4dc9-a70b-905162fa7fd2

support string to number coercion for mixed math operations

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1083 f203690c-595d-4dc9-a70b-905162fa7fd2

more plugin cleanup

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1082 f203690c-595d-4dc9-a70b-905162fa7fd2

add date time Value accessor

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1081 f203690c-595d-4dc9-a70b-905162fa7fd2

better terminology for expressions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1080 f203690c-595d-4dc9-a70b-905162fa7fd2

add TemporalConfig to allow for custom expression date/time formats

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1079 f203690c-595d-4dc9-a70b-905162fa7fd2

merge trunk changes through r1077

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1078 f203690c-595d-4dc9-a70b-905162fa7fd2

ditch BIG_INT value type

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1077 f203690c-595d-4dc9-a70b-905162fa7fd2

change evaluation context

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1076 f203690c-595d-4dc9-a70b-905162fa7fd2

use isNull

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1075 f203690c-595d-4dc9-a70b-905162fa7fd2

Value cleanup, start on functions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1074 f203690c-595d-4dc9-a70b-905162fa7fd2

add testing for most basic math and fix some edge case logic

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1073 f203690c-595d-4dc9-a70b-905162fa7fd2

start testing simple math exprs

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1072 f203690c-595d-4dc9-a70b-905162fa7fd2

add result caching for pure expressions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1071 f203690c-595d-4dc9-a70b-905162fa7fd2

implement more operations

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1070 f203690c-595d-4dc9-a70b-905162fa7fd2

add method for indicating purity of an expression, possible use for future caching

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1069 f203690c-595d-4dc9-a70b-905162fa7fd2

ditch boolean type

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1068 f203690c-595d-4dc9-a70b-905162fa7fd2

checkpoint reworking expression classes and implementing many basic operations

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1067 f203690c-595d-4dc9-a70b-905162fa7fd2

ditch extra import

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1066 f203690c-595d-4dc9-a70b-905162fa7fd2

update parent pom; various plugin updates

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1065 f203690c-595d-4dc9-a70b-905162fa7fd2

minor compilation cleanups

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1064 f203690c-595d-4dc9-a70b-905162fa7fd2

use column names in error message

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1063 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1062 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.1.6

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1060 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1059 f203690c-595d-4dc9-a70b-905162fa7fd2

reorg of expression classes

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1058 f203690c-595d-4dc9-a70b-905162fa7fd2

better fix for switching read-only file formats to read-only mode, wrap with read-only FileChannel.  fixes feature #34

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1057 f203690c-595d-4dc9-a70b-905162fa7fd2

Add support for global usage maps which are reference type maps. fixes issue #138

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1056 f203690c-595d-4dc9-a70b-905162fa7fd2

automatically switch to read-only mode when opening a file format which does not support writing, fixes feature #34

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1055 f203690c-595d-4dc9-a70b-905162fa7fd2

rework classes, add more interfaces; start implementing builtin functions using Value type

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1054 f203690c-595d-4dc9-a70b-905162fa7fd2