Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

dbinfo type="tables" add a filter for TABLE_TYPE

Description

lucee.runtime.type.Query qry = new QueryImpl(metaData.getTables(dbname(conn), null, StringUtil.isEmpty(pattern) ? "%" : pattern, null), "query", pageContext.getTimeZone());

https://github.com/lucee/Lucee/blob/6.0/core/src/main/java/lucee/runtime/tag/DBInfo.java#L633

TABLE_TYPE is being passed as null

TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".

add a filter parameter, coz only fetching tables is way faster

maintains the somewhat incorrect behavior of returning all objects for backwards compatibility

Attachments

1
  • 19 Mar 2021, 04:48 pm

relates to

Activity

Show:

Zac Spitzer 19 March 2021 at 17:51

Zac Spitzer 19 March 2021 at 17:08

to do feature detection for these dbinfo improvements

<cfscript> tag = getTagData("CF","DBINFO").attributes.type.description; dump(tag); feature = (tag contains "columns_minimal"); dump(feature); tag = getTagData("CF","DBINFO").attributes.type?.filter; dump(!IsNull(tag)); </cfscript>

https://trycf.com/gist/3a22bce08f82d8c061c521e9900dd93a/lucee5?theme=monokai

Zac Spitzer 19 March 2021 at 16:48
Edited

Fixed

Details

Assignee

Reporter

Labels

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Sprint

Fix versions

Priority

Created 19 March 2021 at 16:28
Updated 21 September 2023 at 06:27
Resolved 14 April 2021 at 18:19

Flag notifications