ln46: 
    START TRANSACTION;
    CREATE TABLE "t0" ("c0" INTERVAL SECOND NOT NULL, "c1" JSON);
    INSERT INTO "t0" VALUES (INTERVAL '9' SECOND, '""');

    CREATE TABLE "t1" ("c0" BINARY LARGE OBJECT,"c1" BIGINT);
    INSERT INTO "t1" VALUES (NULL, 1),(NULL, 6),(NULL, 0),(BINARY LARGE OBJECT '50', NULL),(BINARY LARGE OBJECT 'ACBC2EDEF0', NULL),
    (BINARY LARGE OBJECT '65', NULL),(BINARY LARGE OBJECT 'EF43C0', NULL),(BINARY LARGE OBJECT '90', NULL),(BINARY LARGE OBJECT '', NULL);

    CREATE TABLE "t2" ("c0" TINYINT NOT NULL,"c2" DATE);
    INSERT INTO "t2" VALUES (-7, NULL),(0, NULL),(-11, DATE '1970-01-01'),(8, DATE '1970-01-01'),(5, DATE '1970-01-01'),(1, DATE '1970-01-01'),
    (0, NULL),(1, NULL),(7, NULL),(5, NULL);

    CREATE TABLE "t3" ("c0" BIGINT,"c1" INTERVAL MONTH);
    INSERT INTO "t3" VALUES (1, INTERVAL '9' MONTH),(5, INTERVAL '6' MONTH),(5, NULL),(7, NULL),(2, INTERVAL '1' MONTH),(2, INTERVAL '1' MONTH);
    CREATE TABLE "t4" ("c0" BIGINT PRIMARY KEY,"c1" INTERVAL MONTH);
    INSERT INTO "t4" VALUES (1, INTERVAL '9' MONTH),(5, INTERVAL '6' MONTH),(10, NULL),(7, NULL),(2, INTERVAL '1' MONTH),(11, INTERVAL '1' MONTH);
    CREATE TABLE "t5" ("c0" DECIMAL(18,3),"c1" BOOLEAN);
    INSERT INTO "t5" VALUES (0.928, NULL),(0.974, NULL),(NULL, false),(3.000, NULL),(NULL, false),(NULL, false),(NULL, true),(0.897, NULL),
    (0.646, NULL),(0.145, true),(0.848, false),(NULL, false);
    CREATE TABLE "t6" ("c1" CLOB);
    INSERT INTO "t6" VALUES('3'), ('8ጮk|1*'), ('27'), ('Vrx^qA齀'), ('J'), ('18'), ('>*4嘁pAP'), ('+Jm*W0{'), ('>V鷓'), ('BW5z'), ('.#OJruk'),
    ('lU1覃Nlm'), (NULL), ('968786590');
    CREATE TABLE "t7" ("c0" SMALLINT);
    INSERT INTO "t7" VALUES (0),(0),(3),(3),(7),(-1),(5),(NULL),(5),(0),(5),(6),(4),(4),(4),(6),(7),(-7),(0),(1),(5),(9),(9),(8),(0);
    COMMIT;

    START TRANSACTION;
    CREATE REMOTE TABLE "rt1" ("c0" BINARY LARGE OBJECT,"c1" BIGINT) ON 'mapi:monetdb://localhost:45953/mTests_sql_test_SQLancer/sys/t1';
    CREATE REMOTE TABLE "rt2" ("c0" TINYINT NOT NULL,"c2" DATE) ON 'mapi:monetdb://localhost:45953/mTests_sql_test_SQLancer/sys/t2';
    CREATE REMOTE TABLE "rt3" ("c0" BIGINT,"c1" INTERVAL MONTH) ON 'mapi:monetdb://localhost:45953/mTests_sql_test_SQLancer/sys/t3';
    CREATE REMOTE TABLE "rt4" ("c0" BIGINT PRIMARY KEY,"c1" INTERVAL MONTH) ON 'mapi:monetdb://localhost:45953/mTests_sql_test_SQLancer/sys/t4';
    CREATE REMOTE TABLE "rt5" ("c0" DECIMAL(18,3),"c1" BOOLEAN) ON 'mapi:monetdb://localhost:45953/mTests_sql_test_SQLancer/sys/t5';
    CREATE REMOTE TABLE "rt6" ("c1" CLOB) ON 'mapi:monetdb://localhost:45953/mTests_sql_test_SQLancer/sys/t6';
    CREATE REMOTE TABLE "rt7" ("c0" SMALLINT) ON 'mapi:monetdb://localhost:45953/mTests_sql_test_SQLancer/sys/t7';
    COMMIT;
----
expected to succeed but didn't
42S01!CREATE TABLE: name 't0' already in use

ln49: SELECT json."integer"(JSON '1') FROM t3;
----
expected to succeed but didn't
42S02!SELECT: no such table 't3'
expected result but received empty!
query result:


ln51: SELECT json."integer"(JSON '1') FROM rt3;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln53: SELECT c0 BETWEEN 10 AND 11 FROM t3;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln55: SELECT c0 BETWEEN 10 AND 11 FROM rt3;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln57: SELECT c0 > 10 as myt, 4 BETWEEN 4 AND 4, c0 = 10 as myp, c0 BETWEEN 1 AND 1 as myp2 FROM t3 where t3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln59: SELECT c0 > 10 as myt, 4 BETWEEN 4 AND 4, c0 = 10 as myp, c0 BETWEEN 1 AND 1 as myp2 FROM rt3 where rt3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln61: SELECT c0 BETWEEN 2 AND 5 AS myproj FROM t3 ORDER BY myproj;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln63: SELECT c0 BETWEEN 2 AND 5 AS myproj FROM rt3 ORDER BY myproj;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln65: SELECT c0 > 4 AS myproj FROM t3 ORDER BY myproj;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln67: SELECT c0 > 4 AS myproj FROM rt3 ORDER BY myproj;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln69: MERGE INTO t0 USING (SELECT 1 FROM rt1) AS mergejoined(c0) ON TRUE WHEN NOT MATCHED THEN INSERT (c0) VALUES (INTERVAL '5' SECOND);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
received -1 rows, expected 0 rows

ln71: SELECT 1 FROM (values (0)) mv(vc0) LEFT OUTER JOIN (SELECT 1 FROM rt1) AS sub0(c0) ON 2 = 0.05488666234725814;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln73: SELECT c1 FROM rt1 WHERE rt1.c1 NOT BETWEEN 1 AND NULL;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln75: SELECT c1 FROM rt1 WHERE rt1.c1 NOT BETWEEN SYMMETRIC 1 AND NULL;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln77: SELECT 1 FROM (SELECT TIME '01:00:00' FROM rt1) va(vc1) WHERE greatest(va.vc1, TIME '01:01:01') <= TIME '01:01:02';
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln79: SELECT 3 > (rt2.c0 ^ CAST(2 AS TINYINT)) * rt2.c0 FROM rt2;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln81: SELECT r'"', r'\', ' ', '' as "'", '''' as " " from t3 where t3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln83: SELECT r'"', r'\', ' ', '' as "'", '''' as " " from rt3 where rt3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln85: SELECT 1 as "ups\", 2 as "\", 3 as """", 4 as """\", 5 as "\""" from t3 where t3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln87: SELECT 1 as "ups\", 2 as "\", 3 as """", 4 as """\", 5 as "\""" from rt3 where rt3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln89: SELECT "current_schema", current_user from t3 where t3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln91: SELECT "current_schema", current_user from rt3 where rt3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln93: SELECT sql_min(t3.c0 || t3.c0, 3) as x from t3 ORDER BY x;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln95: SELECT sql_min(rt3.c0 || rt3.c0, 3) as x from rt3 ORDER BY x;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln97: SELECT CASE WHEN 1 BETWEEN 1 AND 2 THEN 3*6 END FROM t3 where t3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln99: SELECT CASE WHEN 1 BETWEEN 1 AND 2 THEN 3*6 END FROM rt3 where rt3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln101: SELECT 3 / 0.84 FROM t3 where t3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln103: SELECT 3 / 0.84 FROM rt3 where rt3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln105: SELECT CAST(2 AS DECIMAL) * 0.010 FROM t3 where t3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln107: SELECT CAST(2 AS DECIMAL) * 0.010 FROM rt3 where rt3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln109: SELECT sql_min(4, 7 - 0.5207499) FROM t3 where t3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln111: SELECT sql_min(4, 7 - 0.5207499) FROM rt3 where rt3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln113: SELECT "insert"('99', 5, 8, '10S') FROM t3 where t3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln115: SELECT "insert"('99', 5, 8, '10S') FROM rt3 where rt3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln117: SELECT greatest('69', splitpart('', '191', 2)) FROM t3 where t3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln119: SELECT greatest('69', splitpart('', '191', 2)) FROM rt3 where rt3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln121: SELECT CAST(trim('14', 'abc') AS STRING(408)), CAST(trim('14', 'abc') AS VARCHAR(408)), CAST(trim('14', 'abc') AS CLOB) FROM t3 where t3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln123: SELECT CAST(trim('14', 'abc') AS STRING(408)), CAST(trim('14', 'abc') AS VARCHAR(408)), CAST(trim('14', 'abc') AS CLOB) FROM rt3 where rt3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln125: SELECT NULL, 'NULL', 'null', cast(NULL as clob), cast('NULL' as clob), cast('null' as clob) FROM t3 where t3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln127: SELECT NULL, 'NULL', 'null', cast(NULL as clob), cast('NULL' as clob), cast('null' as clob) FROM rt3 where rt3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln129: SELECT t3.c0 FROM t3 where (t3.c0) NOT IN (0.07564294, 211.0, 1, 2) ORDER BY t3.c0;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln131: SELECT rt3.c0 FROM rt3 where (rt3.c0) NOT IN (0.07564294, 211.0, 1, 2) ORDER BY rt3.c0;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln133: SELECT t3.c0 FROM t3 INNER JOIN t3 myx ON t3.c0 = myx.c0 ORDER BY t3.c0;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln135: SELECT rt3.c0 FROM rt3 INNER JOIN rt3 myx ON rt3.c0 = myx.c0 ORDER BY rt3.c0;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln137: SELECT t4.c0 FROM t4 ORDER BY t4.c0 DESC NULLS FIRST;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln139: SELECT rt4.c0 FROM rt4 ORDER BY rt4.c0 DESC NULLS FIRST;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln141: SELECT t4.c1 FROM t4 ORDER BY t4.c1 ASC NULLS LAST;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln143: SELECT rt4.c1 FROM rt4 ORDER BY rt4.c1 ASC NULLS LAST;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln145: SELECT t4.c1 + INTERVAL '2' MONTH AS myx FROM t4 ORDER BY myx ASC NULLS LAST;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln147: SELECT rt4.c1 + INTERVAL '2' MONTH AS myx FROM rt4 ORDER BY myx ASC NULLS LAST;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln149: SELECT t4.c1 + INTERVAL '5' MONTH AS myx FROM t4 GROUP BY myx ORDER BY myx;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln151: SELECT rt4.c1 + INTERVAL '5' MONTH AS myx FROM rt4 GROUP BY myx ORDER BY myx;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln153: SELECT TRUE BETWEEN (TRUE BETWEEN FALSE AND FALSE) AND TRUE FROM t3 where t3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln155: SELECT TRUE BETWEEN (TRUE BETWEEN FALSE AND FALSE) AND TRUE FROM rt3 where rt3.c0 = 1;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln157: SELECT 1 FROM t3 WHERE (t3.c0 BETWEEN t3.c0 AND t3.c0) IS NULL;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln159: SELECT 2 FROM rt3 WHERE (rt3.c0 BETWEEN rt3.c0 AND rt3.c0) IS NULL;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln161: SELECT upper(count(*)) FROM t3;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln163: SELECT upper(count(*)) FROM rt3;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln175: 
    CREATE FUNCTION testremote(a int) RETURNS INT
    BEGIN
        DECLARE b INT, "😀" INT, res1 INT, res2 INT;
        SET b = 2;
        SET "😀" = 4;
        SELECT a + b + "😀" + count(*) INTO res1 FROM t3;
        SELECT a + b + "😀" + count(*) INTO res2 FROM rt3;
        RETURN res1 + res2;
    END;
    
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln176: SELECT testremote(1);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln198: 
    CREATE FUNCTION testremote2(a int) RETURNS INT
    BEGIN
        DECLARE b INT, res INT;
        SET b = 2;
        IF a = 1 THEN
            DECLARE b INT;
            SET b = 3;
            SELECT b + count(*) INTO res FROM rt3;
        ELSE
            IF a = 2 THEN
                SELECT b + count(*) INTO res FROM rt3;
            ELSE
                DECLARE c INT;
                SET c = 5;
                SELECT c + b + count(*) INTO res FROM rt3;
            END IF;
        END IF;
        RETURN res;
    END;
    
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln199: SELECT testremote2(1), testremote2(2), testremote2(3);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln212: 
    CREATE FUNCTION testremote3(" ugh "" _ , !😂?, " INT) RETURNS INT
    BEGIN
        DECLARE " " INT,"""" INT, "\" INT, res INT;
        SET " " = 2;
        SET """" = 4;
        SET "\" = 10;
        SELECT " " + """" + "\" + count(*) + " ugh "" _ , !😂?, "
                + CASE "current_user" WHEN 'monetdb' THEN 7 ELSE 7 END INTO res FROM rt3;
        RETURN res;
    END;
    
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln219: 
    CREATE FUNCTION testremote4(a UUID, b JSON, c INT) RETURNS INT
    BEGIN
        RETURN SELECT (CASE a WHEN UUID '39FcCcEE-5033-0d81-42Eb-Ac6fFaA9EF2d' THEN 1 END) +
            (CASE b WHEN JSON '""' THEN 2 END) + (CASE c WHEN 3 THEN 3 END) + count(*) FROM rt3;
    END;
    
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln220: SELECT testremote3(1), testremote4(UUID '39FcCcEE-5033-0d81-42Eb-Ac6fFaA9EF2d', JSON '""', 3);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln228: 
    CREATE FUNCTION testremote5(a INET, b JSON, c DATE) RETURNS INT
    BEGIN
        RETURN SELECT (CASE a WHEN INET '192.168.1.0/26' THEN 1 END) +
            (CASE b WHEN JSON '[1]' THEN 2 END) + (CASE c WHEN DATE '2010-01-01' THEN 3 END) + count(*) FROM rt3;
    END;
    
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln229: SELECT testremote5(INET '192.168.1.0/26', JSON '[1]', DATE '2010-01-01'), testremote5(NULL, NULL, NULL);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln236: 
    CREATE FUNCTION testremote6(a BLOB) RETURNS INT
    BEGIN
        RETURN SELECT (CASE a WHEN BLOB 'AABB' THEN 1 ELSE 10 END) + count(*) FROM rt3;
    END;
    
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln237: SELECT testremote6(BLOB 'AABB'), testremote6(BLOB 'CCDD'), testremote6(NULL);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln244: 
    CREATE FUNCTION testremote7("😀😀😀😀😀😀😀😀😀😀😀😀😀😀😀" INT) RETURNS INT
    BEGIN
        RETURN SELECT (CASE "😀😀😀😀😀😀😀😀😀😀😀😀😀😀😀" WHEN 2 THEN 1 ELSE 10 END) + count(*) FROM rt3;
    END;
    
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln245: SELECT testremote7(2), testremote7(3);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln247: create view v0(vc0, vc1) as (values (interval '2' second, 0.5));
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln248: select 1 from rt1, v0, rt3 where "right_shift_assign"(inet '150.117.219.77', inet '1.188.46.21/12');
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln250: select 1 from t1, v0, t3 where "right_shift_assign"(inet '150.117.219.77', inet '1.188.46.21/12');
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln252: create view v1(vc0) as (select greatest(sql_sub(time '01:00:00', interval '0' second), time '01:00:00') from t3 where false);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln254: select 1 from (select distinct 1 from v1, rt3) as v1(vc1) where sql_min(true, true);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln256: select 1 from (select distinct 1 from v1, t3) as v1(vc1) where sql_min(true, true);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln258: SELECT count(*) FROM ((select 7 from rt3, (values (1)) y(y)) union (select 3)) x(x);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln260: SELECT count(*) FROM ((select 7 from t3, (values (1)) y(y)) union (select 3)) x(x);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln262: SELECT count(*) FROM ((select 7 from rt3, (values (1)) y(y)) union all (select 3)) x(x);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln264: SELECT count(*) FROM ((select 7 from t3, (values (1)) y(y)) union all (select 3)) x(x);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln266: create view v2(vc0) as ((select 3 from rt3) intersect (select 2 from t3));
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln268: create view v3(vc0) as (select 1 from rt3, v2 where "right_shift_assign"(inet '228.236.62.235/6', inet '82.120.56.164'));
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln270: create view v4(vc0, vc1, vc2) as (select 1, 2, 3);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln272: create view v5(vc0) as ((select time '01:00:00') intersect (select time '01:00:00' from v3));
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln274: create view v6(vc0) as ((select 1) union all (select 2));
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln276: select 1 from v4, v5, v6;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln278: create view v7(vc0) as (select case '201' when ',' then rt3.c0 when '' then cast(rt3.c0 as bigint) end from rt3);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln280: SELECT 1 FROM v7 CROSS JOIN ((SELECT 1) UNION ALL (SELECT 2)) AS sub0(c0);
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln286: 
        SELECT 1 FROM (VALUES (2),(3)) x(x) FULL OUTER JOIN (SELECT t1.c1 <= CAST(t1.c1 AS INT) FROM t1) AS sub0(c0) ON true WHERE sub0.c0
        UNION ALL
        SELECT 1 FROM (VALUES (2),(3)) x(x) FULL OUTER JOIN (SELECT t1.c1 <= CAST(t1.c1 AS INT) FROM t1) AS sub0(c0) ON true;
        
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln292: 
        SELECT 1 FROM (VALUES (2),(3)) x(x) FULL OUTER JOIN (SELECT rt1.c1 <= CAST(rt1.c1 AS INT) FROM rt1) AS sub0(c0) ON true WHERE sub0.c0
        UNION ALL
        SELECT 1 FROM (VALUES (2),(3)) x(x) FULL OUTER JOIN (SELECT rt1.c1 <= CAST(rt1.c1 AS INT) FROM rt1) AS sub0(c0) ON true;
        
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln294: SELECT count(0.3121149) FROM (select case when 2 > 1 then 0.3 end from (select 1 from t3) x(x)) v100(vc1), t3 WHERE 5 >= sinh(CAST(v100.vc1 AS REAL));
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln296: SELECT count(0.3121149) FROM (select case when 2 > 1 then 0.3 end from (select 1 from rt3) x(x)) v100(vc1), rt3 WHERE 5 >= sinh(CAST(v100.vc1 AS REAL));
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln298: SELECT CAST(2 AS REAL) BETWEEN 2 AND (t5.c0 / t5.c0)^5 AS X FROM t5 ORDER BY x NULLS LAST;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln300: SELECT CAST(2 AS REAL) BETWEEN 2 AND (rt5.c0 / rt5.c0)^5 AS X FROM rt5 ORDER BY x NULLS LAST;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln302: SELECT count(*) AS mx FROM t3 GROUP BY 1 + least(2, round(0.68, t3.c0)) ORDER BY mx;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln304: SELECT count(*) AS mx FROM rt3 GROUP BY 1 + least(2, round(0.68, rt3.c0)) ORDER BY mx;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln306: SELECT 1 FROM t3 INNER JOIN (SELECT 1 FROM t2) AS sub0(c0) ON ((2) IN (3, 6)) WHERE 4 < least(NULL, least(t3.c0, t3.c0));
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln308: SELECT 1 FROM rt3 INNER JOIN (SELECT 1 FROM t2) AS sub0(c0) ON ((2) IN (3, 6)) WHERE 4 < least(NULL, least(rt3.c0, rt3.c0));
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)

ln310: SELECT t7.c0 FROM t7 WHERE (((('5' LIKE '0.53')OR((VALUES (0 < ANY(VALUES (7), (0)))))))OR(4 NOT BETWEEN -t7.c0 AND t7.c0)) ORDER BY c0;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln312: SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((((('5' LIKE '0.53')OR((VALUES (0 < ANY(VALUES (7), (0)))))))OR(4 NOT BETWEEN -t7.c0 AND t7.c0)) AS INT) as count FROM t7) as res;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln314: SELECT rt7.c0 FROM rt7 WHERE (((('5' LIKE '0.53')OR((VALUES (0 < ANY(VALUES (7), (0)))))))OR(4 NOT BETWEEN -rt7.c0 AND rt7.c0)) ORDER BY c0;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln316: SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((((('5' LIKE '0.53')OR((VALUES (0 < ANY(VALUES (7), (0)))))))OR(4 NOT BETWEEN -rt7.c0 AND rt7.c0)) AS INT) as count FROM rt7) as res;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln318: SELECT c1 FROM t6;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln321: SELECT c1 FROM rt6;
----
expected to succeed but didn't
25005!Current transaction is aborted (please ROLLBACK)
expected result but received empty!
query result:


ln328: SELECT 1 FROM rt3 HAVING (min(TIME '02:00:00') IN (TIME '02:00:00')) IS NULL;
----
expected to fail with error message 'Illegal argument: cannot fetch a single row from an empty input' but failed with error message 'Exception occurred in the remote server, please check the log there'

ln330: SELECT 1 FROM rt3 HAVING mybooludf(min(false));
----
expected to fail with error message 'Illegal argument: cannot fetch a single row from an empty input' but failed with error message 'Exception occurred in the remote server, please check the log there'

ln351: 
    START TRANSACTION;
    DROP TABLE rt1;
    DROP TABLE rt2;
    DROP TABLE rt3;
    DROP TABLE rt4;
    DROP TABLE rt5;
    DROP TABLE rt6;
    DROP TABLE rt7;
    DROP TABLE t0;
    DROP TABLE t1;
    DROP TABLE t2;
    DROP TABLE t3;
    DROP TABLE t4;
    DROP TABLE t5;
    DROP TABLE t6;
    DROP TABLE t7;
    DROP FUNCTION mybooludf(bool);
    COMMIT;
----
expected to succeed but didn't
42S02!DROP TABLE: no such table 't2'