Hi Sergei,
Current 5.3 fails as follows:
http://buildbot.askmonty.org/buildbot/builders/mac-mini-x86-dbg/builds/771/steps/compile/logs/stdio
g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME='/usr/local/mysql'
-DMYSQL_DATADIR='/usr/local/mysql/var'
-DSHAREDIR='/usr/local/mysql/share/mysql'
Refer http://kb.askmonty.org/v/virtual-columns - the example
CREATE TABLE table1 (
a INT NOT NULL,
b VARCHAR(32),
c INT AS (a MOD 10) virtual,
d VARCHAR(5) AS (LEFT(b,5)) persistent);
now
SHOW FULL FIELDS FROM table1;
Field Type Collation Null Key Default Extra Privileges Comment
--
Hi Peter, all
From: Peter Laursen peter_laur...@webyog.com
Refer http://kb.askmonty.org/v/virtual-columns - the example
CREATE TABLE table1 (
a INT NOT NULL,
b VARCHAR(32),
c INT AS (a MOD 10) virtual,
d VARCHAR(5) AS (LEFT(b,5)) persistent);
now
SHOW FULL FIELDS FROM table1;
3 matches
Mail list logo