Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.1.13
-
Windows 7 Professional x64. Intel Core i5 6200.
Used Ram: 3.7 GB from 8 GB.
Using HeidiSQL 9.1.0.4867, credentials stored since the beginning of the session on 127.0.0.1
Description
/* Error occurs at the end of this example */
|
DROP TABLE IF EXISTS visitors; |
CREATE TABLE visitors ( |
año CHAR(4) NOT NULL, |
Jan INT(10) NOT NULL DEFAULT 0, |
Feb INT(10) NOT NULL DEFAULT 0, |
Mar INT(10) NOT NULL DEFAULT 0, |
Apr INT(10) NOT NULL DEFAULT 0, |
May INT(10) NOT NULL DEFAULT 0, |
Jun INT(10) NOT NULL DEFAULT 0, |
Jul INT(10) NOT NULL DEFAULT 0, |
Aug INT(10) NOT NULL DEFAULT 0, |
Sep INT(10) NOT NULL DEFAULT 0, |
_Oct INT(10) NOT NULL DEFAULT 0, |
Nov INT(10) NOT NULL DEFAULT 0, |
Dic INT(10) NOT NULL DEFAULT 0 |
) ENGINE = CONNECT; |
INSERT INTO visitors VALUES |
('2015', 121, 172, 199, 181, 108, 199, 171, 156, 170, 183, 105, 176), |
('2014', 167, 108, 137, 161, 198, 104, 129, 132, 172, 167, 119, 196), |
('2013', 120, 116, 117, 140, 148, 119, 154, 112, 101, 166, 131, 156), |
('2012', 189, 175, 112, 132, 127, 141, 121, 186, 165, 169, 148, 136), |
('2011', 134, 162, 108, 158, 163, 144, 129, 116, 193, 117, 105, 176); |
DROP TABLE IF EXISTS xvisitors; |
CREATE TABLE xvisitors ( |
año CHAR(4) NOT NULL, |
_month CHAR(3) NOT NULL, |
number INT(10) NOT NULL |
) ENGINE=CONNECT TABLE_TYPE=OCCUR |
tabname=visitors
|
option_list='OccurCol=number,RankCol=_month' |
Colist='Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,_Oct,Nov,Dic'; |
|
SELECT * FROM xvisitors; |
DROP TABLE IF EXISTS xvisitors2; |
CREATE TABLE xvisitors2 ( |
_year char(4) NOT NULL, |
_month char(4) NOT NULL, |
number int(10) NOT NULL |
) engine = CONNECT; |
INSERT INTO xvisitors2 SELECT * FROM xvisitors; |
/*error occurs in the following line*/
|
CREATE TABLE pvisitors ENGINE=CONNECT TABLE_TYPE=PIVOT |
TABNAME=xvisitors2 Option_list='user=root password=admin'; |