forked from crate/crate
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathCHANGES.txt
2099 lines (1275 loc) · 58.7 KB
/
CHANGES.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
=================
Changes for Crate
=================
Unreleased
==========
- Fix: removed unsupported syntax from ``Update`` synposis
- Support column referencing in ``Update`` statement assignment
expression
- Removed undocumented feature: It is no longer possible to use sys
expressions in any context.
- don’t allow full qualified names in UPDATE assignments, INSERT and
INSERT INTO
- The ``sys.operations`` table has now a ``_nodes`` system column
which exposes information about the node the operation runs on.
2015/01/19 0.46.3
2015/01/19 0.45.7
=================
- SELECT statements that involved tables from the information_schema schema or
from the sys schema could fail if they contained columns in the ORDER BY
clause but didn't contain these columns in the result column list.
- Fix: Return zero row count instead of an exception if update by id
doesn't match any document
- Fixed an issue in the ``sys.shards`` table which caused an
exception when the select limit was lower then the number of
matching shards on a node.
- Fixed type conversion of bulk parameters
- Updated crate-admin to version 0.11.2 which includes following changes:
- removed usage of sys expressions in wrong context
- fixed a template rendering issue in cluster view in Safari
- de-register watches to decrease DOM updates and improve
performance in cluster view
- fixed title of `tables` view if no tables exists or connection is down
2015/01/14 0.46.2
=================
- improved string lookup performance for group queries and global aggregates
- Optimized memory estimates for min()/max() aggregates for the CircuitBreaker
2015/01/14 0.46.2
2015/01/19 0.45.7
=================
- fix: throw correct exception if `_version` is misused in WHERE clause
- improved speed of Alter table settings in partitioned tables
- Restricted allowed characters in column names
2014/12/22 0.46.1
=================
- Fixed broken COPY FROM/TO S3 caused by missing depencenies
- Updated crate-admin to 0.11.1 which includes following changes:
- Fixed title of `tables` view if no tables exists or connection is
down
- Fixed an issue that could cause bulk inserts to get stalled.
2014/12/17 0.46.0
=================
- Add support for user-defined schemas.
- Changed output of column names in error messages to subscript notation,
so the correct notation to address columns in sql is reflected
- implemented table ``information_schema.schemata`` with column ``schema_name``
listing all available schemas
- Array types are now fully supported in dynamic schemas. Note that
Crate performs an internal migration, therefore downgrading to an
older version is not supported
- Updated Elasticsearch to 1.4.1
- Improve performance of regex functions by actually
pre-compiling their used patterns (if given as literal)
- Add sql query breaker which will terminate a query execution if too
much memory will be consumed.
- Use flake ids for interal id generation
- Added Support for Column Policies, which can be used to define if a
table enforces its defined schema or if it's allowed to store
additional columns which are not defined in the schema.
- Throw an error while using unknown root columns on SELECT
2014/12/16 0.45.6
=================
- Fix: Nested Columns of ignored objects where exported
as `null` values when using COPY TO
- Fix: Inserting arrays with a null value at first position
failed
- Fix: Using CLUSTERED BY Column in PARTITIONED BY clause threw
misleading exception
- Fix: Added comments to the logging.yml config file and reduced the
amount of log entries by changing the loglevel of some log messages
- Fix: correctly plan group by queries using HAVING clause
- Fix: Improve Error messages on COPY TO and COPY FROM
- Fix: The clustered-by columns could be updated if they were nested.
- Fix: Fixed an edge case where group by queries on system tables or
grouping on primary key or routing column and using limit or
selecting the same aggregation twice did not execute correctly.
- Fixed possible race condition that could cause the `LIMIT` to not
be applied correctly.
- improved speed of bulk inserts in partitioned tables to avoid request
timeouts
- Fixed NPE which could occur on a shard failure while collecting
distributed (e.g. group by query)
- Fix: correctly validate array values in INSERT and UPDATE
statements
- Fix: NULL element in array in first element of bulk insert threw
NPE
- Fix: array columns that were nested inside multiple objects had
incorrect data type (type of their elements instead of array type)
- Fix: adding column on partitioned table without partitions threw
exception although column was added to schema
2014/11/18 0.45.5
=================
- Updated crate-admin to version 0.10.2 which includes following changes:
- fixed issue that caused clunky scrolling with trackpad
in Safari that mainly occured when having a narrow browser width
- made console placeholder text darker so you can distinguish better
between placeholder text and actually written statement
- fixed 'Execute Query' button in console view
- Fix: correctly handle empty values and values containing commas
for clustered by columns in the where clause. e.g: ``where _id=''``
- Fix: Forbid using ``alter table add column`` on a single partition.
- Fix: do not consider rootfs in ``sys.nodes.fs['data']['dev']``
2014/11/12 0.45.4
=================
- Number of shards for new partitions can now be changed by using the
``ALTER TABLE`` statement.
- Fixed a rare race condition that could cause the ``having`` clause to filter
incorrectly.
- Fix: ``alter table add column`` didn't work correctly on partitioned tables.
- Added cast function for timestamp type.
2014/11/10 0.45.3
=================
- Fix: Selecting nested columns didn't work correctly if the query got
optimized to do a "primary key lookup"
- Fix performance regression on ``SELECT`` queries which use the ``IN``
operator in the ``WHERE`` clause.
- Updated crate-admin to 0.10.0 which includes following changes:
- added hint to console: press shift+enter to submit query
- fix: UI showed partitions from wrong table after switching between tables
this could also lead to 'red' partitions if the newly selected table also had partitions
- added syntax highlighting to sql console
- Updated Elasticsearch to 1.3.5
- Fix: Ensure that adding new columns inside nested objects using
``ALTER TABLE`` works as expected.
- ``SELECT COUNT(*)`` statements on partitioned tables didn't apply partition
filters if present in the WHERE clause.
2014/10/31 0.45.2
=================
- functions that are used with analyzed columns as arguments in the WHERE
clause of a SELECT statement no longer throw an error but behave just the
same as if used inside the result column list
- corrected alias handling
- improved error messages for ``regexp_matches`` and ``regexp_replace scalar``
function when arguments are of wrong type
- fix: ``regexp_matches`` with column ident as input raised exception
when used in IS (NOT) NULL predicate
- added missing _id collector expression so _id can also be used in
'insert from query' statements
- added support for scalar functions within the select column list and ORDER
BY clause for SELECT statements that get optimized to do
primary-key-lookups
- fix: Bulk inserts into partitioned tables resulted in inserting
all records into the partition of the last record
- updated crash to 0.10.3 which includes the following changes
- require crate-python 0.12.3 to get support for the iterator protocol
on cursor
- fixed an error that caused crash to crash on non posix platforms
- updated es/upstream to prevent spurious deletion of dangling indices
- fix: If an insert from query statement involved partitioned columns of a
partitioned table in the query part those partitioned columns weren't
resolved correctly and resulted in null values
- fix: raise an error if an array is inserted into an objects
field which is not of type array
- fix: all group by queries with the primary key(s) or routing column
as group key(s) are executed correctly
2014/10/21 0.44.8
=================
- Fix: all group by queries with the primary key(s) or routing column
as group key(s) are executed correctly
2014/10/21 0.45.1
2014/10/21 0.44.7
=================
- Fix: non-matching global aggregates on partitioned tables failed
- Fix: handle boost factor in simple match predicate correctly
- Reduced memory consumption of COPY FROM statements that involve partitioned
tables.
- Reduced memory consumption during execution of regular SELECT statements
- Fix: Requests that resulted in a shard failure could cause a NPE during the
generation of the error message.
2014/10/16 0.45.0
=================
- Support explicit type conversion using cast expression
- All scalar functions can now be used in the WHERE clause in SELECT
statements and they may be nested without limitations. In addition it is now
possible to compare one scalar function to another.
- Added support to compare one column with another in the WHERE clause for
SELECT statements.
- Implemented regular expression scalar functions and query operator
- Support for accessing items in an array. Please refer to the
``Crate SQL -> Querying Crate -> Retrieving Data -> Object Arrays``
documentation section for details and limitations.
- Renamed NullType to UndefinedType in order to avoid confusion
about its usage
2014/10/14 0.44.6
=================
- fix: pre-calculated count is now also used on partitioned tables
2014/10/10 0.44.5
=================
- fix: trying to copy out of a non-existent partition now throws an
appropriate exception
- fix: some shard errors were not being raised and so the shard failed silently
when some kind of errors, like an Out of memory error occured.
- upgraded ES upstream to v1.3.4
2014/10/04 0.44.4
2014/10/04 0.43.5
2014/10/04 0.42.5
=================
- Fix: The ``>`` and ``<`` operators didn't behave correctly in some cases for
string values if used on a system table or if both operands were literals.
- fix: updating a partitioned table with a WHERE clause querying for a
non existent column of for a non existent partition value led to
updating all partitions of the queried table
2014/10/02 0.44.3
2014/10/02 0.43.4
2014/10/02 0.42.4
=================
- fix: deleting on a partitioned table with a WHERE clause querying for a
non existent column or for a non existent partition value led to
deletion of all partitions of the queried table
- Fix: Copy from using the PARTITION clause imported into a ``null`` partition
instead of using the partition clause.
2014/09/26 0.44.2
2014/09/26 0.43.3
=================
- Track correct transient cluster setting for routing allocation
when performing graceful shutdown
- Improved error handling when trying to import data using COPY FROM
where primary key is a NULL value
2014/09/23 0.44.1
2014/09/23 0.43.2
=================
- BREAKING IF UPGRADING FROM 0.42:
The sub-folder in which blobs are saved by default has accidentily
been changed with 0.42, this change is now being reverted. For
users upgrading from 0.42 this means that they have to move
the directories ``tmp`` + ``var`` from the shard folders to
subfolder named ``blobs``. Users who upgrade from a version priour
to 0.42 can upgrade without worries.
2014/09/22 0.44.0
=================
- Support usage of all scalar functions in the ORDER BY clause without
limitations
- Using a column name that doesn't exist in the ORDER BY clause will throw an
error instead of silently ignoring it
- Implemented the graceful-stop command to enable zero downtime upgrades
- Exposed a lot of cluster settings, most of them are changeable at
runtime by using ``SET/RESET``
- BREAKING:
Existing cluster settings have been renamed:
- collect_stats to stats.enabled
- jobs_log_size to stats.jobs_log_size
- operations_log_size to stats.operations_log_size
Please refer to the ``Configuration`` section in the documentation
for more details
2014/09/22 0.43.1
=================
- fix: change the type of ``information_schema.table_constraints.constraint_name``
to array of string
- fix: properly return elements of object arrays in system tables
like sys.nodes.fs['data']['path']
- fix: filtering on system column ``_score`` is only valid by using a
``>=`` comparison, throw error if used otherwise
2014/09/11 0.43.0
=================
- ``RESET`` statement does not support the persistence keyword
anymore
- added having support for global aggregate and group by
2014/09/11 0.42.3
=================
- fixed bulk arguments validation: it was too strict and failed if the
arguments contains null values.
2014/09/08 0.42.2
=================
- fix: ``RESET`` statement must prefer configuration file setting values
over default values.
- fix: return column types if requested even on responses with no results
- updated lucene version in client to 4.9.0
2014/09/05 0.42.1
=================
- made parser for object and array literals stricter to allow only literals
- updated crash to 0.10.0 which includes following changes
- crate server version information is now also included in the connect-output
- improved formatting of field lists in docs
by adding docutils configuration to docs build process
- updated crate-python to version 0.11.1 to get a more reliable failover
mechanism if a host goes down.
BREAKING:
- Logging configuration files must now start with ``logging.`` and end with
either ``.yml`` or ``.yaml`` to be read. The previous behaviour was to read
all files starting with ``logging.`` which incorrectly also read ``.rpmnew``
or ``.bak`` files.
2014/08/25 0.42.0
=================
- improved the performance of GROUP BY queries that use the clustered by
column or the primary key as GROUP BY key
- upgraded ES upstream to v1.3.2
- implemented ``bulkSql`` methods for crate java client
- added support for update, delete and insert bulk operations
- updated crate-admin to 0.9.3 which includes following changes:
- send cookies with cross-origin requests
- match predicate can now be used on multiple columns
and supports several options for a more powerful fulltext search
- improve readability of documentation
- blobs can now be stored on different paths than normal tables,
custom path can be set global and per blob table
2014/08/22 0.41.4
=================
- COPY FROM now always assumes that the files it reads are encoded using UTF-8
instead of relying on the system default.
- fix: The table schema of partitioned table is now correctly invalidated if a
single partition has been modified using the ALTER TABLE statement with the
PARTITION clause.
- fix: correctly serialize sys expressions of type object
- fix: using the is not null predicate on a non-existing or ignored column
did throw an exception
2014/08/18 0.41.3
=================
- the ``fs['disks']`` expression will now only list block devices
- the number of shards in the ``CLUSTERED INTO`` clause of the ``CREATE
TABLE`` statement can now be specified using parameter substitution.
- fixed error handling on certain kind of failures that can occur on select
queries
- updated crate-admin to 0.9.2 which includes following changes
- fix: display number of records and started shards correctly
if table and blob table have the same name
- querying the node stats didn't work correctly if one of the paths couldn't
be read due to permission issues. Now Permission denied errors emit a
warning and disk stats are calculation continues.
2014/08/12 0.41.2
=================
- fix: ``match`` is now more strict and no longer searches nested objects if the searched column doesn't exist
and it is not allowed on non existing columns anymore
- improved readability of documentation
- improved formatting of field lists in docs
by adding docutils configuration to docs build process
- improved documentation codeblock formatting
- fix: it is now allowed to specify a custom fulltext analyzer
in a nested column definition
- remove documentation about information_schema.indices (which is not
implemented).
- improved error handling if illegal arguments are used in COPY FROM or COPY
TO statements.
- improved COPY TO documentation.
2014/08/01 0.41.1
=================
- fix: arithmetic functions correctly execute on all numeric types
- fix: throw an error on lossy conversion of numeric types
- fix: always return rowcount, even when it's not ascertenaible.
In this cases -1 is returned.
- fix: composite index must only work with `string` typed columns,
also defining it using the `plain` method must result in `keyword` analyzer
- fix: using non-equality comparison of a partition column within
`AND` expressions results in empty row set
2014/07/29 0.41.0
=================
- implemented the following scalar functions:
abs(x),
ceil(x),
floor(x),
ln(x),
log(x),
log(b,x),
random(),
round(x),
sqrt(x)
2014/08/01 0.40.4
=================
- fix: always return rowcount, even when it's not ascertenaible.
In this cases -1 is returned.
- fix: composite index must only work with `string` typed columns,
also defining it using the `plain` method must result in `keyword` analyzer
- fix: using non-equality comparison of a partition column within
`AND` expressions results in empty row set
2014/07/28 0.40.3
=================
- fix: ORDER BY using non-indexed (index off) column do fail silently
- fix: grouping or global aggregation using non-indexed (index off)
or analyzed (fulltext) column throws misleading exception
- added documentation for match function
- replaced SQLAction python doctest with java integration test
- updated incorrect options in crate usage information
- updated crate-admin to 0.9.1 which includes following changes
- fix: do not append limit to insert by query statement
2014/07/21 0.40.2
=================
- updated crash to 0.9.14 which includes the following changes
- fix: correctly apply ``-v`` switch to increase verbosity
- update crate-python to version 0.10.6
- made ``bin/crash`` posix compatible
- improved substr function to not copy underlying byte array
- retry fetching objects from s3 if a connection error occures
2014/07/15 0.40.1
=================
- fix: expose close() in crate client
- fix: make timeout of ``insert by query`` request configurable
as ``insert_by_query.request_timeout``
- fix: there was a possible race condition that could occur during blob
relocation.
- fix: fetch all keys from buckets with more than 1000 files
for import from S3
- fix: prevent early GC of AmazonS3Client which caused
premature end of response body in ``COPY FROM``
2014/07/11 0.40.0
=================
- ``COPY FROM`` / ``COPY TO``: allow importing from and exporting
to s3 without access credentials (only to / from public resources)
- fix: improved the clean up of distributed query execution if some part of
the operations couldn't be executed due to resource exhaustions
- performance improved of scalar function 'substr'
- updated crate-admin to 0.9.0 which contains following changes
- use new sys.nodes.fs expression in order to
calculate disk utilization of data disks correctly
- changed sys.nodes.fs column to contain stats about all mounted disks,
total disk stats and node data path locations
- changed output of colum names in information schema to subscript notation
- implemented sys.nodes.process expressions
- implemented sys.nodes.os expressions to show uptime and cpu utilization
- implemented sys.nodes.network expressions to show tcp network stats
- updated elasticsearch to 1.2.2
- added insert by query support
- added ``distance`` and ``within`` geo scalar functions
- implemented ``sys.cluster.master_node`` expression.
- it is now possible to use `is null` on columns of any data type.
- added support for ``alter table add column``
2014/07/08 0.39.3
=================
- fix: ``COPY FROM`` could result in a deadlock on high concurrency
- fix: apply proper quoting to crash arguments when used as ``bin/crash``
2014/07/06 0.39.2
=================
- fix: concurrent issues at ``COPY FROM`` retry logic
2014/07/03 0.39.1
=================
- fix: ``COPY FROM`` will now throttle and retry if there are failures due to
full thread pool queues
The ``concurrency`` option has also been removed.
- fix: improve input validation for objects and object arrays
- fix: avoid failed execution of ``DROP TABLE`` on partitioned table
to leave unrecoverable inconsistent state behind
- fix: columns referenced by positional arguments in a ``ORDER BY`` or
``GROUP BY`` clause are now validated for their data types
- fix: revised incorrect documentation about geo_point definition
- fix: if partitioned tables exists, information_schema queries did
not work properly
- updated crash to 0.9.13 which includes the following changes
- fix: avoid stripping arbitrative whitespaces from
commands passed via stdin
- fix: with a very large number of shards, queries on ``sys.shards`` could
overflow the threadpools
- updated crate-admin to 0.8.4 with includes following changes
- changed font in console for better readability
- fixed ui glitch that caused right column content to be cut off
- fix: include initializing shards in calculation for underreplicated shards
- fix: creating a table with arrays as primary key now correctly results in an
error as it is not supported
2014/06/16 0.39.0
=================
- upgraded elasticsearch to 1.1.2
- implemented `sys.shards.orphan_partition` expression
- updated crate-admin to 0.8.3
- display developer news notifications
- added ``substr`` scalar function
- added the ``sys.jobs``, ``sys.jobs_log``, ``sys.operations`` and
``sys.operations_log`` tables
- implemented ``SET`` and ``RESET`` statements
- implemented ``sys.nodes.thread_pools`` expressions
- implemented ``LIKE`` and ``NOT LIKE`` operators on string arrays and sets.
- improved error messages
- added arithmetic operators
- implemented partition support for ``copy`` statements
- implemented alter table to operate on single partitions
- implemented object and array literals
- changed refresh table for partitioned tables.
- the ordering of null values can now be influenced using the ``NULLS { FIRST
| LAST }`` keywords.
2014/06/16 0.38.6
=================
- fixed an NPE that could occur when retrieving shard stats from a blob table
- updated crate-admin to 0.7.4 which includes following changes:
- fixed ui glitch that caused right column content to be cut off
- fix: make table list and node list available in mobile view
- fix: round percentage of available and underreplicated data correctly
- make table that displays table partitions horizontally scrollable
2014/06/14 0.38.5
=================
- fix: validation for ``array`` and ``object`` typed partition
columns were broken
- updated crash to 0.9.12 which includes following changes:
- fixed output encoding when LC_CTYPE locale is not UTF-8
- fix: queries for ``_version=0`` have no match and do not execute as
``_version`` can never be ``0``
2014/06/07 0.38.4
=================
- fix: querying ``sys.shards`` could result in an exception if one of the
shards was initializing
- fix: where is null / is not null didn't work correctly on system tables
- fix: log error instead of recurring exception throwing if shard of
orphaned partition is started
- updated crate-admin to 0.7.4 which includes following changes:
- fix: make table list and node list available in mobile view
- fix: in some cases ``format`` function returned bytes instead of string
- fix: columns of type "ip" are now returned in the string representation
instead of the internal long format when returned as part of a group by
query.
2014/06/03 0.38.3
=================
- updated crash to 0.9.10 which includes following changes:
- NULL values are handled correctly
- fix: increased precision of float formatting
- crash renders complex types as json instead of their python representation
- return -1 for rowcount if rowcount is unknown
- fix: `date_trunc` will now accept literals of type long or string and
attempt to convert them to a timestamp.
- fix: ``count(*)`` on a table which has unavailable records will now result
in a failure instead of returning only the available records
- fix: insert statements with a large number of multi-values didn't insert all
rows if the internal threading queues run full.
- fix: display nested columns correctly in ``information_schema.table_partitions.values``
- fix: id generation on import via `COPY FROM` were wrong if multiple
primary key constraints and clustered-by were used.
WARNING: records must be re-imported otherwise queries with filter
on primary key columns will not match any record
2014/05/23 0.38.2
=================
- updated crash to 0.9.7 which includes following changes:
- return exit code 1 if the execution of a single command fails
2014/05/23 0.38.1
2014/05/23 0.37.5
=================
- fix: fixed schema update issues with partitioned tables.
- fix: DELETE on an empty partitioned table caused an error.
- fix: ORDER BY/GROUP BY clauses with ordinal numbers now work correctly
- fixed the glob pattern matching for S3 imports using the ``COPY FROM``
statement.
- fix: creating tables with nested primary keys and nested partitioned by columns
did not work correctly
- fix: insert and update partitioned tables with nested partition columns did not work
- fix: dynamic columns of partitioned tables did not show up in ``information_schema.columns``
when only one partition existed
2014/05/20 0.37.4
=================
- updated crash to 0.9.6 which includes the following changes:
- crash exited immediately with an exception if a query result
contained an object or array
- the size of the history file is now limited to 10000 lines
- stdin is no longer read completely into memory
2014/05/19 0.38.0
=================
- fix: default settings of crate client have been applied incorrect
- added support for select statements on blob tables. This can be used to list
the blobs that are stored inside a blob table.
- removed developer and installation instructions from documentation
- added the ``geo_point`` type.
- the data type of every responded column can now be returned via
REST using the optional parameter ``types`` or via transport by
defining it at the ``SQLRequest`` object
- improved building of client jar, also added maven upload task
2014/05/19 0.37.3
=================
- updated crate-admin version to 0.7.3 including following changes:
- fix: prevent selected node/table item from being out of viewport
- document data aggregation behaviour on fields in columns with disabled
indexing.
- updated crash to 0.9.5 which includes the following change:
- SQL statements passed in via the --command switch take precedence over stdin
- the ``CREATE TABLE`` statement now doesn't silently ignore analyzer
specifications on column types that don't support them.
2014/05/16 0.37.2
=================
- fix: allow aliased subscript expressions
- fix: allow single character blob table names
- fix: ``count(*)`` on empty partitioned tables threw a TableUnknownException.
- S3 authentication using ENV variables now also defaults to HTTP in order to
avoid certificate issues.
- updated crash version to 0.9.4 including following changes:
- updated crate-python to 0.10.0
- fix: crash exited immediately with an exception if a query result
contained two or more equal field names
- fix: if crash was started while one of the specified hosts was
not available crash exited immediately
- updated crate-admin version to 0.7.2 including following changes:
- improved handling of error responses from server
2014/05/09 0.37.1
2014/05/09 0.36.5
=================
- fix: raise an error if same column is defined more than once on
table creation
2014/05/08 0.37.0
=================
- documentation is no longer included in the distribution but available online only
- refactored exceptions, ``SQLActionException`` is now the only one thrown
via transport + REST
- forbid querying arrays inside object arrays in where clause or as select column
- increase debug output to show SQLRequests and errors in server log
- aliases for tables in SELECT, UPDATE, and DELETE clauses are now supported.
- renamed ``ANY`` aggregation function to ``ARBITRARY``
- implemented ``ANY`` / ``SOME`` operator for array containment checks
2014/05/12 0.36.6
=================
- improved error reporting for COPY operations using Amazon S3
2014/05/09 0.36.5
=================
- fix: raise an error if same column is defined more than once on
table creation
2014/05/07 0.36.4
=================
- fix: forbid order by on compound types (array, set, object)
- fix: transport serialization of set columns did not work correctly
2014/05/05 0.36.3
=================
- fix: date range queries (``WHERE ts > '1970-02-01'``) were misinterpreted
2014/04/29 0.36.2
=================
- updated crate-admin to 0.6.3 which includes the following fixes:
- fix: make sure twitter import stops when user navigates away from
tutorial view
- fix: allow horizontal scrolling in console result table
- fixed broken redirect after twitter authentication in 'get started'
section
- feature: implemented version in sys.nodes
- fix: the version check for update statements that contain a ``_version``
column in the where clause is now atomic.
- minor documentation improvements
2014/04/24 0.36.1