Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space ML1 and version 9.2

...

Consistent ordering in ClustrixDB guarantees that rows returned from repeated runs of the same query are always in the same order. If a query does not specify an explicit ORDER BY and the consistent_order global variable is set to false, the order in which rows are returned is not guaranteed to be the same for repeated executions.

...

Consistent ordering can be specified per session or globally. To enable consistent ordering, set the value for consistent_order to true.

sql> INSERT INTO foo VALUES (0),(1),(2),(3);
sql> SELECT * FROM foo;
+----+
| id |
+----+
|  2 |
|  1 |
|  4 |
|  0 |
+----+
4 rows in set (0.00 sec)
sql> SET session consistent_order = true; 
sql> SELECT * FROM foo;
+----+
| id | 
+----+
|  0 |
|  1 |
|  2 |
|  3 |
+----+
4 rows in set (0.00 sec)

...