#!/usr/bin/expect

set timeout 10
set env(NO_COLOR) 1

source  "$env(BATS_CWD)/helper/common_expect_functions.tcl"

spawn dolt sql

expect_with_defaults                                  {dolt-repo-[0-9]+/main\*>} { send "insert into t1 (SELECT * FROM t WHERE EXISTS(SELECT SLEEP(1) UNION SELECT 1));\r" }

expect_with_defaults_2 {Query OK, 1 row affected \(1} {dolt-repo-[0-9]+/main\*>} { send "insert into t1 (SELECT * FROM t WHERE EXISTS(SELECT SLEEP(2) UNION SELECT 1));\r" }

expect_with_defaults_2 {Query OK, 1 row affected \(2} {dolt-repo-[0-9]+/main\*>} { send "insert into t1 (SELECT * FROM t WHERE EXISTS(SELECT SLEEP(3) UNION SELECT 1));\r" }

expect_with_defaults_2 {Query OK, 1 row affected \(3} {dolt-repo-[0-9]+/main\*>} { send "quit\r" }

expect eof
exit