Comments (3)
Don't see an issue here:
SQLite:
sqlite> SELECT ROW_NUMBER() OVER (ORDER BY 1) AS rows;
1
sqlite> WITH t AS (SELECT ROW_NUMBER() OVER (ORDER BY 1) AS rows) SELECT rows FROM t;
1
Postgres:
georgesittas=# SELECT ROW_NUMBER() OVER (ORDER BY 1) AS rows;
rows
------
1
(1 row)
georgesittas=# WITH t AS (SELECT ROW_NUMBER() OVER (ORDER BY 1) AS rows) SELECT rows FROM t;
rows
------
1
(1 row)
from sqlglot.
Don't see an issue here:
SQLite:
sqlite> SELECT ROW_NUMBER() OVER (ORDER BY 1) AS rows; 1 sqlite> WITH t AS (SELECT ROW_NUMBER() OVER (ORDER BY 1) AS rows) SELECT rows FROM t; 1
Postgres:
georgesittas=# SELECT ROW_NUMBER() OVER (ORDER BY 1) AS rows; rows ------ 1 (1 row) georgesittas=# WITH t AS (SELECT ROW_NUMBER() OVER (ORDER BY 1) AS rows) SELECT rows FROM t; rows ------ 1 (1 row)
i am so sorry , it's doris , write = doris
from sqlglot.
Don't see an issue here:
SQLite:
sqlite> SELECT ROW_NUMBER() OVER (ORDER BY 1) AS rows; 1 sqlite> WITH t AS (SELECT ROW_NUMBER() OVER (ORDER BY 1) AS rows) SELECT rows FROM t; 1
Postgres:
georgesittas=# SELECT ROW_NUMBER() OVER (ORDER BY 1) AS rows; rows ------ 1 (1 row) georgesittas=# WITH t AS (SELECT ROW_NUMBER() OVER (ORDER BY 1) AS rows) SELECT rows FROM t; rows ------ 1 (1 row)
I hope you can handle a request like this, there are many more, but I can learn from your pr, I'm sure I should be able to handle the others, please
from sqlglot.
Related Issues (20)
- [bug] execute sql but parse error HOT 1
- [bug] When converting SQL statements from PostgreSQL (pgsql) to MySQL, there might be issues due to differences between the two database systems that can cause the converted statements to fail when executed HOT 6
- [bug] These conversions are consistent, but not consistent in meaning , from pg to mysql HOT 2
- Better support for Snowflake `WAREHOUSE` clauses? HOT 4
- RETURNS NULL ON NULL INPUT for CREATE FUNCTION in Snowflake Dialect is not supported HOT 3
- Lambda expression with data types in Snowflake dialect
- TSQL dialect parses `tinyint` as `UTINYINT` HOT 2
- Incorrect `DATE_SUB` output in BigQuery HOT 1
- Unsupported expression type ArrayContained
- Invalid expression / Unexpected token
- doris not support ->> character , but from postgres transform the ->> character does not change HOT 3
- Add support for `CREATE STREAMLIT` HOT 1
- Add better support for `plpython3u` user-defined functions in PostgreSQL HOT 1
- Support for X-prefixed Hex Strings in Databricks HOT 2
- postgres has problems with interval dates with ago HOT 2
- rows as a keyword not be execute in mysql or doris , The others are range/else HOT 1
- doris has more keywords than mysql HOT 1
- postgres STRING_TO_ARRAY function for doris is SPLIT_BY_STRING HOT 3
- The three functions WEEKOFYEAR, DAYOFMONTH, and DAYOFWEEK were incorrectly converted in Hive.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlglot.