sql.txt: just added a '\n' after each ';', so that commands are more
easily visible, in Web Studio (for GEB tests).
StudioWebDiag.groovy: updated to check for an ‘Error:’ before looking
for results in a table, and the Error need not be the first thing
listed; after each query test, it now deletes all data from
REPLICATED_TABLE, as well as PARTITIONED_TABLE; also increased the range
of the try/finally, to catch most test failures; and added debug print
(triggered whenever a test fails, or optionally for all tests), and wait
options, so you can see the results go by slowly.
sql.txt: added lots of tests, of UPSERT (mostly modeled on existing
tests of INSERT), INSERT INTO SELECT, and UPSERT INTO SELECT.
sql.txt: added “Insert” prefix to names of Invalid Insert tests (to
easily distinguish them from the similar ones we now have, for
“Upsert”); corrected the name of the “UpsertIntoSelectPart2Part” test
(was “InsertIntoSelectPart2Part”, a duplicate due to a cut-and-paste
error); and removed unnecessary “SELECT” statements from the
“UpsertIntoSelectNoOrderBy” and “UpsertIntoSelectPart2Repl” tests, which
don’t need them since they are supposed to throw errors.
elemsNewUI.txt: updated the expected HTML elements with specified id,
for the new UI.
StudioWebDiag.groovy: improvements for the latest version of the new UI:
added waits for page-loading and login; updated the URL for the new UI
(which no longer needs username/password for HTTP authentication);
updated the expected status messages for the new UI (“Query took”);
cleaned up / reorganized the ‘#testName’ method; included a kludge (in
‘#testName’ & checkResponse) for the fact that the new UI currently
always returns ‘Connect to a datasource first’ when run via Selenium.
Merge pull request #1712 from VoltDB/ENG-6998-geb-in-up-sert-into-select

Eng 6998 geb in up sert into select