oqgraph-dev team mailing list archive

[Arjen Lentz <arjen@xxxxxxxxxxxxx>]

In SHOW CREATE TABLE output, I reckon the option quoting is wrong. It shouldn't be quoted at all but definitely backticks are bad since they're not identifiers.


mysql> show create table graph\G
*************************** 1. row ***************************
       Table: graph
Create Table: CREATE TABLE `graph` (
  `latch` smallint(5) unsigned DEFAULT NULL,
  `origid` bigint(20) unsigned DEFAULT NULL,
  `destid` bigint(20) unsigned DEFAULT NULL,
  `weight` double DEFAULT NULL,
  `seq` bigint(20) unsigned DEFAULT NULL,
  `linkid` bigint(20) unsigned DEFAULT NULL,
  KEY `latch` (`latch`,`origid`,`destid`) USING HASH,
  KEY `latch_2` (`latch`,`destid`,`origid`) USING HASH
) ENGINE=OQGRAPH DEFAULT CHARSET=latin1 `data_table`='graph_base' `origid`='origid' `destid`='destid'


-- 
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Australian peace of mind for your MySQL/MariaDB infrastructure.

Follow us at http://openquery.com/blog/ & http://twitter.com/openquery