- Allowing views and queries as parameters for PROXY base tables

  NOTE: Checking for looping references cannot be done when using views
  as parameters. This should not be allowed on production servers and
  should be dependant on a system variable and/or on speciel grant.

modified:
  storage/connect/CMakeLists.txt
  storage/connect/connect.cc
  storage/connect/ha_connect.cc
  storage/connect/myconn.cpp
  storage/connect/myconn.h
  storage/connect/mysql-test/connect/r/fmt.result
  storage/connect/mysql-test/connect/r/pivot.result
  storage/connect/mysql-test/connect/t/fmt.test
  storage/connect/mysql-test/connect/t/pivot.test
  storage/connect/plgdbsem.h
  storage/connect/plugutil.c
  storage/connect/tabcol.cpp
  storage/connect/tabcol.h
  storage/connect/tabfmt.cpp
  storage/connect/tabmysql.cpp
  storage/connect/tabmysql.h
  storage/connect/taboccur.cpp
  storage/connect/taboccur.h
  storage/connect/tabpivot.cpp
  storage/connect/tabpivot.h
  storage/connect/tabtbl.cpp
  storage/connect/tabutil.cpp
  storage/connect/tabutil.h
  storage/connect/xtable.h

4 files changed, 235 insertions, 234 deletions

diff --git a/storage/connect/mysql-test/connect/r/fmt.result b/storage/connect/mysql-test/connect/r/fmt.result
index dc3b42b2231..0be10f69bfd 100644
--- a/storage/connect/mysql-test/connect/r/fmt.result
+++ b/storage/connect/mysql-test/connect/r/fmt.result
@@ -18,7 +18,7 @@ CREATE TABLE t1
 id INT NOT NULL field_format=' %n%d%n'
 ) ENGINE=CONNECT TABLE_TYPE=FMT FILE_NAME='t1.txt';
 INSERT INTO t1 VALUES (10),(20);
-ERROR HY000: Got error 122 'Writing FMT files is not implemented yet' from CONNECT
+ERROR HY000: Got error 174 'Writing FMT files is not implemented yet' from CONNECT
 DROP TABLE t1;
 #
 # Testing manual examples
@@ -59,7 +59,7 @@ ID	NAME	DEPNO	SALARY
 56	POIROT-DELMOTTE	0	18009.00
 345		67	19000.25
 UPDATE t1 SET SALARY=1234;
-ERROR HY000: Got error 122 'Writing FMT files is not implemented yet' from CONNECT
+ERROR HY000: Got error 174 'Writing FMT files is not implemented yet' from CONNECT
 DELETE FROM t1 WHERE ID=56;
 SELECT * FROM t1;
 ID	NAME	DEPNO	SALARY
diff --git a/storage/connect/mysql-test/connect/r/pivot.result b/storage/connect/mysql-test/connect/r/pivot.result
index 4480788332b..1b790662c4b 100644
--- a/storage/connect/mysql-test/connect/r/pivot.result
+++ b/storage/connect/mysql-test/connect/r/pivot.result
@@ -77,8 +77,8 @@ Beer DOUBLE(8,2) FLAG=1,
 Car  DOUBLE(8,2) FLAG=1,
 Food DOUBLE(8,2) FLAG=1)
 ENGINE=CONNECT TABLE_TYPE=PIVOT
-SRCDEF='select who, week, what, sum(amount) from expenses where week in (4,5) group by who, week, what';
-ALTER TABLE pivex OPTION_LIST='port=PORT';
+SRCDEF='select who, week, what, sum(amount) as amount from expenses where week in (4,5) group by who, week, what';
+ALTER TABLE pivex OPTION_LIST='PivotCol=what,FncCol=amount,port=PORT';
 Warnings:
 Warning	1105	The current version of CONNECT did not check what you changed in ALTER. Use at your own risk
 SELECT * FROM pivex;
@@ -125,7 +125,7 @@ Middle DOUBLE(8,2) FLAG=1,
 Last   DOUBLE(8,2) FLAG=1)
 ENGINE=CONNECT TABLE_TYPE=PIVOT
 SRCDEF='select who, what, case when week=3 then ''First'' when week=5 then ''Last'' else ''Middle'' end as wk, sum(amount) * 6.56 as amnt from expenses group by who, what, wk';
-ALTER TABLE pivex OPTION_LIST='PivotCol=wk,port=PORT';
+ALTER TABLE pivex OPTION_LIST='PivotCol=wk,FncCol=amnt,port=PORT';
 Warnings:
 Warning	1105	The current version of CONNECT did not check what you changed in ALTER. Use at your own risk
 SELECT * FROM pivex;
diff --git a/storage/connect/mysql-test/connect/t/fmt.test b/storage/connect/mysql-test/connect/t/fmt.test
index de7f8c06c1b..662bc70c8b1 100644
--- a/storage/connect/mysql-test/connect/t/fmt.test
+++ b/storage/connect/mysql-test/connect/t/fmt.test
@@ -1,85 +1,85 @@
-let $MYSQLD_DATADIR= `select @@datadir`;
---copy_file $MTR_SUITE_DIR/std_data/funny.txt $MYSQLD_DATADIR/test/funny.txt
---copy_file $MTR_SUITE_DIR/std_data/funny2.txt $MYSQLD_DATADIR/test/funny2.txt
-
---echo #
---echo # Testing errors
---echo #
-CREATE TABLE t1
-(
-  ID INT NOT NULL field_format=' %n%d%n'
-) Engine=CONNECT table_type=FMT file_name='nonexistent.txt';
---replace_regex /on .*test.nonexistent.txt/on DATADIR\/test\/nonexistent.txt/
-# TODO: check why this is needed for Windows
---replace_result Open(rt) Open(rb)
-SELECT * FROM t1;
-DROP TABLE t1;
-
-
---echo #
---echo # Testing update on FMT tables
---echo #
-CREATE TABLE t1
-(
-  id INT NOT NULL field_format=' %n%d%n'
-) ENGINE=CONNECT TABLE_TYPE=FMT FILE_NAME='t1.txt';
---error ER_GET_ERRMSG
-INSERT INTO t1 VALUES (10),(20);
-# TODO:
-#--error ER_GET_ERRMSG
-#UPDATE t1 SET id=20;
-#TRUNCATE TABLE t1;
-#DELETE FROM t1 WHERE id=10;
-#SELECT * FROM t1;
-DROP TABLE t1;
---remove_file $MYSQLD_DATADIR/test/t1.txt
-
-
---echo #
---echo # Testing manual examples
---echo #
-CREATE TABLE t1
-(
-  ID Integer(5) not null field_format=' %n%d%n',
-  NAME Char(16) not null field_format=" , '%n%[^']%n'",
-  DEPNO Integer(4) not null field_format=' , #%n%d%n',
-  SALARY Double(12,2) not null field_format=' ; %n%f%n'
-) Engine=CONNECT table_type=FMT file_name='funny.txt';
-SELECT * FROM t1;
-DROP TABLE t1;
-
-#
-# TODO: shoudn't a warning instead of error be returned on bad format?
-#
-CREATE TABLE t1
-(
-  ID Integer(5) not null field_format=' %n%d%n',
-  NAME Char(16) not null field_format=" , '%n%[^']%n'",
-  DEPNO Integer(4) not null field_format=' , #%n%d%n',
-  SALARY Double(12,2) not null field_format=' ; %n%f%n'
-) Engine=CONNECT table_type=FMT file_name='funny2.txt';
---error ER_GET_ERRMSG
-SELECT * FROM t1;
-DROP TABLE t1;
-
-CREATE TABLE t1
-(
-  ID Integer(5) not null field_format=' %n%d%n',
-  NAME Char(16) not null field_format=' , ''%n%[^'']%m',
-  DEPNO Integer(4) not null field_format=''' , #%n%d%m',
-  SALARY Double(12,2) not null field_format=' ; %n%f%n'
-) Engine=CONNECT table_type=FMT file_name='funny2.txt';
-SELECT * FROM t1;
---error ER_GET_ERRMSG
-UPDATE t1 SET SALARY=1234;
-# TODO: this query crashes
-# UPDATE t1 SET SALARY=1234 WHERE ID=56;
-DELETE FROM t1 WHERE ID=56;
-SELECT * FROM t1;
-DROP TABLE t1;
-
-#
-# Clean up
-#
---remove_file $MYSQLD_DATADIR/test/funny.txt
---remove_file $MYSQLD_DATADIR/test/funny2.txt
+let $MYSQLD_DATADIR= `select @@datadir`;

+--copy_file $MTR_SUITE_DIR/std_data/funny.txt $MYSQLD_DATADIR/test/funny.txt

+--copy_file $MTR_SUITE_DIR/std_data/funny2.txt $MYSQLD_DATADIR/test/funny2.txt

+

+--echo #

+--echo # Testing errors

+--echo #

+CREATE TABLE t1

+(

+  ID INT NOT NULL field_format=' %n%d%n'

+) Engine=CONNECT table_type=FMT file_name='nonexistent.txt';

+--replace_regex /on .*test.nonexistent.txt/on DATADIR\/test\/nonexistent.txt/

+# TODO: check why this is needed for Windows

+--replace_result Open(rt) Open(rb)

+SELECT * FROM t1;

+DROP TABLE t1;

+

+

+--echo #

+--echo # Testing update on FMT tables

+--echo #

+CREATE TABLE t1

+(

+  id INT NOT NULL field_format=' %n%d%n'

+) ENGINE=CONNECT TABLE_TYPE=FMT FILE_NAME='t1.txt';

+--error ER_GET_ERRMSG

+INSERT INTO t1 VALUES (10),(20);

+# TODO:

+#--error ER_GET_ERRMSG

+#UPDATE t1 SET id=20;

+#TRUNCATE TABLE t1;

+#DELETE FROM t1 WHERE id=10;

+#SELECT * FROM t1;

+DROP TABLE t1;

+#--remove_file $MYSQLD_DATADIR/test/t1.txt

+

+

+--echo #

+--echo # Testing manual examples

+--echo #

+CREATE TABLE t1

+(

+  ID Integer(5) not null field_format=' %n%d%n',

+  NAME Char(16) not null field_format=" , '%n%[^']%n'",

+  DEPNO Integer(4) not null field_format=' , #%n%d%n',

+  SALARY Double(12,2) not null field_format=' ; %n%f%n'

+) Engine=CONNECT table_type=FMT file_name='funny.txt';

+SELECT * FROM t1;

+DROP TABLE t1;

+

+#

+# TODO: shoudn't a warning instead of error be returned on bad format?

+#

+CREATE TABLE t1

+(

+  ID Integer(5) not null field_format=' %n%d%n',

+  NAME Char(16) not null field_format=" , '%n%[^']%n'",

+  DEPNO Integer(4) not null field_format=' , #%n%d%n',

+  SALARY Double(12,2) not null field_format=' ; %n%f%n'

+) Engine=CONNECT table_type=FMT file_name='funny2.txt';

+--error ER_GET_ERRMSG

+SELECT * FROM t1;

+DROP TABLE t1;

+

+CREATE TABLE t1

+(

+  ID Integer(5) not null field_format=' %n%d%n',

+  NAME Char(16) not null field_format=' , ''%n%[^'']%m',

+  DEPNO Integer(4) not null field_format=''' , #%n%d%m',

+  SALARY Double(12,2) not null field_format=' ; %n%f%n'

+) Engine=CONNECT table_type=FMT file_name='funny2.txt';

+SELECT * FROM t1;

+--error ER_GET_ERRMSG

+UPDATE t1 SET SALARY=1234;

+# TODO: this query crashes

+# UPDATE t1 SET SALARY=1234 WHERE ID=56;

+DELETE FROM t1 WHERE ID=56;

+SELECT * FROM t1;

+DROP TABLE t1;

+

+#

+# Clean up

+#

+--remove_file $MYSQLD_DATADIR/test/funny.txt

+--remove_file $MYSQLD_DATADIR/test/funny2.txt

diff --git a/storage/connect/mysql-test/connect/t/pivot.test b/storage/connect/mysql-test/connect/t/pivot.test
index f06c92828f9..87601a26d28 100644
--- a/storage/connect/mysql-test/connect/t/pivot.test
+++ b/storage/connect/mysql-test/connect/t/pivot.test
@@ -1,144 +1,145 @@
-let $MYSQLD_DATADIR= `select @@datadir`;
-let $PORT= `select @@port`;
---copy_file $MTR_SUITE_DIR/std_data/expenses.txt $MYSQLD_DATADIR/test/expenses.txt
-
---echo #
---echo # Testing the PIVOT table type
---echo #
-CREATE TABLE expenses (
-Who  CHAR(10) NOT NULL,
-Week INT(2) NOT NULL,
-What CHAR(12) NOT NULL,
-Amount DOUBLE(8,2))
-ENGINE=CONNECT TABLE_TYPE=FIX FILE_NAME='expenses.txt' ENDING=2;
-SELECT * FROM expenses;
-
---echo #
---echo # Pivoting from What
---echo #
-CREATE TABLE pivex (
-Who  CHAR(10) NOT NULL,
-Week INT(2) NOT NULL,
-Beer DOUBLE(8,2) FLAG=1,
-Car  DOUBLE(8,2) FLAG=1,
-Food DOUBLE(8,2) FLAG=1)
-ENGINE=CONNECT TABLE_TYPE=PIVOT TABNAME=expenses;
---replace_result $PORT PORT
---eval ALTER TABLE pivex OPTION_LIST='port=$PORT'
-SELECT * FROM pivex;
-
---echo #
---echo # Restricting the columns in a Pivot Table
---echo #
-ALTER TABLE pivex DROP COLUMN week;
-SELECT * FROM pivex;
-
---echo #
---echo # Using a source definition
---echo #
-DROP TABLE pivex;
-CREATE TABLE pivex (
-Who  CHAR(10) NOT NULL,
-Week INT(2) NOT NULL,
-Beer DOUBLE(8,2) FLAG=1,
-Car  DOUBLE(8,2) FLAG=1,
-Food DOUBLE(8,2) FLAG=1)
-ENGINE=CONNECT TABLE_TYPE=PIVOT
-SRCDEF='select who, week, what, sum(amount) from expenses where week in (4,5) group by who, week, what';
---replace_result $PORT PORT
---eval ALTER TABLE pivex OPTION_LIST='port=$PORT'
-SELECT * FROM pivex;
-
---echo #
---echo # Pivoting from Week
---echo #
-DROP TABLE pivex;
-CREATE TABLE pivex (
-Who  CHAR(10) NOT NULL,
-What CHAR(12) NOT NULL,
-`3` DOUBLE(8,2) FLAG=1,
-`4` DOUBLE(8,2) FLAG=1,
-`5` DOUBLE(8,2) FLAG=1)
-ENGINE=CONNECT TABLE_TYPE=PIVOT TABNAME=expenses;
---replace_result $PORT PORT
---eval ALTER TABLE pivex OPTION_LIST='PivotCol=Week,port=$PORT'
-SELECT * FROM pivex;
-
---echo #
---echo # Using scalar functions and expresssions
---echo #
-DROP TABLE pivex;
-CREATE TABLE pivex (
-Who  CHAR(10) NOT NULL,
-What CHAR(12) NOT NULL,
-First  DOUBLE(8,2) FLAG=1,
-Middle DOUBLE(8,2) FLAG=1,
-Last   DOUBLE(8,2) FLAG=1)
-ENGINE=CONNECT TABLE_TYPE=PIVOT
-SRCDEF='select who, what, case when week=3 then ''First'' when week=5 then ''Last'' else ''Middle'' end as wk, sum(amount) * 6.56 as amnt from expenses group by who, what, wk';
---replace_result $PORT PORT
---eval ALTER TABLE pivex OPTION_LIST='PivotCol=wk,port=$PORT'
-SELECT * FROM pivex;
-DROP TABLE pivex;
-DROP TABLE expenses;
-
---echo #
---echo # Make the PETS table
---echo #
-CREATE TABLE pets (
-Name VARCHAR(12) NOT NULL,
-Race CHAR(6) NOT NULL,
-Number INT NOT NULL) ENGINE=MYISAM;
-INSERT INTO pets VALUES('John','dog',2);
-INSERT INTO pets VALUES('Bill','cat',1);
-INSERT INTO pets VALUES('Mary','dog',1);
-INSERT INTO pets VALUES('Mary','cat',1);
-INSERT INTO pets VALUES('Lisbeth','rabbit',2);
-INSERT INTO pets VALUES('Kevin','cat',2);
-INSERT INTO pets VALUES('Kevin','bird',6);
-INSERT INTO pets VALUES('Donald','dog',1);
-INSERT INTO pets VALUES('Donald','fish',3);
-SELECT * FROM pets;
-
---echo #
---echo # Pivot the PETS table
---echo #
-CREATE TABLE pivet (
-name VARCHAR(12) NOT NULL,
-dog    INT NOT NULL DEFAULT 0 FLAG=1,
-cat    INT NOT NULL DEFAULT 0 FLAG=1,
-rabbit INT NOT NULL DEFAULT 0 FLAG=1,
-bird   INT NOT NULL DEFAULT 0 FLAG=1,
-fish   INT NOT NULL DEFAULT 0 FLAG=1)
-ENGINE=CONNECT TABLE_TYPE=PIVOT TABNAME=pets OPTION_LIST='PivotCol=race,groupby=1';
-SELECT * FROM pivet;
-DROP TABLE pivet;
-
---echo #
---echo # Testing the "data" column list
---echo #
-CREATE TABLE pivet (
-name VARCHAR(12) NOT NULL,
-dog  INT NOT NULL DEFAULT 0 FLAG=1,
-cat  INT NOT NULL DEFAULT 0 FLAG=1)
-ENGINE=CONNECT TABLE_TYPE=PIVOT TABNAME=pets OPTION_LIST='PivotCol=race,groupby=1';
---error ER_GET_ERRMSG
-SELECT * FROM pivet;
-ALTER TABLE pivet OPTION_LIST='PivotCol=race,groupby=1,accept=1';
-SELECT * FROM pivet;
-DROP TABLE pivet;
-
---echo #
---echo # Adding a "dump" column
---echo #
-CREATE TABLE pivet (
-name VARCHAR(12) NOT NULL,
-dog   INT NOT NULL DEFAULT 0 FLAG=1,
-cat   INT NOT NULL DEFAULT 0 FLAG=1,
-other INT NOT NULL DEFAULT 0 FLAG=2)
-ENGINE=CONNECT TABLE_TYPE=PIVOT TABNAME=pets OPTION_LIST='PivotCol=race,groupby=1';
-SELECT * FROM pivet;
-
-DROP TABLE pivet;
-DROP TABLE pets;
---remove_file $MYSQLD_DATADIR/test/expenses.txt
+let $MYSQLD_DATADIR= `select @@datadir`;

+let $PORT= `select @@port`;

+--copy_file $MTR_SUITE_DIR/std_data/expenses.txt $MYSQLD_DATADIR/test/expenses.txt

+--copy_file $MTR_SUITE_DIR/std_data/connect.ini $MYSQLD_DATADIR/test/connect.ini

+

+--echo #

+--echo # Testing the PIVOT table type

+--echo #

+CREATE TABLE expenses (

+Who  CHAR(10) NOT NULL,

+Week INT(2) NOT NULL,

+What CHAR(12) NOT NULL,

+Amount DOUBLE(8,2))

+ENGINE=CONNECT TABLE_TYPE=FIX FILE_NAME='expenses.txt' ENDING=2;

+SELECT * FROM expenses;

+

+--echo #

+--echo # Pivoting from What

+--echo #

+CREATE TABLE pivex (

+Who  CHAR(10) NOT NULL,

+Week INT(2) NOT NULL,

+Beer DOUBLE(8,2) FLAG=1,

+Car  DOUBLE(8,2) FLAG=1,

+Food DOUBLE(8,2) FLAG=1)

+ENGINE=CONNECT TABLE_TYPE=PIVOT TABNAME=expenses;

+--replace_result $PORT PORT

+--eval ALTER TABLE pivex OPTION_LIST='port=$PORT'

+SELECT * FROM pivex;

+

+--echo #

+--echo # Restricting the columns in a Pivot Table

+--echo #

+ALTER TABLE pivex DROP COLUMN week;

+SELECT * FROM pivex;

+

+--echo #

+--echo # Using a source definition

+--echo #

+DROP TABLE pivex;

+CREATE TABLE pivex (

+Who  CHAR(10) NOT NULL,

+Week INT(2) NOT NULL,

+Beer DOUBLE(8,2) FLAG=1,

+Car  DOUBLE(8,2) FLAG=1,

+Food DOUBLE(8,2) FLAG=1)

+ENGINE=CONNECT TABLE_TYPE=PIVOT

+SRCDEF='select who, week, what, sum(amount) as amount from expenses where week in (4,5) group by who, week, what';

+--replace_result $PORT PORT

+--eval ALTER TABLE pivex OPTION_LIST='PivotCol=what,FncCol=amount,port=$PORT'

+SELECT * FROM pivex;

+

+--echo #

+--echo # Pivoting from Week

+--echo #

+DROP TABLE pivex;

+CREATE TABLE pivex (

+Who  CHAR(10) NOT NULL,

+What CHAR(12) NOT NULL,

+`3` DOUBLE(8,2) FLAG=1,

+`4` DOUBLE(8,2) FLAG=1,

+`5` DOUBLE(8,2) FLAG=1)

+ENGINE=CONNECT TABLE_TYPE=PIVOT TABNAME=expenses;

+--replace_result $PORT PORT

+--eval ALTER TABLE pivex OPTION_LIST='PivotCol=Week,port=$PORT'

+SELECT * FROM pivex;

+

+--echo #

+--echo # Using scalar functions and expresssions

+--echo #

+DROP TABLE pivex;

+CREATE TABLE pivex (

+Who  CHAR(10) NOT NULL,

+What CHAR(12) NOT NULL,

+First  DOUBLE(8,2) FLAG=1,

+Middle DOUBLE(8,2) FLAG=1,

+Last   DOUBLE(8,2) FLAG=1)

+ENGINE=CONNECT TABLE_TYPE=PIVOT

+SRCDEF='select who, what, case when week=3 then ''First'' when week=5 then ''Last'' else ''Middle'' end as wk, sum(amount) * 6.56 as amnt from expenses group by who, what, wk';

+--replace_result $PORT PORT

+--eval ALTER TABLE pivex OPTION_LIST='PivotCol=wk,FncCol=amnt,port=$PORT'

+SELECT * FROM pivex;

+DROP TABLE pivex;

+DROP TABLE expenses;

+

+--echo #

+--echo # Make the PETS table

+--echo #

+CREATE TABLE pets (

+Name VARCHAR(12) NOT NULL,

+Race CHAR(6) NOT NULL,

+Number INT NOT NULL) ENGINE=MYISAM;

+INSERT INTO pets VALUES('John','dog',2);

+INSERT INTO pets VALUES('Bill','cat',1);

+INSERT INTO pets VALUES('Mary','dog',1);

+INSERT INTO pets VALUES('Mary','cat',1);

+INSERT INTO pets VALUES('Lisbeth','rabbit',2);

+INSERT INTO pets VALUES('Kevin','cat',2);

+INSERT INTO pets VALUES('Kevin','bird',6);

+INSERT INTO pets VALUES('Donald','dog',1);

+INSERT INTO pets VALUES('Donald','fish',3);

+SELECT * FROM pets;

+

+--echo #

+--echo # Pivot the PETS table

+--echo #

+CREATE TABLE pivet (

+name VARCHAR(12) NOT NULL,

+dog    INT NOT NULL DEFAULT 0 FLAG=1,

+cat    INT NOT NULL DEFAULT 0 FLAG=1,

+rabbit INT NOT NULL DEFAULT 0 FLAG=1,

+bird   INT NOT NULL DEFAULT 0 FLAG=1,

+fish   INT NOT NULL DEFAULT 0 FLAG=1)

+ENGINE=CONNECT TABLE_TYPE=PIVOT TABNAME=pets OPTION_LIST='PivotCol=race,groupby=1';

+SELECT * FROM pivet;

+DROP TABLE pivet;

+

+--echo #

+--echo # Testing the "data" column list

+--echo #

+CREATE TABLE pivet (

+name VARCHAR(12) NOT NULL,

+dog  INT NOT NULL DEFAULT 0 FLAG=1,

+cat  INT NOT NULL DEFAULT 0 FLAG=1)

+ENGINE=CONNECT TABLE_TYPE=PIVOT TABNAME=pets OPTION_LIST='PivotCol=race,groupby=1';

+--error ER_GET_ERRMSG

+SELECT * FROM pivet;

+ALTER TABLE pivet OPTION_LIST='PivotCol=race,groupby=1,accept=1';

+SELECT * FROM pivet;

+DROP TABLE pivet;

+

+--echo #

+--echo # Adding a "dump" column

+--echo #

+CREATE TABLE pivet (

+name VARCHAR(12) NOT NULL,

+dog   INT NOT NULL DEFAULT 0 FLAG=1,

+cat   INT NOT NULL DEFAULT 0 FLAG=1,

+other INT NOT NULL DEFAULT 0 FLAG=2)

+ENGINE=CONNECT TABLE_TYPE=PIVOT TABNAME=pets OPTION_LIST='PivotCol=race,groupby=1';

+SELECT * FROM pivet;

+

+DROP TABLE pivet;

+DROP TABLE pets;

+--remove_file $MYSQLD_DATADIR/test/expenses.txt