rework public expression api with better locale handling; support parsing of number strings with grouping separators

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

add support for monthname function; implement better string to date/time conversions

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

add support for weekdayname function

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

implement IsNumeric; add support for hex/oct integer strings

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

implement IsNumeric; add support for hex/oct integer strings

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

spelling

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1198 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@1197 f203690c-595d-4dc9-a70b-905162fa7fd2

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

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

prep for release

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

more doc updates

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

refactor support for working with Value instances

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

add a bunch of javadocs for expr classes

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

minor refactor of function support; start adding top level docs for evaluation support

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

fix compiler warning

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

update parent pom; update urls for https

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

test TimeSerial; implement DateSerial

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

test custom EvalConfig; fix time format

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

add some date function tests

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

minor update

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

test number functions

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

test more functions

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

add ability to get original expression; implement some parsing tests

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

fix handling of certain field validator expressions; add some tests for various expressions

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

handle alternate true/false constant values

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

add more tests; add not like

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

more tests

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

use common method pattern between ParseContext and EvalConfig

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

ditch default parse context

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

minor code warning cleanups

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

bump version for moderate feature update

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

merge branch exprs changes through r1171

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

merge trunk changes through r1170

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1171 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@1170 f203690c-595d-4dc9-a70b-905162fa7fd2

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

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

prep for release

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

add some tests for functions; fix said functions

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

return all values in map so that default values, calc values, etc get returned to caller

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

more number format unit tests

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

add number format unit tests; update tests based on new formatting

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

add unit tests for property expression evaluation features

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

allow col validator to get this column by name

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

implement floating point number formatting which matches access

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

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