[SPARK-49017] Insert statement fails when multiple parameters are being used

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.0.0, 3.5.3
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Mihailo Milosevic
• Reporter: Mihailo Milosevic
• Created: 26/Jul/24 12:50
• Updated: 27/Aug/24 11:52
• Resolved: 19/Aug/24 10:22

Description

// Create table
spark.sql("create table testtab (id int, name string)").show()

// Insert into table using single param - WORKS
spark.sql("insert into identifier(:tab) values(1, 'test1')",
  Map("tab" -> "testtab")).show()

// Select from table using param - WORKS
spark.sql("select * from identifier(:tab)",
  Map("tab" -> "testtab")).show()

// Insert into table using multiple params - FAILS
spark.sql("insert into identifier(:tab) values(2, :name)",
  Map("tab" -> "testtab", "name" -> "test2")).show() 

Issue Links

• links to: GitHub Pull Request #47501
• links to: GitHub Pull Request #47814
• links to: GitHub Pull Request #47886