Ecosyste.ms: Issues

An open API service for providing issue and pull request metadata for open source projects.

GitHub / OHDSI/SqlRender issues and pull requests

#368 - fix duckdb adding years + test

Pull Request - State: closed - Opened by egillax 18 days ago - 1 comment

#366 - DATEADD SQL translation possibly incorrect for Databricks/Spark

Issue - State: closed - Opened by ablack3 about 1 month ago - 13 comments

#365 - HINTs are not translated?

Issue - State: closed - Opened by gowthamrao about 1 month ago - 2 comments

#364 - translate function crashing R

Issue - State: open - Opened by antonbarchuk about 2 months ago - 6 comments

#363 - Fix #362

Pull Request - State: closed - Opened by TomWhite-MedStar about 2 months ago

#359 - listSupportedDialects() function

Issue - State: open - Opened by pharmlovex 5 months ago - 2 comments

#358 - add duckdb NEWID() mapping and a test

Pull Request - State: closed - Opened by egillax 5 months ago

#357 - duckdb NEWID() is translated wrong

Issue - State: open - Opened by egillax 5 months ago

#356 - Handle ADD COLUMN with DEFAULT for spark dialect

Pull Request - State: closed - Opened by ganisimov 6 months ago

#355 - Fixes replacement patters for spark and sqlite

Pull Request - State: closed - Opened by MaximMoinat 6 months ago

#353 - [SECURITY] Use HTTPS to resolve dependencies in Maven Build

Pull Request - State: closed - Opened by JLLeitschuh 7 months ago

#352 - Possible heavy recursion?

Issue - State: open - Opened by schuemie 7 months ago - 3 comments

#351 - Invalid sqlite date rendering CAST AS DATE, DATEDIFF and DATEADD

Issue - State: open - Opened by MaximMoinat 8 months ago - 1 comment

#350 - cannot install: reference to i386 java in sqlRender?

Issue - State: closed - Opened by MPagel 8 months ago - 1 comment

#346 - Install hangs on Databricks DBR 13.0 and higher

Issue - State: closed - Opened by danielsparing 9 months ago - 3 comments

#345 - Feature request: Add support for datetime calculations

Issue - State: open - Opened by TomWhite-MedStar 9 months ago - 5 comments
Labels: enhancement

#344 - Remove delete/insert translation rules for Databricks

Pull Request - State: closed - Opened by anthonysena 9 months ago - 1 comment

#342 - With synapse as target, IIF() is not translated resulting in SQL error

Issue - State: closed - Opened by pasirikala 11 months ago - 1 comment

#341 - Correct translation of quotes (e.g for `offset` field in `nlp_note`)

Issue - State: open - Opened by ablack3 11 months ago - 10 comments
Labels: bug

#340 - date add syntax used in Circe produces error with duckdb

Issue - State: closed - Opened by ablack3 about 1 year ago - 5 comments

#339 - MariaDB Syntax

Issue - State: closed - Opened by abbynewbury about 1 year ago - 1 comment

#338 - Update replacementPatterns.csv

Pull Request - State: closed - Opened by javier-gracia-tabuenca-tuni about 1 year ago - 2 comments

#336 - SqlRender fails in Spark for Heracles #200

Issue - State: closed - Opened by TomWhite-MedStar about 1 year ago - 2 comments
Labels: bug

#335 - Standardize build tooling and common libs

Issue - State: closed - Opened by ecruz165 about 1 year ago

#334 - Updated maven libraries to use latest versions of libraries.

Pull Request - State: closed - Opened by ecruz165 about 1 year ago - 1 comment

#333 - Postgresql column rename needs translation with TYPE keyword

Issue - State: closed - Opened by azimov about 1 year ago

#332 - Postgresql translate ALTER COLUMN TYPE

Pull Request - State: closed - Opened by azimov about 1 year ago - 1 comment

#331 - Snowflake `ceiling()`

Pull Request - State: closed - Opened by Tsemharb about 1 year ago - 2 comments

#330 - SqlRender change broke Atlas Characterizations on Spark (DataBricks)

Issue - State: closed - Opened by TomWhite-MedStar about 1 year ago - 7 comments

#329 - Add `Ceiling()` Function to replacement patterns in Snowflake

Issue - State: closed - Opened by Tsemharb about 1 year ago - 1 comment

#328 - adding ceiling() to snowflake

Pull Request - State: closed - Opened by Tsemharb about 1 year ago - 1 comment

#327 - Problematic `TO_DATE` using Oracle

Issue - State: closed - Opened by tlecarrour-ee over 1 year ago - 2 comments

#326 - `missing right parenthesis` on Oracle 19

Issue - State: closed - Opened by tlecarrour-ee over 1 year ago - 2 comments

#325 - Adding missed "drop table" statements for Netezza

Pull Request - State: closed - Opened by ssuvorov-fls over 1 year ago - 3 comments

#324 - added charindex translation for bq

Pull Request - State: closed - Opened by javier-gracia-tabuenca-tuni over 1 year ago - 1 comment

#321 - RAND() works differently in SQL Server and SQLite

Issue - State: closed - Opened by SulevR over 1 year ago - 2 comments

#320 - Fixes reordering of columns during insert for spark

Pull Request - State: closed - Opened by ssuvorov-fls over 1 year ago - 1 comment

#319 - Replacement for float keyword for snowflake was removed

Pull Request - State: closed - Opened by ssuvorov-fls over 1 year ago - 4 comments

#318 - Translate WITH INSERT into INSERT WITH for Snowflake

Pull Request - State: closed - Opened by troels over 1 year ago

#317 - Rewrite of WITH ... INSERT for Snowflake

Issue - State: closed - Opened by troels over 1 year ago - 2 comments

#316 - Oracle: BIGINT to NUMBER(38) rather than NUMBER(19)

Issue - State: closed - Opened by donny-son over 1 year ago - 2 comments
Labels: question

#315 - Redshift isnumeric

Issue - State: closed - Opened by alondhe over 1 year ago - 5 comments

#314 - Drop all support for Spark

Issue - State: closed - Opened by schuemie over 1 year ago - 5 comments
Labels: enhancement

#313 - BigQuery: problem with space in column name

Issue - State: closed - Opened by pjlammertyn over 1 year ago - 3 comments

#312 - Bigquery: multiple counts in select error

Issue - State: closed - Opened by pjlammertyn over 1 year ago - 2 comments

#311 - v1.11.0 release indicates "v1.10.0-SNAPSHOT" in pom.xml

Issue - State: closed - Opened by konstjar over 1 year ago - 1 comment

#310 - Bigquery: "intersect" not correctly converted

Issue - State: closed - Opened by pjlammertyn over 1 year ago - 4 comments
Labels: bug

#309 - Bigquery: Parameterized types are not allowed in CAST expressions.

Issue - State: closed - Opened by pjlammertyn over 1 year ago - 3 comments

#308 - Spark identifier quotation

Issue - State: closed - Opened by MaximMoinat over 1 year ago - 2 comments

#307 - SELECT INTO with 2 CTEs causes translation failure on Spark

Issue - State: closed - Opened by schuemie over 1 year ago - 2 comments
Labels: bug

#306 - Support for `DROP TABLE IF EXISTS` on `SqlServer`

Issue - State: closed - Opened by azimov over 1 year ago - 1 comment

#305 - Spark CTAS pattern

Issue - State: closed - Opened by alondhe almost 2 years ago - 1 comment
Labels: bug

#304 - INSERT INTO translated to CREATE TABLE

Issue - State: closed - Opened by MaximMoinat almost 2 years ago - 5 comments
Labels: bug

#303 - Postgresql "a space" not supported.

Issue - State: closed - Opened by yongyonglee almost 2 years ago - 3 comments

#302 - added NEWID traslation for BigQuery

Pull Request - State: closed - Opened by javier-gracia-tabuenca-tuni almost 2 years ago

#300 - SqlRender documentation question on Translation to other SQL dialects

Issue - State: closed - Opened by solmazeradat almost 2 years ago - 2 comments
Labels: question

#299 - replacementPatterns.csv validation test

Pull Request - State: closed - Opened by Tsemharb almost 2 years ago - 2 comments

#298 - Incorrect translation caused by missing quotes in replacementPatterns.csv

Issue - State: closed - Opened by Tsemharb almost 2 years ago - 1 comment
Labels: bug

#297 - Azure Synapse Analytics Dedicated dialect support

Pull Request - State: closed - Opened by alex-odysseus almost 2 years ago - 1 comment

#296 - Azure Synapse Analytics Dedicated dialect support

Issue - State: closed - Opened by alex-odysseus almost 2 years ago
Labels: enhancement

#295 - Snowflake dialect support

Pull Request - State: closed - Opened by alex-odysseus almost 2 years ago

#294 - Snowflake dialect support

Issue - State: closed - Opened by alex-odysseus almost 2 years ago
Labels: enhancement

#292 - Duck db support

Pull Request - State: closed - Opened by Tsemharb almost 2 years ago - 2 comments

#291 - loadRenderTranslateSql causes problems with devtools::test()

Issue - State: closed - Opened by ablack3 almost 2 years ago - 1 comment
Labels: duplicate

#290 - Formally define OHDSI-SQL

Issue - State: open - Opened by ablack3 almost 2 years ago - 4 comments
Labels: exploratory

#289 - Adding new Spark replacementPatterns for INSERT INTO and DELETE

Pull Request - State: closed - Opened by alibell almost 2 years ago - 1 comment

#288 - Fix #287: Remove # in temp table names on Redshift

Pull Request - State: closed - Opened by ablack3 almost 2 years ago

#287 - temp table names on Redshift may or may not start with #

Issue - State: closed - Opened by ablack3 almost 2 years ago - 2 comments

#286 - Add duckdb support

Issue - State: closed - Opened by ablack3 almost 2 years ago - 5 comments
Labels: enhancement

#285 - Added small note in README about R v4

Pull Request - State: closed - Opened by TheCedarPrince almost 2 years ago

#284 - Icons outdated for shiny app

Issue - State: closed - Opened by SevKohler almost 2 years ago - 2 comments
Labels: bug

#283 - Java import does not work with modern mvn versions

Issue - State: closed - Opened by SevKohler almost 2 years ago - 4 comments
Labels: bug, help wanted

#282 - checkmate in Imports

Issue - State: closed - Opened by jreps almost 2 years ago

#281 - checkmate dependency issue

Issue - State: closed - Opened by jreps almost 2 years ago - 1 comment
Labels: duplicate

#280 - Update replacementPatterns.csv

Pull Request - State: closed - Opened by alibell about 2 years ago - 2 comments

#279 - PostgreSQL Target Fails Assert Error

Issue - State: closed - Opened by TheCedarPrince about 2 years ago - 2 comments
Labels: bug

#278 - Update package reference for `checkmate` from suggests to imports

Issue - State: closed - Opened by wtroddy about 2 years ago - 1 comment
Labels: bug

#277 - Problem with snakeCaseToCamelCase()

Issue - State: closed - Opened by lhjohn about 2 years ago - 1 comment

#276 - Redshift IsNumeric translation issue

Issue - State: closed - Opened by katy-sadowski about 2 years ago - 2 comments

#275 - Enforce non-nullable fields for BQ dialect

Pull Request - State: closed - Opened by MichaelSchmidt82 over 2 years ago - 5 comments

#274 - Next release

Issue - State: closed - Opened by alondhe over 2 years ago - 1 comment

#272 - Sunset PDW support

Issue - State: open - Opened by schuemie over 2 years ago
Labels: exploratory, help wanted

#271 - Spark - add handle insert R wrapper

Issue - State: closed - Opened by alondhe over 2 years ago

#270 - Fixes #260, #261, #262, adds #271

Pull Request - State: closed - Opened by alondhe over 2 years ago - 4 comments

#269 - Add rules for all platforms to translate IF EXISTS

Issue - State: closed - Opened by schuemie over 2 years ago - 1 comment