Open wwwy3y3 opened 2 months ago
Describe the bug Got incorrect SQL syntax when switching to database SQL
To Reproduce Steps to reproduce the behavior:
view full SQL
show original SQL
Expected behavior The query should be successfully executed.
Screenshots I use tpch data to ask a question ("list my customers") and copy the SQL from the answer:
Copy to bigquery and run:
Generated BigQuery SQL attached below:
WITH "customer" AS ( SELECT "customer"."c_acctbal" "c_acctbal" , "customer"."c_address" "c_address" , "customer"."c_comment" "c_comment" , "customer"."c_custkey" "c_custkey" , "customer"."c_mktsegment" "c_mktsegment" , "customer"."c_name" "c_name" , "customer"."c_nationkey" "c_nationkey" , "customer"."c_phone" "c_phone" FROM ( SELECT "customer"."c_acctbal" "c_acctbal" , "customer"."c_address" "c_address" , "customer"."c_comment" "c_comment" , "customer"."c_custkey" "c_custkey" , "customer"."c_mktsegment" "c_mktsegment" , "customer"."c_name" "c_name" , "customer"."c_nationkey" "c_nationkey" , "customer"."c_phone" "c_phone" FROM ( SELECT "c_acctbal" "c_acctbal" , "c_address" "c_address" , "c_comment" "c_comment" , "c_custkey" "c_custkey" , "c_mktsegment" "c_mktsegment" , "c_name" "c_name" , "c_nationkey" "c_nationkey" , "c_phone" "c_phone" FROM "wrenai"."tpch_tiny"."customer" "customer" ) "customer" ) "customer" ) SELECT "c_name" "customer_name" FROM "customer"
Container Logs You can execute the following command to get the logs of containers and provide them here:
docker logs wrenai-wren-ui-1 >& wrenai-wren-ui.log && \ docker logs wrenai-wren-ai-service-1 >& wrenai-wren-ai-service.log && \ docker logs wrenai-wren-engine-1 >& wrenai-wren-engine.log && \ docker logs wrenai-ibis-server-1 >& wrenai-ibis-server.log
Attached privately in DM.
Desktop (please complete the following information):
Wren AI Information
Describe the bug Got incorrect SQL syntax when switching to database SQL
To Reproduce Steps to reproduce the behavior:
view full SQL
show original SQL
Expected behavior The query should be successfully executed.
Screenshots I use tpch data to ask a question ("list my customers") and copy the SQL from the answer:
Copy to bigquery and run:
Generated BigQuery SQL attached below:
Container Logs You can execute the following command to get the logs of containers and provide them here:
Attached privately in DM.
Desktop (please complete the following information):
Wren AI Information