Debian Codegraph @

Changes

raw
1 Changes log for Perl extension SQL::Statement
2
3 1.414 2020-10-21
4 * re-release 1.413_001 without further changes
5
6 1.413_001 2020-09-28
7 * Spell check
8 * Be specific in which files to skip from the distribution
9 * Author fixes
10 * Makefile.PL: port WriteMakefile1 from Hash::Merge
11 * .travis.yml: update for Xenial VMs
12 * cleanup MANIFEST.SKIP
13 * bump copyright year
14 * SQL::Parser correctly parse VALUES and SET clauses containing function invocations with several arguments
15 patch provided by Edgar J. Holleis
16
17 1.412 2017-04-06
18 * Release 1.411_001 without further changes as 1.412
19
20 1.411_001 2017-03-30
21 [Bug fixes]
22 * Fix http://www.perlmonks.org/?node_id=1167381 (NumericEval: fix
23 typo on error handling) (thanks to Yanick Champoux, James R. Leu)
24 * fix repo url and t/02execute.t (Reini Urban, Mohammad S Anwar)
25 * fix test failing with blead-perl (Jens Rehsack)
26
27 [Improvements]
28 * Refactor constraints processing (Ovidiu Gheorghies)
29 * Support parsing of complex JOIN clause (containing OR and ()'s) (James R. Leu)
30 * handle backtick quoting (Ben Hengst)
31
32 1.410 2016-04-11
33 [Bug fixes]
34 * Fix RT#113625 - Unnecessary x-bits (Kent Fredric, Mohammad S Anwar)
35
36 [Documentation]
37 * pod2markdown README.md from lib/SQL/Statement.pm
38
39
40 1.409 2016-04-06
41 * Release 1.408_001 without further changes as 1.409
42
43 1.408_001 2016-03-07
44 [Bug fixes]
45 * Fix RT#112530 - t/06virtual.t fails with -Duselongdouble (thanks
46 Slaven Rezic)
47 * Fix RT#105852 - dependency installation isn't triggered properly in
48 cpan (thanks Mithaldu)
49 * Fix RT#99349 - bind variables are not bound to placeholders in the
50 correct order (thanks [email protected])
51
52 [Documentation]
53 * Update Copyright statements, add where missing (according to records)
54 * Add license conditions where missing
55 * bundle copy of license conditions to distribution
56
57 1.407 2015-05-26
58 * Release 1.406_002 without further changes as 1.407
59
60 1.406_002 2015-05-22
61 [Bug fixes]
62 * Fix RT#104579: Redundant argument in sprintf
63 submitted by Slaven Rezić
64 * Fix RT#104589: t/14parse.t fails if Test::Deep is not installed
65 submitted by Slaven Rezić
66
67 1.406_001 2015-05-20
68 [Misc]
69 * clean up Makefile.PL, meta-data and requirements
70
71 [Bug fixes]
72 * Fix SQL function CONV to use limited number of sane character sets
73 for conversion and rely on Math::Base::Convert instead of own code
74 (suggested by Tom Wyant in RT#100551, thanks Tom)
75 * fix handling of literal identifiers and for every IMPORT rely on
76 literal identifiers to avoid parser errors for column names starting
77 with numbers or similar
78 * fix capability cache: "$class->can(...)" might return undef and
79 therefore inexistent capabilities are queried to often
80 * Fix COUNT(DISTINCT col) without GROUP BY clause (patch submitted
81 by Grant Mathews, thanks Grant)
82 * Fix "parse insert with functions" submitted via GitHub PR#6 by
83 fecundf and RT#96628
84 * Fix RT#93320: SQL-style comment can not begin inside quotes by
85 Tom Wyant - thanks Tom
86
87 [Improvements]
88 * reduce blocks and rewrite some inner statements to increase speed
89 of sql command processing
90
91 1.405 2013-06-17
92 [Bug fixes]
93 * INSERT now expands incomplete rows (Thanks to H.Merijn Brand)
94
95 1.404 2013-05-23
96 [Bug fixes]
97 * re-enable cleanup test_output* after test done
98 * recommend Text::Soundex and do soundex-test only when have it,
99 because it's going to be removed from core for Perl 5.19 (thank Merijn)
100
101 1.403 2013-05-22
102 [Bug fixes]
103 * fix documentation (rt#84889 - thanks Xavier Guimard and Florian,
104 rt#85257 - thanks Andreas Koenig)
105
106 1.402 2012-12-19
107 [Misc]
108 * add Math::Complex 1.56 as recommendation (RT#81926, Sam Ferencik)
109 * add Math::BigInt 1.88 as recommendation (RT#81927, Sam Ferencik)
110 * clarify Test::Simple 1.90 is required for building
111 (RT#81925, Sam Ferencik)
112
113 [Bug fixes]
114 * fix leaking reference to open tables outside SQL::Statement::execute
115 (fixes RT#81523)
116 * looks_like_number identifies 'nan' as number sometimes (add regex to
117 t/06virtual.t)
118
119 1.401 2012-10-29
120 [Misc]
121 * Switch to 3-digited minor version
122
123 [Bug fixes]
124 * undo literal replaces in subqueries before passing them to the
125 child parser
126 * Fix doc typo RT#76764 (STEFFENW) - thanks Steffen
127 * Fix typo documented in RT#71914 (reported by Ze'ev Atlas,
128 fixed by H.Merijn Brand) - thanks Ze'ev and Merijn
129 * Fix DROP TABLE behaviour and error detection
130
131 [Improvements]
132 * Improve documentation/tests for multiple JOIN's from RT#69573
133 (from BBYRD) with modifications
134 * Filling in the SQL92 gaps for functions (BBYRD) from RT#72638
135 with minor modifications - thanks Brendan
136
137 1.33 2011-02-05
138 [Bug fixes]
139 * Move test dependencies to (unreleased) Bundle::Test::SQL::Statement
140 to avoid circular dependencies
141
142 1.32 2011-01-19
143 [Bug fixes]
144 * Fixed invalid check for escaped single quotes
145 * Fixed unpermitted modification of array source for table creation
146 (CREATE TABLE AS IMPORT(?),[[..],[..]])
147 * Fixing alias used in ORDER BY (RT#61384, thanks jvm)
148 * Fixing ORDER BY behavior for multiple sort columns
149 (slower, but guaranteed correct)
150
151 [Improvements]
152 * renamed fetch-method into fetch_row (keep fetch() as alias) and
153 add a fetch_rows() to fetch all rows at once
154 * Different accessors for direction of ORDER BY clause query part
155 and it's boolean equivalent "desc" (0 or 1, respectively)
156 * Add a lot of Pure-Perl DBD's as build dependency for testing
157 (skip DBD::AnyData for now, because it seems to be broken - check
158 for next release)
159
160 [Misc]
161 * Bump requirement of DBI to 1.616
162 * switch for fully external DBD tests from DBD::XBase to DBD::SQLite
163 * Document another limitation (lacking implicit creating temp table
164 during processing a query using the same table with different aliases
165 twice)
166
167 1.31 2010-08-16
168 [Bug fixes]
169 * Fix misbehaviour of DELETE/UPDATE for tables with only basic capabilities
170 and no matching where clause (reported by H.Merijn Brand and Drew ...)
171 * Fix some column identifier splits to respect quoted tables
172
173 [Improvements]
174 * Optimized some core routines between 25% and 50%.
175
176 1.30 2010-08-01
177 [Bug fixes]
178 * remove blib directory from distfile
179
180 1.29 2010-08-01 released August 1st, 2010
181 [Bug fixes]
182 * add some getters as documented in SQL::Statement::Structure
183 (fixes RT#59834, thanks John Wiersba)
184 * add missing import of function croak to SQL::Statement::Term::ColumnValue
185 * fix assignment of parser result (doesn't run with perl-5.13.3)
186
187 1.28 2010-07-15
188 [Improvements]
189 * Introduce new "capability" method for SQL::Statement and SQL::Eval::Table
190 + Add capability for "insert_new_row" to allow DBD::DBM to fix PK
191 constrain on INSERT statements.
192 * Performance of IMPORT feature improved (thanks to Sven Probst, RT#57322)
193
194 [Bug fixes]
195 * expect every table object being derived from SQL::Eval::Table
196 * rewrite DELETE and UPDATE command based on table capabilities
197 * add abstract methods for all methods derived classes must override
198 (this means, open_table for SQL::Statement deriveds must be overridden
199 and all data access methods of tables - see SQL::Eval::Table for details)
200 * Tests are fixed to use TEMP TABLES explicitely when required
201 * check for invalid column names fixed
202 * Don't let depreciated parser structures stay alive in SQL::Statement when
203 reusing the Parser
204
205 [Documentation]
206 * Method documentation of SQL::Statement and SQL::Eval::Table are improved
207 * Add a Roadmap describing future plans for SQL::Statement (in addition to
208 DBD::File::Roadmap).
209 * POD spelling fixes provided by H.Merijn Brand
210 and Pod::Spell::CommonMistakes (thanks Tux)
211 * POD grammar fixes and reasonable sentences created by Martin Evans
212
213 [Things that may break your code]
214 * SQL::Statement 1.28 is expected not to work proper in combination with
215 DBI 1.611 and below
216 * SQL::Statement::ColumnValue expects now every table being derived from
217 SQL::Eval::Table
218
219 1.27 2010-05-06
220 [Bug fixes]
221 * use originally given table name for open_table() on SELECT, too
222 (all other command still use the originally given name)
223 * warn/die -> carp/croak
224 * fix delete_one_row & update_one_row ability using
225
226 [Documentation]
227 * Apply spelling fix patch from Ansgar Burchardt (RT#56475)
228
229 1.26 2010-04-09
230 [Bug fixes]
231 * Handle NULL columns in concatenation as empty strings
232
233 [Improvements]
234 * Change regex's in parser to use \p{Word} instead of \w to allow unicode
235 support
236
237 [Documentation]
238 * Make clear, that identifiers are handled case insensetive and there is
239 a real good solution provided by DBI which allows to live great with
240 that behaviour.
241
242 1.25 2010-03-15
243 [Bug fixes]
244 * Keep org_table_names with schema information to allow derived
245 table classes to handle as it seems reasonable there
246 * Separate columns with "\0" in multi-column aggregation to be able to
247 difference between ('1','1foo') and ('11','foo')
248
249 [Misc]
250 * More resources added to META.yml
251
252 1.24 2010-03-15
253 [Misc]
254 * Ignore *.rej in MANIFEST.SKIP (fixes RT #52081 reported by
255 Lars Thegler)
256
257 [Bug fixes]
258 * Add missing import of _INSTANCE in SQL::Statement::Function::NumericEval
259 fixes RT #52356 - reported by Detlef Pilzecker)
260 * Fix wrongly discarded DISTINCT clause (RT#53186)
261
262 [Improvements]
263 * Fix parsing errors of plain numbers (RT#16931)
264 * Fix parsing errors of nested calculation / functions (RT#16931, RT#52356)
265 * Rewrite result calculation of aggregation functions
266 (simplify code, speed up)
267 * Upgrade Makefile.PL (patch from Alexandr Ciornii) to handle different
268 EU::MM versions and abilities properly
269 * Update documentation to show how 'column_defs' and SQL::Statement::Term
270 instances shall be used
271 * Introduce SQL::Dialect::Role providing ini-style data access
272 to SQL::Dialects (patch from Michael Schwern)
273
274 [Things that may break your code]
275 * SQL::Parser now didn't deliver a struct containing 'column_names',
276 'computed_columns' and 'set_functions' - it's combined into one member
277 'column_defs'.
278 * Minimum required perl version is now 5.8 - upcoming next version of DBI
279 requires perl 5.8, too - and I could simplify some code that's why
280
281 1.23 2009-11-20
282 [Misc]
283 * Applied patch from Marc Espie which fixes several orthographic
284 errors in SQL::Statement::Syntax documentation.
285 * Added a fixed version of test reported via RT #34121
286
287 [Bug fixes]
288 * Fix an issue in UPDATE command which 'shift's the values from
289 the list of parameters which causes there're no more parameters
290 left after first row get's updated (Fixes RT #50788)
291 * Fix aggregate function handling of new code since 1.21_01
292 * Correct handling of DISTINCT in aggregate functions
293
294 [Improvements]
295 * Add support for tables/columns starting with '_' for CSV and AnyData,
296 which is usually forbidden by ANSI SQL
297 * Add support for inserting multiple lines with one statement
298 (fixes RT #31730)
299 * Handle ANSI 'IS NULL' and CVS/AnyData 'IS NULL' different
300
301 [Things that may break your code]
302 * row_value now expects up to two arguments
303
304 1.22 2009-10-10
305 [Misc]
306 * Add missing changelog - no code changes
307
308 1.21 2009-10-10
309 [Misc]
310 * remove version dependency to check previously installed version
311 * add DBD::File as "Test" requirement
312
313 1.21_8 2009-10-05
314 [Bug fixes]
315 * Add additional test for bug-fix in 1.21_7 to t/18bigjoin.t
316
317 [Misc]
318 * Correct some typo's in POD
319
320 1.21_7 2009-09-31
321 [Bug fixes]
322 * Don't fail for non-existent columns introduced by functions
323 in joins
324
325 1.21_6 2009-09-24
326 [Bug fixes]
327 * Don't abort Makefile.PL when in automated smoke tests
328
329 1.21_5 2009-09-23
330 [Bug fixes]
331 * table order isn't wrongly used in order of appearance when SQL::Parser
332 couldn't determine an order
333 * Some internal fixes
334
335 [Misc]
336 * Updated dependency to Params::Util to non-leaking 1.00
337 * Note dependency to Carp and Data::Dumper
338 * rely on version to compare versions
339 * Update POD for terms
340 * Update
341
342 1.21_4 2009-09-21
343 [Bug fixes]
344 * modify regex to match types to fix problems with Perl 5.6.2
345 * add DESTROY methods to ensure clean up
346 * fix lower casing internal table names when joining tables
347 * replace parameter shifting by assigning @_ to the list of parameters
348
349 1.21_3 2009-09-17
350 [Things that may break your code]
351 * When someone accesses the where_clause attribute of the SQL::Statement
352 instance - be aware that now IN and BETWEEN can be native entries
353
354 [Bug fixes]
355 * convert operation to upper case when surely initialized
356
357 [Improvements]
358 * IN and BETWEEN are now native operations - they are not expanded
359 to OR'ed equalize operations anymore
360
361 1.21_2 2009-09-15
362 [Things that may break your code]
363 * modify behavior for unquoted identifiers - they're converted and
364 returned lower cased now (instead upper cased as in 1.21_1)
365 Fixes bug RT #48502
366
367 1.21_1 2009-07-30
368 [Things that may break your code]
369 * removed SQL::Statement::Column
370 * don't instantiate SQL::Statement::Functions objects
371 * Reworked internal column and function handling to reduce code complexity
372 * rows and columns aren't setable from outside a table or eval object
373 anymore
374
375 [Bug fixes and other changes]
376 * Fixed bugs:
377 + RT #47292: Test failures with recent DBI
378 + RT #44512: Patch for CREATE TABLE parsing
379 + RT #42676: tests 16 failed
380
381 1.20 2009-03-05
382 * Fixed Makefile in MANIFEST (reported by Havard Eidnes in RT #43586)
383 * Fixed invalid label FETCHROW used (reported by Michael in RT #42982)
384 * separated update_one_row and update_specific_row method names for tables
385 to avoid confusion
386
387 1.19 2009-02-06
388 * Fixed OUTER JOIN behavior
389 * Added version info to all *.pm files to allow CPAN::Reporter find updates
390 * Correct META-Files
391 * Fixed reported bugs:
392
393 1.18_02 2009-01-20
394 * Additional (profiled) optimizations for complicated where clauses
395
396 1.18_01 2009-01-12
397 * No code changes within SQL::Statement -
398 but deliver and execute additional tests.
399
400 1.17 2009-01-12
401 * Fixed bug: RT#42263: GROUP BY doesn't group on multiple columns
402
403 1.16_04 2009-01-04
404 * added tests to prove valid quoting (most of them fail)
405 * Reformat the source
406 * add some (profiled) tweaks as removing useless regex to speed up SELECT
407
408 [Bug fixes]
409 * 14217 Does not correctly handle SQL statements with comments
410 * 15686 Join syntax is case-sensitive, and common columns in natural
411 joins are "ambiguous" [patch]
412 * 13080 Cannot update a field based on its previous value
413 * 26058 functions on computed columns aliased to the underlying column
414 name are not called
415
416 1.16_03 2009-01-01
417 * removed *.orig and *.rej relics
418
419 1.16_02 2009-01-01
420 * Changing join_2_tables to reduce memory usage when joining a lot of tables
421
422 [Bug fixes]
423 * 15688 Columns aliased with double quotes are a fatal error
424 * 16579 Speed optimizations
425 * 30590 Bug in SQL::Statement::is_number()
426 * 41875 Bug in synopsis example
427
428 1.16_01 2009-01-01
429 * With this release, I'd like to welcome Jens Rehsack as co-maintainer of
430 the SQL::Statement and SQL::Parser modules. Jens has added in some
431 great improvements.
432 Thanks Jens! -- Jeff
433 * Adding a lot of join tests (once from Jeff, 48 from
434 PostgreSQL official handbook) - no error of them will be corrected in the
435 first run
436 Thanks to Alexander Breibach <[email protected]> -- Jens
437
438 1.15 2006-02-02
439 * fixed placeholder bug in SQL::Statement::UPDATE
440 thanks for bug report Tanktalus
441
442 1.14 2005-04-21
443 * fixed circular dependency in tests (one mistakenly required AnyData)
444
445 1.13 2005-04-18
446 * pod fixes
447
448 1.12 2005-04-18
449 * added support for GROUP BY
450 (several people sent suggestions for this in the past, please email me
451 so I can credit you, sorry I lost the names)
452 * added support for true LIMIT - if a LIMIT clause is specified and
453 no ORDER BY clause is specified, the SELECT will stop searching
454 when the limit is reached; with an ORDER BY clause it will still
455 search the entire table because we can only ORDER a set; using
456 LIMIT without an ORDER BY will greatly increase speed
457 * added support for CREATE/DROP keyword|operator|type|function
458 * optimized process_predicate to only look up scalars once
459 * completely re-wrote the POD
460 * fixed bug in primary key search optimization
461 thanks for bug report and test scripts: Jim Lambert, <jimlambrtATmac.com>
462 * fixed problem with all_cols slowing inserts
463 thanks for patch and test Cosimo Streppone <cosimoATcpan.org>
464 * cleaned up case of temp table column names
465 thanks for bug report: Dan Wright
466 * added a META.YML and extra tests
467
468 1.11 2005-03-28
469 * fixed bug in "CREATE TABLE AS ..."
470
471 1.10 2005-03-27
472 * added support for CREATE TABLE AS SELECT ... and CREATE TABLE AS IMPORT()
473 * added support for in-memory tables and heterogeneous operations,
474 see the SQL::Parser docs
475 * added many new built-in functions see SQL::Statement::Functions.pm
476 * added support for user-defined functions, see SQL::Statement::Functions.pm
477 * added support for column name aliases
478 thanks for patch, Robert Rothenberg
479 * added support for comparison to empty string (e.g. WHERE col1='')
480 currently returns the same as WHERE col1 IS NULL
481 thanks for patch, cpanATgoess.org
482 * fixed bug in S::P::clean_sql() newline-handling,
483 thanks for patch Steffen G., steffenATkonzeptloses.de
484 * fixed bug in SQL::Parser::feature()
485 thanks for patch, chromatic
486 * the word "INTO" is now optional in "INSERT INTO tblname ..."
487 * the word "FROM" is now optional in "DELETE FROM tblname ..."
488 thanks for suggestion, [email protected]
489 * optimized portions of eval_where, process_predicate, and is_matched
490 HUGE thanks Dan Wright and Dean Arnold for patches
491 * HUGE thanks to Dean Arnold for all the following which should clean up
492 a number of bugs in parentheses parsing and in the predicates IN and
493 BETWEEN as well as speed things up considerably
494
495 [SQL::Parser changes]
496 * removed recursion from get_in(), get_btwn()
497 * fixed paren scan and argument separator scan in get_in()
498 * optimized get_in/get_btwn code
499 * made get_in/get_btwn OO methods to support
500 being overridden by subclasses
501 * added transform_syntax() abstract method to permit subclasses
502 to add their own syntax extensions
503 * rewrite of parens_search() to fixed predicate paren processing,
504 remove recursion, and optimize code
505 * rewrite of non_parens_search() to fixed predicate
506 paren processing and optimize code
507 * rewrite of PREDICATE to optimize code;
508 moved operator regex construction to dialect initialization
509 * change undo_string_funcs(), undo_math_funcs(), nongroup_numeric(),
510 nongroup_string() to remove scoped recursion
511 * fixed nongroup_numeric() for case insensitive operator match
512 * fixed nongroup_string, undo_string_funcs() to include user defined funcs
513 * fixed ROW_VALUE's scan for user defined function
514 argument separator scan
515 * fixed function detection regex in SQL::Parser::ROW_VALUE
516 to accomodate arbitrary spacing
517 * fixed SQL::Parser::SELECT_LIST()/extract_column_list()
518 to support concat operator '||' expressions
519 * added following functions to SQL::Statement::Functions:
520 COALESCE; NVL (same as COALESCE); DECODE (same as Oracle DECODE);
521 CONCAT; REPLACE/SUBSTITUTE
522 * fixed/adapted SQL::Statement::get_row_value(),
523 SQL::Statement::SELECT(), for join'ed resultsets
524
525
526 1.09 2004-04-22
527 * fixed parens parsing bug reported by Dan Wright, thanks!
528
529
530 1.08 2004-04-20
531 * fixed bug in JOIN handling introduced in 1.06
532
533
534 1.07 2004-04-20
535 * fixed infinite recursion bug with empty IN() predicate
536 thanks chromatic, for the patch
537 * fixed case issues with table aliases in joins
538 thanks chromatic, for bug report
539
540
541 1.06 2004-04-18
542 * column and table name hashes now default to case sensitive
543 * where() method now supported as per the docs
544
545
546 1.005 2002-10-26
547 * added support for MySQL-like "DROP TABLE IF EXISTS"
548 * fixed bug in dotted column names e.g. tableA.colB
549 * fixed bug in MAX and MIN (thanks Michael Kovacs,
550 [email protected])
551 * fixed bug in ORDER BY (when col names not in SELECT list)
552 Thanks Janet Goldstein <[email protected]>
553
554
555 1.004 2002-03-13
556 * added support for delimited identifiers (inside double quotes);
557 these are case sensitive and can contain spaces and other
558 special chars
559 * added support for two forms of escaping single quotes inside
560 quoted values: 'O\'Brien' or 'O''Brien'
561 * added support for both C-Style and SQL-Style double-hypen
562 comments, e.g. /* comment */ or -- comment
563 * added GetInfo.pm for use with $dbh->get_info()
564 * updated the readme file
565 * fixed bug in update that refers to its own columns
566 (e.g. SET num = num + 2)
567 * fixed bug in MIN and MAX when used with strings
568 Thanks Dean Kopesky <[email protected]>
569
570 1.003 2002-03-01
571 * identifiers (names of columns, tables, and table name
572 aliases) are now all case insensitive as required by the SQL
573 standard. all older versions including the XS versions used
574 case sensitive column names
575 * added numerous examples to test.pl
576 * improved and/or fixed bugs in:
577 * placeholder support
578 Thanks Achim Grolms <[email protected]>
579 * ORDER BY clause
580 Thanks Jan Stocker <[email protected]>
581 * LIKE/CLIKE/RLIKE/IN predicates
582 Thanks Udo Beckmann <[email protected]>
583 * table name aliases in explicit joins
584
585 1.002 2002-02-05
586 * added backwards compatiblity: both SQL::Statement and
587 SQL::Parser now work in perl version 5.004 and above.
588 * changed defaults for DBD::CSV so it now accepts new SQL
589 without adding extra flags to scripts
590 * added support for SQL comments
591 * added support for temporary tables and on commit clauses in
592 CREATE statements and drop behaviour flags in DROP statements
593 (SQL::Parser only, not supported by SQL::Statement)
594 * fixed bugs in qualified column names (e.g. tableA.*), and in
595 joins using ON or WHERE
596
597 1.001 2002-01-17
598 * Fixed bug in UPDATE that caused the new value to be a hash
599 rather than a scalar.
600
601 1.0 2002-01-15
602 This is the first CPAN release of the pure perl version of the
603 module. It was previously released in an XS version by Jochen
604 Wiedman who has turned over maintenance of it to me.
605
606 The new Pure Perl version of SQL::Statement supports everything
607 supported by the XS version and, additionally, at least partial
608 support for the following features that are not supported at all
609 by the XS version:
610
611 * Explicit and implicit joins
612 * Table name aliases
613 * Set functions
614 * String functions
615 * String concatenation
616 * Numeric expressions
617 * IN predicate
618 * BETWEEN predicate
619 * Alphabetic comparison in WHERE clauses
620 * Ordering of text that looks like a number
621 * Verbose error messages for both Parsing and Execution errors
622