1 Reply Latest reply on Mar 11, 2011 1:29 PM by TSBear

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

    MikeDever

      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