AnsweredAssumed Answered

JDBC Driver DatabaseMetaData getNumericFunctions() returns POWER instead of POW.

Question asked by MikeDever on Feb 15, 2011
Latest reply on Mar 11, 2011 by TSBear

Summary

JDBC Driver DatabaseMetaData getNumericFunctions() returns POWER instead of POW.

Product

FileMaker Pro

Version

11

Operating system version

10.6

Description of the issue

The DatabaseMetaData method should return accurate information, about the extra SQL commands that FileMaker supports.

POWER should actually be POW.

OR, You should change your none standard POW command to POWER.

Thanks

Steps to reproduce the problem

Query the JDBC DatabaseMetaData function:

-- create your connection

    Connection conn = ???



    DatabaseMetaData dmd = conn.getMetaData();


               String sNumericFunctions = dmd.getNumericFunctions();
               String[] arrParts = sNumericFunctions.split( Comma );

Expected result

FLOOR
MOD
POW
ROUND

Actual result

FLOOR
MOD
POWER
ROUND

Outcomes