Brian Hendriks
Brian Hendriks
create a new database and clone the us-jails database in it ``` mkdir ~/doltdbs/ cd doltdbs dolt clone dolthub/us-jails ``` Run this query from the command line: ``` >dolt sql...
Here I clone the data, export the tables to two files and then grab the create table statements needed when I create the tables on the new server ``` ~/datasets>dolt...
In dolt I get: ``` SELECT NOW(), DATE_ADD(NOW(), INTERVAL 14 DAY); +----------------------------+----------------------------------+ | NOW() | DATE_ADD(NOW(), INTERVAL 14 DAY) | +----------------------------+----------------------------------+ | 2022-09-20 13:23:05.020674 | 2022-10-04 | +----------------------------+----------------------------------+ ``` In...
If I take the following SQL which works: ``` MySQL [palilax/dev]> SET @event_id='cb8ba301-6c27-4bf8-b99b-617082d72621'; Query OK, 1 row affected (0.058 sec) MySQL [palilax/dev]> INSERT INTO person_cal_entries (id, cal_entry_id_fk, person_id_fk) -> SELECT...
updated project to use modules fixed quotation errors added additional tests
I am trying to use Dolt as the database for osticket, but there are queries that osticket runs that Dolt doesn't support. This is the one that is currently blocking...
Related to an issue that was previously fixed: https://github.com/dolthub/dolt/issues/984 Now we are seeing that every ~20 minutes or so the ordering changes. Running the query: What's weird is that the...