From 5fa5621f574f9ae211ed756c3e2ad453470dae8a Mon Sep 17 00:00:00 2001 From: Claude Paroz Date: Mon, 3 Dec 2012 20:03:05 +0100 Subject: Fixed #19416 -- Fixed multi-line commands in initial SQL files Thanks Aymeric Augustin for detecting this regression. --- tests/regressiontests/initial_sql_regress/sql/simple.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'tests/regressiontests/initial_sql_regress/sql/simple.sql') diff --git a/tests/regressiontests/initial_sql_regress/sql/simple.sql b/tests/regressiontests/initial_sql_regress/sql/simple.sql index 39363baa9a..abd9fee92b 100644 --- a/tests/regressiontests/initial_sql_regress/sql/simple.sql +++ b/tests/regressiontests/initial_sql_regress/sql/simple.sql @@ -2,7 +2,8 @@ INSERT INTO initial_sql_regress_simple (name) VALUES ('John'); -- another comment INSERT INTO initial_sql_regress_simple (name) VALUES ('-- Comment Man'); INSERT INTO initial_sql_regress_simple (name) VALUES ('Paul'); -INSERT INTO initial_sql_regress_simple (name) VALUES ('Ringo'); +INSERT INTO initial_sql_regress_simple + VALUES (150, 'Ringo'); INSERT INTO initial_sql_regress_simple (name) VALUES ('George'); INSERT INTO initial_sql_regress_simple (name) VALUES ('Miles O''Brien'); INSERT INTO initial_sql_regress_simple (name) VALUES ('Semicolon;Man'); -- cgit v1.3 From 0cdfa76e68468ddf0a99198e1db07a703354b5af Mon Sep 17 00:00:00 2001 From: Claude Paroz Date: Mon, 10 Dec 2012 17:43:07 +0100 Subject: Amended an SQL test fixture to not include an id value Some backends might need special handling for auto-increment values. This was introduced in 5fa5621f574. Thanks Michael Manfre for spotting the issue. --- tests/regressiontests/initial_sql_regress/sql/simple.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'tests/regressiontests/initial_sql_regress/sql/simple.sql') diff --git a/tests/regressiontests/initial_sql_regress/sql/simple.sql b/tests/regressiontests/initial_sql_regress/sql/simple.sql index abd9fee92b..d82f8381af 100644 --- a/tests/regressiontests/initial_sql_regress/sql/simple.sql +++ b/tests/regressiontests/initial_sql_regress/sql/simple.sql @@ -2,8 +2,8 @@ INSERT INTO initial_sql_regress_simple (name) VALUES ('John'); -- another comment INSERT INTO initial_sql_regress_simple (name) VALUES ('-- Comment Man'); INSERT INTO initial_sql_regress_simple (name) VALUES ('Paul'); -INSERT INTO initial_sql_regress_simple - VALUES (150, 'Ringo'); +INSERT INTO + initial_sql_regress_simple (name) VALUES ('Ringo'); INSERT INTO initial_sql_regress_simple (name) VALUES ('George'); INSERT INTO initial_sql_regress_simple (name) VALUES ('Miles O''Brien'); INSERT INTO initial_sql_regress_simple (name) VALUES ('Semicolon;Man'); -- cgit v1.3