pscale shell copy + paste SQL issue

[leowmjw]

OS: MacOSX

To reproduce; create a new DB; and copy/paste the following --> https://raw.githubusercontent.com/temporalio/temporal/master/schema/mysql/v57/temporal/versioned/v1.0/schema.sql:

It seems to run fine for a while before hitting supposedly syntax error but when it is copied one by one is fine. I had to copy and paste a few times before everything takes hold!

It probably has some sort of streaming/buffer issue from the looks of it.

Errors :

$ pscale shell temporal v1
<COPY + PASTE>
...

CREATE TABLE tasks (
  range_hash INT UNSIGNED NOT NULL,
  task_queue_id VARBINARY(272) NOT NULL,
  task_id BIGINT NOT NULL,
  --
  data B  data B  data B  data B  data B  daR(16) NOT NULL,
  PRIMARY KEY (range_hash, task_queue_id, task_i  PRIMARY KEY (range_hash, task_queue_id, task_INT UNSIGNED NOT NULL,
  task_queue_id VARBINARY(2  task_queue_id VARBINARY(2  task_queue_id VARBI data BLOB NOT NULL,
  data_encoding VARCHAR(16) NOT NULL,    ->
    ->   status INT NOT NULL,
    ->   start_version BIGINT NOT NULL,
    ->   last_write_version BIGINT NOT NULL,
    ->   PRIMARY KEY (shard_id, namespace_id, workflow_id)
    -> );
ERROR 1064 (42000): target: temporal.-.master: vttablet: rpc error: code = InvalidArgument desc = You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE current_executions(pace_id BINARY(16) NOT NULL,
  workflow_id VARCH' at line 2 (errno 1064) (sqlstate 42000) (CallerID: unsecure_grpc_client): Sql: "CREATE TABLE current_executions(\nCREATE TABLE current_executions(pace_id BINARY(16) NOT NULL,\n  workflow_id VARCHAR(255) NOT NULL,\n
temporal/v1>
temporal/v1> CREATE TABLE buffered_events (
    ->   shard_id INT NOT NULL,
    ->   namespace_id BINARY(16) NOT NULL,
    ->   workf  workf  workf  workf  woULL,
    ->   run_id BINARY(16) NOT NULL,
    ->   id BIGINT AUTO_INCREMENT NOT NULL UNIQUE,
    ->   --
    ->   data MEDIUMBLOB NOT NULL,
    ->   data_encoding VARCHAR(16) NOT NULL,
    ->   PRIMARY KEY (shard_id, namespace_id, workflow_id, run_id, id)
    -> );
ERROR 1064 (42000): target: temporal.-.master: vttablet: rpc error: code = InvalidArgument desc = You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'workf  workf  workf  woULL,
  run_id BINARY(16) NOT NULL,
  id BIGINT AUTO_INCRE' at line 4 (errno 1064) (sqlstate 42000) (CallerID: unsecure_grpc_client): Sql: "CREATE TABLE buffered_events (\n  shard_id INT NOT NULL,\n  namespace_id BINARY(16) NOT NULL,\n  workf  workf  workf  workf  woULL,\n  r
temporal/v1>
temporal/v1> CREATE TABLE tasks (
    ->   range_hash INT UNSIGNED NOT NULL,
    ->   task_queue_id VARBINARY(272) NOT NULL,
    ->   task_id BIGINT NOT NULL,
    ->   --
    ->   data B  data B  data B  data B  data B  daR(16) NOT NULL,
    ->   PRIMARY KEY (range_hash, task_queue_id, task_i  PRIMARY KEY (range_hash, task_queue_id, task_INT UNSIGNED NOT NULL,
    ->   task_queue_id VARBINARY(2  task_queue_id VARBINARY(2  task_queue_id VARBI data BLOB NOT NULL,
    ->   data_encoding VARCHAR(16) NOT NULL,
    ->   PRIMARY KEY (range_hash, task_queue_id)
    -> );
ERROR 1064 (42000): target: temporal.-.master: vttablet: rpc error: code = InvalidArgument desc = You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'B  data B  data B  data B  data B  daR(16) NOT NULL,
  PRIMARY KEY (range_hash, ' at line 6 (errno 1064) (sqlstate 42000) (CallerID: unsecure_grpc_client): Sql: "CREATE TABLE tasks (\n  range_hash INT UNSIGNED NOT NULL,\n  task_queue_id VARBINARY(272) NOT NULL,\n  task_id BIGINT NOT NULL,\n  \n  d

...
temporal/v1>
temporal/v1> CREATE TABLE current_executions(
    -> CREATE TABLE current_executions(pace_id BINARY(16) NOT NULL,
    ->                                         -
    ->   run_id BINARY(16) NOT NULL,
    ->                                                                                          s                    NOT NULL,
    ->   last_write_version BIGINT NOT NULL,
    ->   PRIMARY KEY (shard_id, namespace_id, workflow_id)
    -> );
ERROR 1064 (42000): target: temporal.-.master: vttablet: rpc error: code = InvalidArgument desc = You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE current_executions(pace_id BINARY(16) NOT NULL,
                   ' at line 2 (errno 1064) (sqlstate 42000) (CallerID: unsecure_grpc_client): Sql: "CREATE TABLE current_executions(\nCREATE TABLE current_executions(pace_id BINARY(16) NOT NULL,\n

[Anders-PlanetScale]

@leowmjw,

Do you see the same error if you import the schema via:
pscale shell databasename branchname < schema.sql

I'll open an issue for the potential streaming/buffer error

[Anders-PlanetScale]

Just wanted to note this does not appear to be an issue for me using Terminator in Pop!_OS(Ubuntu derivative)

[leowmjw]

@Anders-PlanetScale ; thanks for the suggestion!

Looks like it might be issue when using iTerm2 with oh-my-zsh plugin.

Scenarios:

• Tested with cut-and-paste with OSX standard Terminal --> OK
• Tested with file redirection with OSX iTerm2 --> OK