| "use strict";(self.webpackChunkdoris_website=self.webpackChunkdoris_website||[]).push([[73357],{15680:(r,e,n)=>{n.d(e,{xA:()=>c,yg:()=>f});var a=n(296540);function t(r,e,n){return e in r?Object.defineProperty(r,e,{value:n,enumerable:!0,configurable:!0,writable:!0}):r[e]=n,r}function i(r,e){var n=Object.keys(r);if(Object.getOwnPropertySymbols){var a=Object.getOwnPropertySymbols(r);e&&(a=a.filter((function(e){return Object.getOwnPropertyDescriptor(r,e).enumerable}))),n.push.apply(n,a)}return n}function l(r){for(var e=1;e<arguments.length;e++){var n=null!=arguments[e]?arguments[e]:{};e%2?i(Object(n),!0).forEach((function(e){t(r,e,n[e])})):Object.getOwnPropertyDescriptors?Object.defineProperties(r,Object.getOwnPropertyDescriptors(n)):i(Object(n)).forEach((function(e){Object.defineProperty(r,e,Object.getOwnPropertyDescriptor(n,e))}))}return r}function s(r,e){if(null==r)return{};var n,a,t=function(r,e){if(null==r)return{};var n,a,t={},i=Object.keys(r);for(a=0;a<i.length;a++)n=i[a],e.indexOf(n)>=0||(t[n]=r[n]);return t}(r,e);if(Object.getOwnPropertySymbols){var i=Object.getOwnPropertySymbols(r);for(a=0;a<i.length;a++)n=i[a],e.indexOf(n)>=0||Object.prototype.propertyIsEnumerable.call(r,n)&&(t[n]=r[n])}return t}var o=a.createContext({}),y=function(r){var e=a.useContext(o),n=e;return r&&(n="function"==typeof r?r(e):l(l({},e),r)),n},c=function(r){var e=y(r.components);return a.createElement(o.Provider,{value:e},r.children)},u="mdxType",d={inlineCode:"code",wrapper:function(r){var e=r.children;return a.createElement(a.Fragment,{},e)}},p=a.forwardRef((function(r,e){var n=r.components,t=r.mdxType,i=r.originalType,o=r.parentName,c=s(r,["components","mdxType","originalType","parentName"]),u=y(n),p=t,f=u["".concat(o,".").concat(p)]||u[p]||d[p]||i;return n?a.createElement(f,l(l({ref:e},c),{},{components:n})):a.createElement(f,l({ref:e},c))}));function f(r,e){var n=arguments,t=e&&e.mdxType;if("string"==typeof r||t){var i=n.length,l=new Array(i);l[0]=p;var s={};for(var o in e)hasOwnProperty.call(e,o)&&(s[o]=e[o]);s.originalType=r,s[u]="string"==typeof r?r:t,l[1]=s;for(var y=2;y<i;y++)l[y]=n[y];return a.createElement.apply(null,l)}return a.createElement.apply(null,n)}p.displayName="MDXCreateElement"},682387:(r,e,n)=>{n.r(e),n.d(e,{assets:()=>o,contentTitle:()=>l,default:()=>d,frontMatter:()=>i,metadata:()=>s,toc:()=>y});var a=n(58168),t=(n(296540),n(15680));const i={title:"ARRAY_FIRST_INDEX",language:"zh-CN"},l=void 0,s={unversionedId:"sql-manual/sql-functions/array-functions/array-first-index",id:"sql-manual/sql-functions/array-functions/array-first-index",title:"ARRAY_FIRST_INDEX",description:"\x3c!--",source:"@site/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array-first-index.md",sourceDirName:"sql-manual/sql-functions/array-functions",slug:"/sql-manual/sql-functions/array-functions/array-first-index",permalink:"/zh-CN/docs/dev/sql-manual/sql-functions/array-functions/array-first-index",draft:!1,tags:[],version:"current",frontMatter:{title:"ARRAY_FIRST_INDEX",language:"zh-CN"},sidebar:"docs",previous:{title:"ARRAY_EXISTS",permalink:"/zh-CN/docs/dev/sql-manual/sql-functions/array-functions/array-exists"},next:{title:"ARRAY_LAST_INDEX",permalink:"/zh-CN/docs/dev/sql-manual/sql-functions/array-functions/array-last-index"}},o={},y=[{value:"array_first_index",id:"array_first_index",level:2},{value:"description",id:"description",level:3},{value:"Syntax",id:"syntax",level:4},{value:"example",id:"example",level:3},{value:"keywords",id:"keywords",level:3}],c={toc:y},u="wrapper";function d(r){let{components:e,...n}=r;return(0,t.yg)(u,(0,a.A)({},c,n,{components:e,mdxType:"MDXLayout"}),(0,t.yg)("h2",{id:"array_first_index"},"array_first_index"),(0,t.yg)("version",{since:"2.0"},(0,t.yg)("p",null,"array_first_index")),(0,t.yg)("h3",{id:"description"},"description"),(0,t.yg)("h4",{id:"syntax"},"Syntax"),(0,t.yg)("p",null,(0,t.yg)("inlineCode",{parentName:"p"},"ARRAY<T> array_first_index(lambda, ARRAY<T> array1, ...)")),(0,t.yg)("p",null,"\u4f7f\u7528lambda\u8868\u8fbe\u5f0f\u4f5c\u4e3a\u8f93\u5165\u53c2\u6570\uff0c\u5bf9\u5176\u4ed6\u8f93\u5165ARRAY\u53c2\u6570\u7684\u5185\u90e8\u6570\u636e\u8fdb\u884c\u76f8\u5e94\u7684\u8868\u8fbe\u5f0f\u8ba1\u7b97\u3002 \u8fd4\u56de\u7b2c\u4e00\u4e2a\u4f7f\u5f97 ",(0,t.yg)("inlineCode",{parentName:"p"},"lambda(array1[i], ...)")," \u8fd4\u56de\u503c\u4e0d\u4e3a 0 \u7684\u7d22\u5f15\u3002\u5982\u679c\u6ca1\u627e\u5230\u6ee1\u8db3\u6b64\u6761\u4ef6\u7684\u7d22\u5f15\uff0c\u5219\u8fd4\u56de 0\u3002"),(0,t.yg)("p",null,"\u5728lambda\u8868\u8fbe\u5f0f\u4e2d\u8f93\u5165\u7684\u53c2\u6570\u4e3a1\u4e2a\u6216\u591a\u4e2a\uff0c\u6240\u6709\u8f93\u5165\u7684array\u7684\u5143\u7d20\u6570\u91cf\u5fc5\u987b\u4e00\u81f4\u3002\u5728lambda\u4e2d\u53ef\u4ee5\u6267\u884c\u5408\u6cd5\u7684\u6807\u91cf\u51fd\u6570\uff0c\u4e0d\u652f\u6301\u805a\u5408\u51fd\u6570\u7b49\u3002"),(0,t.yg)("pre",null,(0,t.yg)("code",{parentName:"pre"},"array_first_index(x->x>1, array1);\narray_first_index(x->(x%2 = 0), array1);\narray_first_index(x->(abs(x)-1), array1);\narray_first_index((x,y)->(x = y), array1, array2);\n")),(0,t.yg)("h3",{id:"example"},"example"),(0,t.yg)("pre",null,(0,t.yg)("code",{parentName:"pre"},"mysql> select array_first_index(x->x+1>3, [2, 3, 4]);\n+-------------------------------------------------------------------+\n| array_first_index(array_map([x] -> x(0) + 1 > 3, ARRAY(2, 3, 4))) |\n+-------------------------------------------------------------------+\n| 2 |\n+-------------------------------------------------------------------+\n\nmysql> select array_first_index(x -> x is null, [null, 1, 2]);\n+----------------------------------------------------------------------+\n| array_first_index(array_map([x] -> x(0) IS NULL, ARRAY(NULL, 1, 2))) |\n+----------------------------------------------------------------------+\n| 1 |\n+----------------------------------------------------------------------+\n\nmysql> select array_first_index(x->power(x,2)>10, [1, 2, 3, 4]);\n+---------------------------------------------------------------------------------+\n| array_first_index(array_map([x] -> power(x(0), 2.0) > 10.0, ARRAY(1, 2, 3, 4))) |\n+---------------------------------------------------------------------------------+\n| 4 |\n+---------------------------------------------------------------------------------+\n\nmysql> select col2, col3, array_first_index((x,y)->x>y, col2, col3) from array_test;\n+--------------+--------------+---------------------------------------------------------------------+\n| col2 | col3 | array_first_index(array_map([x, y] -> x(0) > y(1), `col2`, `col3`)) |\n+--------------+--------------+---------------------------------------------------------------------+\n| [1, 2, 3] | [3, 4, 5] | 0 |\n| [1, NULL, 2] | [NULL, 3, 1] | 3 |\n| [1, 2, 3] | [9, 8, 7] | 0 |\n| NULL | NULL | 0 |\n+--------------+--------------+---------------------------------------------------------------------+\n")),(0,t.yg)("h3",{id:"keywords"},"keywords"),(0,t.yg)("p",null,"ARRAY,FIRST_INDEX,ARRAY_FIRST_INDEX"))}d.isMDXComponent=!0}}]); |