You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@doris.apache.org by "wz11wz (via GitHub)" <gi...@apache.org> on 2023/12/07 07:46:28 UTC

[I] [Bug] postgresql catalog insert into 指定列名顺序失败 [doris]

wz11wz opened a new issue, #28120:
URL: https://github.com/apache/doris/issues/28120

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   2.0.2
   
   ### What's Wrong?
   
   INSERT INTO
     albite.test.t_shijianfenzhong WITH LABEL `8ec07d59-b797-409f-9725-bef84f2fefef`(yewushijian,biaozhunzhi, shujuchulishijian)
   select
     YEWUSHJ,
     BIAOZHUNZH,
     NOW(3)
   FROM
     test3.S_RILIFZH
   where
     S_RILIFZH.BIAOZHUNZH = 1
     and test3.S_RILIFZH.YEWUSHJ >= '2023-12-04 00:00:00'
      limit 10000
   
   ![image](https://github.com/apache/doris/assets/153170301/2f631095-9d79-4daa-b6d0-0822a12f1e2a)
   
   insert into 指定 列名顺序  和  select 列名顺序是一致的。但是 报错信息插入的顺序并不是指定的顺序。
   
   ### What You Expected?
   
   支持指定顺序插入
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

Re: [I] [Bug] postgresql catalog insert into 指定列名顺序失败 [doris]

Posted by "wz11wz (via GitHub)" <gi...@apache.org>.

wz11wz commented on issue #28120:
URL: https://github.com/apache/doris/issues/28120#issuecomment-1844845531

   这是来自QQ邮箱的假期自动回复邮件。您好，我最近正在休假中，无法亲自回复您的邮件。我将在假期结束后，尽快给您回复。


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

Re: [I] [Bug] postgresql catalog insert into 指定列名顺序失败 [doris]

Posted by "Yulei-Yang (via GitHub)" <gi...@apache.org>.

Yulei-Yang commented on issue #28120:
URL: https://github.com/apache/doris/issues/28120#issuecomment-1844844980

   fixed in master: https://github.com/apache/doris/pull/27855


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

Re: [I] [Bug] postgresql catalog insert into 指定列名顺序失败 [doris]

Posted by "wz11wz (via GitHub)" <gi...@apache.org>.

wz11wz commented on issue #28120:
URL: https://github.com/apache/doris/issues/28120#issuecomment-1844839103

   -- test.t_shijianfenzhong definition
   
   -- Drop table
   
   -- DROP TABLE test.t_shijianfenzhong;
   
   CREATE TABLE test.t_shijianfenzhong (
   	biaozhunzhi float4 NULL,
   	yewushijian timestamp(3) NOT NULL,
   	shujuchulishijian timestamp(3) NULL
   );


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

Re: [I] [Bug] postgresql catalog insert into 指定列名顺序失败 [doris]

Posted by "LemonLiTree (via GitHub)" <gi...@apache.org>.

LemonLiTree closed issue #28120: [Bug] postgresql  catalog  insert into 指定列名顺序失败
URL: https://github.com/apache/doris/issues/28120


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

Re: [I] [Bug] postgresql catalog insert into 指定列名顺序失败 [doris]

Posted by "wz11wz (via GitHub)" <gi...@apache.org>.

wz11wz commented on issue #28120:
URL: https://github.com/apache/doris/issues/28120#issuecomment-1844837213

   CREATE TABLE S_RILIFZH ( YEWUSHJ datetime(3) NULL COMMENT '', SHUJUCHLSHJ datetime(3) NULL COMMENT '', BIAOZHUNZH double NULL COMMENT '' ) ENGINE=OLAP UNIQUE KEY(YEWUSHJ) COMMENT '' DISTRIBUTED BY HASH(YEWUSHJ) BUCKETS 3 PROPERTIES ( "replication_allocation" = "tag.location.default: 3", "is_being_synced" = "false", "storage_format" = "V2", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false" );


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

Re: [I] [Bug] postgresql catalog insert into 指定列名顺序失败 [doris]

Posted by "wz11wz (via GitHub)" <gi...@apache.org>.

wz11wz commented on issue #28120:
URL: https://github.com/apache/doris/issues/28120#issuecomment-1844836768

   CREATE TABLE `S_RILIFZH_DELETE` ( `YEWUSHJ` datetime(3) NULL COMMENT '', `SHUJUCHLSHJ` datetime(3) NULL COMMENT '', `BIAOZHUNZH` double NULL COMMENT '' ) ENGINE=OLAP UNIQUE KEY(`YEWUSHJ`) COMMENT '' DISTRIBUTED BY HASH(`YEWUSHJ`) BUCKETS 3 PROPERTIES ( "replication_allocation" = "tag.location.default: 3", "is_being_synced" = "false", "storage_format" = "V2", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false" );


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org