|
340 KB
![]() |
20 KB
![]() |
28 KB
Two more cases for QA to test after this fix, which are related to above issue. In case 1, select * for the range gives the results, but when substituted with column names gives blank results. In case 2 select * from given range gives results, but when substituted with column names gives Column does not exist: " _id"
1. Still blanks for #1. When user opens the Excel and gives the cell as the exact values, no results are returned. Is the intended behavior ?
2. Is there any fix for the 2 scenarios added as comment ?
1. Still blanks for #1. When user opens the Excel and gives the cell as the exact values, no results are returned. Is the intended behavior ?
2. Is there any fix for the 2 scenarios added as comment ?
Also, try these use cases with the niels-baseball.xls
select * from "baseball".TEST
go
SELECT * FROM "baseball".TEST$E2:N11
GO
SELECT _id,CITY,colors FROM "baseball".TEST$E2:N11
GO
SELECT CITY,colors FROM "baseball".TEST$E2:N11
GO
SELECT _id,CITY,colors FROM "baseball".TEST$E2:N11
go
SELECT NO_HEADER_ROW CITY,colors FROM "baseball".TEST$E2:N11
GO
SELECT NO_HEADER_ROW * FROM "baseball".TEST$E2:N11
Also, try these use cases with the niels-baseball.xls
select * from "baseball".TEST
go
SELECT * FROM "baseball".TEST$E2:N11
GO
SELECT _id,CITY,colors FROM "baseball".TEST$E2:N11
GO
SELECT CITY,colors FROM "baseball".TEST$E2:N11
GO
SELECT _id,CITY,colors FROM "baseball".TEST$E2:N11
go
SELECT NO_HEADER_ROW CITY,colors FROM "baseball".TEST$E2:N11
GO
SELECT NO_HEADER_ROW * FROM "baseball".TEST$E2:N11
Issue #11929 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 15.0-dev-351 |
No time estimate |
Two more cases for QA to test after this fix, which are related to above issue. In case 1, select * for the range gives the results, but when substituted with column names gives blank results. In case 2 select * from given range gives results, but when substituted with column names gives Column does not exist: " _id"