Replace invalid expression

KotoriKo · August 1, 2024, 6:20am

Hi! I have a problem with my multiple replacement after updating from v0.49.14 to v0.50.18.
MS SQL with TINYINT datatype.
353675733-5b6af0b7-36b2-4c98-891b-2bb272baa9d5

After deleting custom column with dat replace function - error is gone.
Similar issues on github:

github.com/metabase/metabase

Invalid query when trying to sum values saved as string in db [v0.50.6]

opened 05:57PM - 19 Jun 24 UTC

martin-knap

Type:Bug Priority:P2 Querying/MBQL Administration/Table Metadata .Regression .Team/QueryProcessor

### Describe the bug Hello, Since the v50 i am getting errors when trying to… sum values/dates saved as string in db (mysql/snowflake) even though i changed table metadata to quantity. It was working fine before now i get this error: `Invalid query: {:stages [{:aggregation [[nil nil [nil nil ["expression returning a number"]]]]}]}` `Invalid query: {:stages [{:filters [nil [nil nil ["expression returning a date, time, or date time"]]]}]}` ### To Reproduce 1. data (numbers) saved as varchar in database table (mysql or snowflake) 2. set table metadata in metabase admin to quantity for the given field 3. trying to sum/aggregate values (icon remains as [T] before field name in UI when selecting the field) ![CleanShot 2024-06-19 at 19 52 25@2x](https://github.com/metabase/metabase/assets/96686504/b1469b1a-a872-49fc-96dd-d30de21106d9) ![CleanShot 2024-06-19 at 19 54 41@2x](https://github.com/metabase/metabase/assets/96686504/d0aceb4d-431a-40f2-94e2-e969e0a88202) ![CleanShot 2024-06-19 at 19 55 22@2x](https://github.com/metabase/metabase/assets/96686504/e053f407-e72c-446a-948d-c3cb3036a8c3) ### Expected behavior sum of text fields set to number in metabase metadata worked fine in v.0.49.x ### Logs _No response_ ### Information about your Metabase installation ```JSON metabase v0.50.6 ``` ### Severity high ### Additional context _No response_

github.com/metabase/metabase

Error replace function in editor

opened 09:23AM - 27 Jun 24 UTC

closed 10:13PM - 18 Jul 24 UTC

TOH2F

Type:Bug Priority:P1 Querying/MBQL .Backend Querying/Notebook/Custom Expression .Team/QueryProcessor

### Describe the bug The replace function works in SQL language, but does not w…ork in the matabase editor ### To Reproduce <img width="639" alt="Capture2_metabase" src="https://github.com/metabase/metabase/assets/60504041/22634e48-6f64-4292-a984-3e6af44eb7fd"> <img width="451" alt="Capture1_metabase" src="https://github.com/metabase/metabase/assets/60504041/a469f2cb-7a59-47b7-9c58-9b20c785c65c"> ### Expected behavior _No response_ ### Logs _No response_ ### Information about your Metabase installation ```JSON { "browser-info": { "language": "fr", "platform": "Win32", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Edg/126.0.0.0", "vendor": "Google Inc." }, "system-info": { "file.encoding": "UTF-8", "java.runtime.name": "OpenJDK Runtime Environment", "java.runtime.version": "11.0.23+9", "java.vendor": "Eclipse Adoptium", "java.vendor.url": "https://adoptium.net/", "java.version": "11.0.23", "java.vm.name": "OpenJDK 64-Bit Server VM", "java.vm.version": "11.0.23+9", "os.name": "Linux", "os.version": "6.1.0-15-amd64", "user.language": "en", "user.timezone": "Europe/Paris" }, "metabase-info": { "databases": [ "sqlserver", "oracle", "postgres", "mysql" ], "hosting-env": "unknown", "application-database": "postgres", "application-database-details": { "database": { "name": "PostgreSQL", "version": "13.1" }, "jdbc-driver": { "name": "PostgreSQL JDBC Driver", "version": "42.7.3" } }, "run-mode": "prod", "version": { "date": "2024-06-25", "tag": "v0.50.7", "hash": "431cd8f" }, "settings": { "report-timezone": "Europe/Paris" } } } ``` ### Severity blocking usage ### Additional context _No response_