doltgresql

doltgresql copied to clipboard

Presumably because of lack of support for `information_schema`.

timsehn

Following the Dolt getting started: https://docs.dolthub.com/introduction/getting-started/database ``` getting_started=> select * from employees as of 'modifications'; ERROR: at or near "modifications": syntax error ```

timsehn

When running a naked server, you get the following line: `Starting server with Config HP="localhost:5432"|T="28800000"|R="false"|L="info"|S="/tmp/mysql.sock"` This is a hold-over from the underlying Dolt system, so we need to change it.

Hydrocharged

While the server is running, we'll occasionally get these in the logs: ``` ERROR [no conn] unable to determine if events need to be reloaded: expected token to be hash.Hash,...

Hydrocharged

``` $ doltgresql --help NAME dolt sql-server - Start a MySQL-compatible server. SYNOPSIS dolt sql-server --config dolt sql-server [-H ] [-P ] [-u ] [-p ] [-t ] [-l ]...

timsehn

`\d` (describe) does not work unscoped or with a table name

1

This is supposed to return a list of tables: ``` employees=> \d ERROR: syntax error at position 666 near 'nspname' (errno 1105) (sqlstate HY000) ``` This is supposed to describe...

timsehn

`show create table` and `show tables` should not work

2

Why we taunting Postgres users? ``` employees=> show create table employees; Table | Create Table -----------+------------------------------------------------------------------ employees | CREATE TABLE `employees` ( + | `id` int NOT NULL, + |...

timsehn

These errors in the logs. No tables listed `show tables` doesn't work but select * from a table works. ``` 2023-10-02T12:34:59-07:00 WARN [conn 4] error running query {connectTime=2023-10-02T12:34:59-07:00, connectionDb=employees, error=table...

timsehn