search

appsmithorg / appsmith

Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
https://www.appsmith.com
Apache License 2.0
32.32k stars 3.5k forks source link

[Bug]: One click query binding fails when linked to SQL table with large data volume #32725

Open rh-ovc opened 2 months ago

rh-ovc commented 2 months ago

Is there an existing issue for this?

Description

When I add a data source to a select (ui component) to a SQL table that has a lot of data, the query is created but not linked to the select. It only results in an error message.

Steps To Reproduce

  1. Create a select
  2. Choose a table sql as data source (with many rows)

Public Sample App

No response

Environment

Production

Severity

High (Blocker to building or releasing)

Issue video log

No response

Version

Self hosted - 1.19

Nikhil-Nandagopal commented 2 months ago

@rh-ovc have you considered paginating the query? https://docs.appsmith.com/build-apps/how-to-guides/display-select-options-dynamically

rh-ovc commented 2 months ago

@Nikhil-Nandagopal can't create the query. The query creation stops with a error message.

Nikhil-Nandagopal commented 2 months ago

@rh-ovc could you share a video recording of the issue please?

rh-ovc commented 2 months ago

https://github.com/appsmithorg/appsmith/assets/165778619/d909a6c9-42f5-488f-9559-3bf32bf5d87c

rh-ovc commented 2 months ago

@Nikhil-Nandagopal video added

Nikhil-Nandagopal commented 2 months ago

@rh-ovc got the issue now thanks for sharing this. You can still bind it by converting the source data to JS and writing a binding to the query

rh-ovc commented 1 month ago

@Nikhil-Nandagopal I found a workaround: Creating a new database with same tables. Create the data source and bind it to the select. Then switch database connection to the real one.