Hi Guys,
I tried creating a new table using liquibase schema in which one of the
changeset item is to create index with statement.
<ext:createIndex tableName="wcruinfo"
indexName="wcruinfo_emu_car_active_idx" where="active = TRUE" unique="true">
<column name="emucarid" />
</ext:createIndex>
I have followed the same kind of statement in ipinterface.xml on 1.6.0.
<ext:createIndex tableName="ipinterface"
indexName="ipinterface_nodeid_ipaddr_notzero_idx" where="ipaddr !=
'0.0.0.0'" unique="true">
<column name="nodeid" />
<column name="ipaddr" />
</ext:createIndex>
The index is created on the table, but the where statement is missing.
Same with ipinterface table as well. Does somebody know about this issue ??
Cheers,
Reddy.
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ
opennms-devel mailing list
To *unsubscribe* or change your subscription options, see the bottom of this
page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel
